Page History

Follow these steps to add internal SQLDM performance custom counter alerts:

1. Go to the Administration Aministration tab in the SQL Diagnostic Manager desktop and select Custom Counters.
2. Click Add to start configuring the custom counter.
3. In the Welcome screen of the Custom counter Wizard click Next.
4. Select the Windows System Counter type, and click Next.
5. Under the Select Windows System Counter screen, select the Select a counter from an existing monitored SQL Server host (Recommended) and in the Select Counter check the Show only those counters available in Windows System Performance Monitor (Perfmon) (Recommended) option.
   1. In the SQL Server drop-down list, select the SQL Server instance where you would like to add the custom counter.

   2. In the Object Name field, select the

      SQLdmCollectionService or

      SQLdmCollectionService$Default or SQLdmManagementService $Default option to retrieve the internal counters.

      Warning
      The SQLdmCollectionService$Default or SQLdmManagementService $Default options will not appear unless you enable the SQL Diagnostic Manager performance counters.

   3. Choose the counter you preferred from the Counter Name drop-down list and click Next. Review the list of Internal SQLDM perfmon counters.
   4. Select an instance or the instances if applied.
   5. Click Next.

6. Under the Customize Counter Value screen, choose the Calculation Type by selecting either the Use collected value or the Use per second value since last collection

   (

   .

   Info
   By default, the value for a custom counter is interpreted as the value collected

   )

   .

   Also, Customize the Scale Factor by selecting the value from the drop-down list.

   1. After configuring the values Click Test... to open the Test Custom counter window.
   2. In the Test custom Counter window, select the instances to test the custom counter that is being configured, and click Test.  You can review the result of the test under the Result column.
   3. Click Done.
7. Click Next.
8. Under the Customize Counter Definition step, type a name for the counter. By default, these counters are under the Custom Category but you can select an existing category or enter a category of your own. Click Next.
9. Under the Configure Alert Settings screen, select how your counter value should be evaluated for alerting: Higher values are worse than lower values or Lower values are worse than higher values .
   1. Configure your Alert Thresholds, the values you provide for Informational, Warning, and Critical Thresholds are used as defaults and can be customized for each monitored instance.

...