It also makes it easier to delete a management pack, because you must delete any dependencies before you can delete a management pack. If customizations for all management packs are saved in the Default Management Pack and you need to delete a single management pack, you must first delete the Default Management Pack, which also deletes customizations to other management packs. For example of the customization requiring new management pack, see “Overriding Discovery Interval” section. Security Configuration Run As Profile Name Associated and Monitors Microsoft SQL Server 2012 PDW Watcher Account Microsoft SQL Server 2012 Parallel Data Warehouse Seed Discovery. Microsoft SQL Server 2012 Parallel Data Warehouse Discovery. This account is used for discovery operations performed by Microsoft SQL Server 2012 Parallel Data Warehouse Management Pack. Microsoft SQL Server 2012 PDW Action Account Microsoft SQL Server 2012 Parallel Data Warehouse Nodes and Components Discovery. All management pack monitors. This account is used for all operations requiring direct access to Microsoft SQL Server 2012 Parallel Data Warehouse. Low privilege environment setup Overview This section describes how to configure the Microsoft SQL Server 2012 Parallel Data Warehouse management pack for least privilege access to the environment. Setting up a least privilege environment Configuring Active Directory In Active Directory create domain user that will be used for low-privilege access to WMI: PDWWatcher
Configuring Run-As profile in System Center In order, to configure System Center you have to perform following steps: Create Run As account for “PDWWatcher” domain user and map it to “Microsoft SQL Server 2012 PDW Watcher Account”. Create Run As account for “monitoring_user” PDW user and map it to “Microsoft SQL Server 2012 PDW Action Account”. Here’s detailed instructions on how you can do this: Create “PDW Watcher” Run As account with “Windows” account type for “PDWWatcher” domain user. Navigate to Administration pane, right-click on the Run As Configuration -> Accounts and select Create Run As Account… New Create Run As Account Wizard dialog will pop-up. On the Introduction page click Next. On the General Properties page select Windows Run As Account type and specify “PDW Watcher” as Display name. On the Credentials page provide “PDWWatcher” domain user credentials. On the Distribution Security page select Less secure and click Create button to finish. If you decide to use More secure option you have to manually specify computers to which credentials will be distributed. For doing this, after creating Run As account right-click on it and select Properties. Navigate to Distribution tab and Add desired computers. Set the “Microsoft SQL Server 2012 PDW Watcher Account” profile to use “PDW Watcher” Run As account. Navigate to Administration -> Run As Configuration -> Profiles. Look for “Microsoft SQL Server 2012 PDW Watcher Account” in the list, right-click it and select Properties. Run As Profile Wizard dialog will pop-up. Skip the Introduction page by clicking Next. On the General Properties page click Next.
SQL 2012 PDW Cooling Component Group Discovery Information Interval Enabled When to Enable 4 hours True not applicable SQL 2012 PDW Power Supply Component Group Discovery Information Interval Enabled When to Enable 4 hours True not applicable SQL 2012 PDW Server Processing Component Group Discovery Information Interval Enabled When to Enable 4 hours True not applicable SQL 2012 PDW Network Adapter Component (Network group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable Related Monitors Monitor Data source Interval Alert Reset Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse 15 True Alert priority: Normal Automatic none True not applicable
States Provider Alert severity: Warning Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 True Alert priority: Normal Alert severity: Warning Automatic none True not applicable
Related Monitors Monitor Data source Interval Alert Reset Behavior Corresponding Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW Resource Group Component (Cluster group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable
Related Monitors Monitor Data source Interval Alert Behavior Corresponding Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Automatic none True not applicable SQL 2012 PDW Cluster Shared Volume Component (Cluster group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable
Related Monitors Monitor Data source Interval Reset Behavior Corresponding Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Automatic none True not applicable SQL 2012 PDW Application Heartbeat Component (Software group) Discovery Information Interval Enabled When to Enable
Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW External Storage Component (Storage External group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable Related Monitors Monitor Data source Interval Alert Reset Behavior Corresponding Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data 15 minutes True Alert priority: Normal Automatic none True not applicable
Warehouse Components States Provider Alert severity: Warning Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW External Storage Virtual Disk Component (Storage External group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable Related Monitors Monitor Data source Interval Alert Reset Behavior Corresponding Rule Enabled When to Enable Unknown Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable
Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True priority: Normal Alert severity: Warning Automatic none True not applicable SQL 2012 PDW External Disk Component (Storage External group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable
Related Monitors Monitor Data source Interval Reset Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True priority: Normal Alert severity: Warning Automatic none True not applicable Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW Internal Disk Component (Storage Internal group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable
Related Monitors Monitor Data source Interval Alert Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable
SQL 2012 PDW Internal Volume Component (Storage Internal group) Discovery Information Interval Enabled When to Enable 4 True not applicable Related Monitors Monitor Data source Interval Alert Reset Behavior Corresponding Rule Enabled When to Enable State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True priority: Normal severity: Warning Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW Internal Controller Component (Storage Internal group) Discovery Information Interval Enabled When to Enable
4 hours True not applicable Related Monitors Monitor Data source Interval Reset Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Non-Critical Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable Critical State Microsoft SQL Server 2012 Parallel 15 minutes True Alert priority: Normal Automatic none True not applicable
Data Warehouse States Provider Alert severity: Error SQL 2012 PDW Temperature Component (Cooling Discovery Information Interval Enabled When to Enable 4 hours True not applicable Related Monitors Monitor Data source Interval Alert Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True priority: Normal Alert severity: Warning Automatic none True not applicable
State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Failed State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True priority: Normal Alert severity: Warning Automatic none True not applicable Critical Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Error Automatic none True not applicable SQL 2012 PDW Cooling Device Component (Cooling group) Discovery Information Interval Enabled When to Enable 4 hours True not applicable
Related Monitors Monitor Data source Interval Alert Behavior Rule Enabled When to Enable Unknown State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal severity: Warning Automatic none True not applicable Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal severity: Warning Automatic none True not applicable State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Failed Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable
Critical State Microsoft SQL Server 2012 Parallel Data Warehouse States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable SQL 2012 PDW Power Supply component (Power Supply group) Discovery Information Interval Enabled When to Enable 4 True not applicable Related Monitors Monitor Data source Interval Alert Reset Behavior Corresponding Rule Enabled When to Enable Unknown Microsoft SQL Server 2012 Parallel Data Warehouse Components States Provider 15 minutes True Alert priority: Normal Alert severity: Warning Automatic none True not applicable Non-Critical State Microsoft SQL Server 2012 Parallel Data Warehouse 15 minutes True Alert priority: Normal Alert severity: Automatic none True not applicable