Database Reference
In-Depth Information
For example, to add the performance counter SQLServer:Latches:Total Latch Wait Time(ms), follow these steps:
1.
Select the option Select Counters from Computer and specify the computer name running
SQL Server in the corresponding entry field.
2.
Click the arrow next to the performance object SQLServer:Latches.
3.
Choose the Total Latch Wait Time(ms) counter from the list of performance counters.
4.
Click the Add button to add this performance counter to the list of counters to be added.
5.
Continue as needed with other counters. When finished, click the OK button.
When creating a reusable list for your baseline, you can repeat the preceding steps to add all the performance
counters listed in Table
5-1
.
Table 5-1.
Performance Monitor Counters to Analyze SQL Server Performance
Object(lnstance[,lnstanceN])
Counter
Memory
Available MBytes
Pages/sec
PhysicalDisk(Data-disk, Log-disk)
% Disk Time
Current Disk Queue Length
Disk Transfers/sec
Disk Bytes/sec
Processor(_Total)
% Processor Time
% Privileged Time
System
Processor Queue Length
Context Switches/sec
Network Interface(Network card)
Bytes Total/sec
Network Segment
% Net Utilization
SQLServer:Access Methods
FreeSpace Scans/sec
Full Scans/sec
SQLServer:Buffer Manager
Buffer cache hit ratio
SQLServer:Latches
Total Latch Wait Time (ms)
SQLServer:Locks(_Total)
Lock Timeouts/sec
Lock Wait Time (ms)
Number of Deadlocks/sec
SQLServer:Memory Manager
Memory Grants Pending
Target Server Memory (KB)
Total Server Memory (KB)
SQLServer:SQL Statistics
Batch Requests/sec
SQL Re-Compilations/sec
SQLServer:General Statistics
User Connections
