Page History

To configure SQL Server (Advanced Metrics) monitors, do the following:

1. In the SQL Server (Advanced Metrics) monitor template, complete the monitor information fields.
   To learn how to configure monitor information fields, see Monitor Identification.

2. In the Instance field, type the name of the SQL server instance to which you want to connect.

   Info
   If you have configured your agent to use SSL but do not select Use SSL, Uptime Infrastructure Monitor does not receive performance information.

3. Complete the following options by clicking the checkbox beside each option, then specifying a warning and critical threshold.
   If the thresholds that you set are exceeded, then Uptime Infrastructure Monitor generates an alert. For more information, see Configuring Warning and Critical Thresholds.
   
   • Lock Wait / Sec.
     The amount of time, in seconds, to wait for a database lock. For more information about locks, see the Uptime Knowledge Base article “SQL Server Locks.”
   • Lock Requests / Sec.
     The number of new database locks and lock conversions that are requested from the lock manager every second. For more information about locks, see the Uptime Knowledge Base article “SQL Server Locks.”
   • Average Lock Wait Time
     The average time, in milliseconds, that you must wait for database locks to clear before Uptime Infrastructure Monitor sends an alert.
   • User Connections
     The number of user connections that are allowed before Uptime Infrastructure Monitor sends an alert.
     For example, a single host is running two databases. There are five users logged on to the first database and three users logged on to the second database. The total number of user connections is eight.
   • Transactions / Sec.
     In the Warning and Critical threshold fields, enter the number of transactions started for the databases across the host per second.
   • Data File(s) Size / KB
     The cumulative size of all the files in all of the databases on the host system.
     This metric is returned from the SQL Server Database object. The Database object provides such information about the database as the amount of free log space available or the number of active transactions in the database. There can be multiple instances of this object.
   • Total Latch Wait Time (ms)
     The total time, in milliseconds, that it takes to complete the latch requests that were waiting over the last second.
   • Latch Waits / Sec.
     The number of latch requests that were not immediately granted, and which waited before the grant.
   • Average Latch Wait Time (ms)
     The average time, in milliseconds, that latch requests had to wait before the grant.
   • Maximum Workspace Memory (KB)
     The maximum amount of memory, in kilobytes, that the server has available to execute such processes as sort, bulk copy, hash, and index creation.
     This metric is returned by the SQL Server Memory Manager object, which monitors overall server memory usage. By monitoring overall server memory usage, you can determine whether:
     
     • Bottlenecks exist due to a lack of available physical memory for storing frequently accessed data in cache. If so, SQL Server must retrieve the data from the disk.
     • You can improve query performance by adding more memory or by making more memory available to the data cache or to SQL Server internal structures.
   • Connection Memory (KB)
     The total amount of dynamic memory, in kilobytes, that the server is using to maintain connections.
   • SQL Cache Memory (KB)
     The amount of memory, in kilobytes, that the server is using for the dynamic SQL cache.
   • Total Server Memory (KB)
     The total amount of committed memory from the buffer pool, in kilobytes, that the server is using.
   • Response Time
     Enter the Warning and Critical Response Time thresholds. If the amount of time taken to perform a check exceeds the defined thresholds, it could indicate a problem that requires investigation.
4. To save the data from the thresholds for graphing or reporting, click the Save for Graphing checkbox beside each of the metrics that you selected in step 3.
5. Complete the following settings:
   
   • Timing Settings (see Adding Monitor Timing Settings Information for more information)
   • Alert Settings (see Monitor Alert Settings for more information)
   • Monitoring Period settings (see Monitor Timing Settings for more information)
   • Alert Profile settings (see Alert Profiles for more information)
   • Action Profile settings (see Action Profiles for more information)
6. Click Finish.