Date: Thu, 28 Mar 2024 10:07:04 +0000 (UTC) Message-ID: <1814245488.5321.1711620424322@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5320_1338878100.1711620424317" ------=_Part_5320_1338878100.1711620424317 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Uptime Infrastructure Monitor SQL Server Advanced Metri= cs monitor collects the following performance metrics from a SQL Server dat= abase:
Metric= | Explanation | Performance Obj= ect |
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 datab= ase locks and lock conversions that are requested from the lock manager eve= ry second. | SQL ServerLocks |
Average Wait Time | The average time, in mi= lliseconds, that it takes for database locks to clear. | SQL ServerLocks |
User Connections | The number of user conn= ections to the database that are allowed. | SQL ServerGeneral Stati= stics |
Transactions / Sec. | The number of transacti= ons started for the databases across the host per second. | SQL ServerDatabase |
Data File(s) Size / KB<= /td> | The cumulative size of = all the files in all of the databases on the host system. | SQL ServerDatabases |
Total Latch Wait Time= td> | The total time, in mill= iseconds, that it takes to complete the latch requests that were waiting ov= er the last second. | SQLServerLatches |
Latch Waits / Sec. | The number of latch req= uests that were not immediately granted, and which waited before being gran= ted. | SQLServerLatches |
Average Latch Wait Time= | The average time, in mi= lliseconds, that latch requests had to wait before being granted. | SQLServerLatches |
Maximum Workspace Memor= y | The maximum amount of m= emory, in kilobytes, that the server has available to execute such processe= s as sort, bulk copy, hash, and index creation. | SQL ServerMemory Manage= r |
Connection Memory | The total amount of dyn= amic memory, in kilobytes, that the server is using to maintain connections= . | SQL ServerMemory Manage= r |
SQL Cache Memory | The amount of memory, i= n kilobytes, that the server is using for the dynamic SQL cache. | SQL ServerMemory Manage= r |
Total Server Memory | The total amount of com= mitted memory from the buffer pool, in kilobytes, that the server is using.= | SQL ServerMemory Manage= r |