Saturday, June 20, 2009
SOME SUGGESTED PERFORMANCE COUNTER MONITORING FOR SQL SERVERS
"\Memory\Available MBytes""\Memory\Free System Page Table Entries""\Memory\Pages Input/sec""\Memory\Pages/sec""\MSSQL$DEV:Access Methods\Full Scans/sec""\MSSQL$DEV:Access Methods\Page Splits/sec""\MSSQL$DEV:Access Methods\Workfiles Created/sec""\MSSQL$DEV:Access Methods\Worktables Created/sec""\MSSQL$DEV:Buffer Manager\Buffer cache hit ratio""\MSSQL$DEV:Buffer Manager\Checkpoint pages/sec""\MSSQL$DEV:Buffer Manager\Free pages""\MSSQL$DEV:Buffer Manager\Lazy writes/sec""\MSSQL$DEV:Buffer Manager\Page life expectancy""\MSSQL$DEV:Buffer Manager\Page reads/sec""\MSSQL$DEV:Buffer Manager\Page writes/sec""\MSSQL$DEV:Buffer Manager\Stolen pages""\MSSQL$DEV:General Statistics\Logins/sec""\MSSQL$DEV:General Statistics\Logouts/sec""\MSSQL$DEV:General Statistics\User Connections""\MSSQL$DEV:Latches\Average Latch Wait Time (ms)""\MSSQL$DEV:Locks(_Total)\Average Wait Time (ms)""\MSSQL$DEV:Locks(_Total)\Lock Requests/sec""\MSSQL$DEV:Locks(_Total)\Number of Deadlocks/sec""\MSSQL$DEV:Memory Manager\Target Server Memory (KB)""\MSSQL$DEV:Memory Manager\Total Server Memory (KB)""\MSSQL$DEV:SQL Statistics\Batch Requests/sec""\MSSQL$DEV:SQL Statistics\SQL Compilations/sec""\MSSQL$DEV:SQL Statistics\SQL Re-Compilations/sec""\Paging File(_Total)\% Usage""\Paging File(_Total)\% Usage Peak""\PhysicalDisk(_Total)\Avg. Disk Read Queue Length""\PhysicalDisk(_Total)\Avg. Disk sec/Read""\PhysicalDisk(_Total)\Avg. Disk sec/Transfer""\PhysicalDisk(_Total)\Avg. Disk sec/Write""\PhysicalDisk(_Total)\Avg. Disk Write Queue Length""\Process(sqlservr)\% Privileged Time""\Process(sqlservr)\% Processor Time""\Processor(_Total)\% Privileged Time""\Processor(_Total)\% Processor Time""\System\Context Switches/sec""\System\Processor Queue Length"
Thursday, June 18, 2009
First page
I just wanted to keep a diary of my DBA activities for my own record and reference.
So that I can come back later to use any of these insights for future problems.
I have finished more thatn an year at this spot so most probably I will ahve some solid lessons learnt kind of substance.
cheers
So that I can come back later to use any of these insights for future problems.
I have finished more thatn an year at this spot so most probably I will ahve some solid lessons learnt kind of substance.
cheers
Subscribe to:
Posts (Atom)