IDERA

article SQL Server Advanced Metrics

Related Documentation Version of up.time affected Affected Platforms
All All

The up.time SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:

Metric Explanation Performance Object
Lock Wait / Sec. The amount of time, in seconds, that the server waits for a database lock. SQL ServerLocks
Lock Requests / Sec. The number of new database locks and lock conversions that are requested from the lock manager every second. SQL ServerLocks
Average Wait Time The average time, in milliseconds, that it takes for database locks to clear. SQL ServerLocks
User Connections The number of user connections to the database that are allowed. SQL ServerGeneral Statistics
Transactions / Sec. The number of transactions started for the databases across the host per second. SQL ServerDatabase
Data File(s) Size / KB The cumulative size of all the files in all of the databases on the host system. SQL ServerDatabases
Total Latch Wait Time The total time, in milliseconds, that it takes to complete the latch requests that were waiting over the last second. SQLServerLatches
Latch Waits / Sec. The number of latch requests that were not immediately granted, and which waited before being granted. SQLServerLatches
Average Latch Wait Time The average time, in milliseconds, that latch requests had to wait before being granted. SQLServerLatches
Maximum Workspace Memory The maximum amount of memory, in kilobytes, that the server has available to execute such processes as sort, bulk copy, hash, and index creation. SQL ServerMemory Manager
Connection Memory The total amount of dynamic memory, in kilobytes, that the server is using to maintain connections. SQL ServerMemory Manager
SQL Cache Memory The amount of memory, in kilobytes, that the server is using for the dynamic SQL cache. SQL ServerMemory Manager
Total Server Memory The total amount of committed memory from the buffer pool, in kilobytes, that the server is using. SQL ServerMemory Manager

Article Info

Index: 122
Author: CSS
Created: 1-23-2007
Updated: 1-3-2012
Views: 5568
Rating:

Options

Rate This Article

Email This Article

Print This Article

Quick Links

Related Articles
User Comments

Related Articles

Oracle Advanced Metrics service monitor

RatingViews
article

This article outlines the performance metrics that the up.time Oracle Advanced Metrics monitor collects from an Oracle database.

By: uptime Support | Date Created: 1-23-2007 | Last Modified: 7-4-2011 | Index: 121

   7408

MySQL Advanced Metrics

RatingViews
article

This article outlines the metrics collected by the up.time MySQL Advanced monitor.

By: uptime Support | Date Created: 1-26-2007 | Last Modified: 7-4-2011 | Index: 126

   4836

Microsoft Exchange Performance Metrics

RatingViews
article

This article outlines the performance metrics that up.time collects from a Microsoft Exchange server.

By: uptime Support | Date Created: 1-26-2007 | Last Modified: 6-30-2011 | Index: 132

   9204

Microsoft IIS Performance Metrics

RatingViews
article

This article outlines the performance metrics that up.time collects from an IIS server.

By: uptime Support | Date Created: 1-26-2007 | Last Modified: 6-30-2011 | Index: 133

   13316

Linux Performance Metrics

RatingViews
article

This article outlines the performance metrics that are collected by the up.time Linux agent.

By: uptime Support | Date Created: 1-17-2007 | Last Modified: 2-15-2013 | Index: 117

   26800

User Comments

No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement