Counters I use for Baselining SQL Server performance

<Counter>\Memory\Available MBytes</Counter>
<Counter>\Memory\Pages/sec</Counter>
<Counter>\MSSQL$SQLINS01:Access Methods\Full Scans/sec</Counter>
<Counter>\MSSQL$SQLINS01:Buffer Manager\Buffer cache hit ratio</Counter>
<Counter>\MSSQL$SQLINS01:Buffer Manager\Page life expectancy</Counter>
<Counter>\MSSQL$SQLINS01:Buffer Manager\Page reads/sec</Counter>
<Counter>\MSSQL$SQLINS01:Buffer Manager\Page writes/sec</Counter>
<Counter>\MSSQL$SQLINS01:General Statistics\User Connections</Counter>
<Counter>\MSSQL$SQLINS01:Latches\Average Latch Wait Time (ms)</Counter>
<Counter>\MSSQL$SQLINS01:Locks(_Total)\Lock Waits/sec</Counter>
<Counter>\MSSQL$SQLINS01:Locks(_Total)\Number of Deadlocks/sec</Counter>
<Counter>\MSSQL$SQLINS01:Memory Manager\Target Server Memory (KB)</Counter>
<Counter>\MSSQL$SQLINS01:Memory Manager\Total Server Memory (KB)</Counter>
<Counter>\MSSQL$SQLINS01:Transactions\Free Space in tempdb (KB)</Counter>
<Counter>\MSSQL$SQLINS01:Transactions\Transactions</Counter>
<Counter>\PhysicalDisk(3 M:)\Avg. Disk Queue Length</Counter>
<Counter>\PhysicalDisk(3 M:)\Avg. Disk sec/Read</Counter>
<Counter>\PhysicalDisk(3 M:)\Avg. Disk sec/Write</Counter>
<Counter>\PhysicalDisk(3 M:)\Disk Reads/sec</Counter>
<Counter>\PhysicalDisk(3 M:)\Disk Writes/sec</Counter>
<Counter>\Processor(_Total)\% Processor Time</Counter>
<CounterDisplayName>\Memory\Available MBytes</CounterDisplayName>
<CounterDisplayName>\Memory\Pages/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Access Methods\Full Scans/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Buffer Manager\Buffer cache hit ratio</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Buffer Manager\Page life expectancy</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Buffer Manager\Page reads/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Buffer Manager\Page writes/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:General Statistics\User Connections</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Latches\Average Latch Wait Time (ms)</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Locks(_Total)\Lock Waits/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Locks(_Total)\Number of Deadlocks/sec</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Memory Manager\Target Server Memory (KB)</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Memory Manager\Total Server Memory (KB)</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Transactions\Free Space in tempdb (KB)</CounterDisplayName>
<CounterDisplayName>\MSSQL$SQLINS01:Transactions\Transactions</CounterDisplayName>
<CounterDisplayName>\PhysicalDisk(3 M:)\Avg. Disk Queue Length</CounterDisplayName>
<CounterDisplayName>\PhysicalDisk(3 M:)\Avg. Disk sec/Read</CounterDisplayName>
<CounterDisplayName>\PhysicalDisk(3 M:)\Avg. Disk sec/Write</CounterDisplayName>
<CounterDisplayName>\PhysicalDisk(3 M:)\Disk Reads/sec</CounterDisplayName>
<CounterDisplayName>\PhysicalDisk(3 M:)\Disk Writes/sec</CounterDisplayName>
<CounterDisplayName>\Processor(_Total)\% Processor Time</CounterDisplayName>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: