Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Database Performance Metric
|
| gptkbp:affects |
indexing
network throughput hardware resources memory pressure CPU pressure disk subsystem performance locking and blocking parallelism settings query design workload patterns |
| gptkbp:analyzes |
gptkb:DBAs
|
| gptkbp:availableOn |
gptkb:SQL_Server_2005
|
| gptkbp:canQuery |
gptkb:SQL_Server_Management_Studio
gptkb:T-SQL |
| gptkbp:commonWaitTypes |
ASYNC_NETWORK_IO
CXPACKET LCK_M_X PAGEIOLATCH SOS_SCHEDULER_YIELD |
| gptkbp:documentedIn |
gptkb:Microsoft_Docs
|
| gptkbp:excludes |
wait types with SLEEP
wait types with _PREEMPTIVE wait types with _QUEUE |
| gptkbp:helpsIdentify |
network latency
resource bottlenecks CPU pressure I/O issues blocking issues |
| https://www.w3.org/2000/01/rdf-schema#label |
SQL Server Wait Statistics
|
| gptkbp:includes |
max_wait_time_ms
signal_wait_time_ms wait_time_ms wait_type waiting_tasks_count |
| gptkbp:measures |
time SQL Server threads spend waiting for resources
|
| gptkbp:notableCollection |
gptkb:sys.dm_os_wait_stats
|
| gptkbp:relatedTo |
gptkb:sys.dm_exec_requests
gptkb:sys.dm_exec_sessions SQL Server Performance Tuning SQL Server Query Performance SQL Server Resource Governor SQL Server Wait Types sys.dm_os_waiting_tasks |
| gptkbp:resetBy |
DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR)
SQL Server restart |
| gptkbp:updated |
real time
|
| gptkbp:usedFor |
performance troubleshooting
|
| gptkbp:bfsParent |
gptkb:sys.dm_os_wait_stats
|
| gptkbp:bfsLayer |
7
|