SQL Server – DB Server Statistics
Access Methods
Free Space Scans/sec:
Description:
Number of scans per second that were
initiated to search for free space within pages already allocated to an
allocation unit to insert or modify record fragments. Each scan may find
multiple pages.
Avg = 0.148
SLA: N/A
Observation: Observe that the number of scans per sec 0.148
to free up the allocated pages.
Full Scans/sec:
Description:
Number of unrestricted full scans.
These can either be base table or full index scans.
Avg =
SLA: N/A
Observation: Observe that the number of unrestricted full
scans per sec 24.93 to free up the allocated pages at table level as well index
level. (Total DB)
Index Searches/sec:
Description:
Number of index searches. Index
searches are used to start range scans, single index record fetches, and to
reposition within an index.
Avg =
SLA: N/A
Observation: Observe that the Number of index searches per
sec 2483.62.
Buffer Manager
Buffer cache hit ratio:
Description:
Percentage of pages that were found in
the buffer pool without having to incur a read from disk.
AVG:
100%
SLA: Always
buffer cache hit ratio should be more than 95%
Observation:
Observe that the average buffer cache hit ratio is 100% which is normal in the
load test execution.
Lazy writes/sec:
Description:
Number of buffers written by buffer
manager's lazy writer.
Avg =
SLA: Always
lazy writes per second should be zero.
Observation: Observe that the average lazy writes per
second is 0 which is normal in the load test execution.
Free Pages:
Description: Total number of pages on all free lists.
Avg =
SLA: N/A
Observation:
Reserved Pages:
Description:
Number of buffer pool reserved pages.
Avg =
SLA: N/A
Observation:
Observe that the Number of buffer pool reserved pages Avg. is 121.60.
Stolen Pages:
Description:
Number of pages used for miscellaneous
server purposes (including procedure cache).
Avg = 41056.89
SLA: N/A
Observation: Observe that the Number of Number of pages
used for miscellaneous server purposes Avg. is 41056.89.
Total Pages:
Description
Number of pages in the buffer pool
(includes database, free, and stolen).
Avg =
Calculation:
Used = Total – (Free +Reserved +
Stolen)
= 58052.108 – (123.02+121.60+
41056.89)
= 16751.488
SLA: N/A
Observation:
Locks
Number of Deadlocks:
Description: Number of lock requests that resulted in a
deadlock.
Avg =
SLA: Always
dead locks per second should be zero.
SQL Errors
Errors/sec: (DB Offline Errors)
Description: Number of errors/sec
Avg
SLA: N/A
Observation:
No comments:
Post a Comment