SQL Server, Counters - Vinod Kumar

Performance Monitoring with SQL 2008

Check my blog post on TechNet over Performance Monitoring with SQL Server 2008 here . Feel free to pass your comments.

Posted 29 January 2008 01:28 PM by vinodkumar | with no comments

Filed under: SQL Server, Technology, Tips & Tricks, ITPro, Counters

SQL Counter: Part 1 (Processor Time) SQL Counter: Part 2 (Processor Queue Length) SQL Counter: Part 3 (Pages/sec) SQL Counter: Part 4 (Available MB) SQL Counter: Part 5 (Disk Queue Length) SQL Counter: Part 6 (Idle Time) SQL Counter: Part 7 (Disk Write...

Posted 17 January 2008 03:26 PM by vinodkumar | 1 comment(s)

Filed under: SQL Server, Counters

SQL Counter: Part 14 (Avg Latch Wait Time)

SQL Server Latches Object -> Average Latch Wait Time This counter measures the average amount of time, in milliseconds, that a latch request had to wait before it was serviced. Over time it is a good indicator for a general performance problem or if...

Posted 16 January 2008 05:08 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 13 (Avg Wait Time)

SQL Server Locks Object -> Average Wait Time This counter measures the average amount of time, in milliseconds, that a user is waiting for a lock. Over time it is a good indicator for a general performance problem or if a performance issue is specific...

Posted 15 January 2008 01:51 AM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 12 (Buffer Cache hit ratio)

SQL Server Buffer Manager Object -> Buffer Cache Hit Ratio This counter shows the percentage of pages that are found in SQL Server’s buffer pool without having to incur a read from disk. A well-balanced system will have hit ratio values greater than...

Posted 14 January 2008 02:28 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 11 (Transactions/sec)

SQL Server Database Object -> Transactions/Sec This counter measures the number of transactions started per second. Transactions are the basis of everything in SQL Server, and most queries are implicit transactions. This measurement is extremely handy...

Posted 13 January 2008 01:13 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 10 (Full Scans/sec)

SQL Server Access Methods Object -> Full Scans/Sec This counter should always be captured. It shows how often a table index is not being used and results in sequential I/O. This is defined as the number of unrestricted full scans. These can be either...

Posted 12 January 2008 02:23 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 9 (Bytes Total)

Network Interface Object -> Bytes Total/Sec This counter measures the number of bytes being transmitted per second on the NIC. There will be one instance per NIC on the machine, including one for the loopback adapter.

Posted 11 January 2008 02:21 AM by vinodkumar | 1 comment(s)

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 8 (Disk Read/sec)

PhysicalDisk Object -> Avg. Disk Sec/Read This counter measures the average time, in seconds, of a read of data from disk. If the average value increases over time, then it points to a potential read performance problem. Possible reasons can be that...

Posted 10 January 2008 01:19 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 7 (Disk Write/sec)

PhysicalDisk Object -> Avg. Disk Sec/Write This counter measures the average time, in seconds, of a write of data to disk. If the average value increases over time, then it points to a potential write performance problem. Possible reasons can be that...

Posted 09 January 2008 03:17 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 6 (Idle Time)

PhysicalDisk Object -> % Idle Time Typically, the idle time is supposedly accurate. Subtracting this from 100 gives an idea of how hard the disks are working. This can also vary deending on the type of system like OLTP, reporting or warehouse.

Posted 08 January 2008 02:14 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 5 (Disk Queue Length)

PhysicalDisk Object -> Avg. Disk Queue Length This counter measures whether I/O requests are being serviced or are waiting in the queue for the disk drive to catch up on requests. This can be a bottleneck in performance for a server in that, if it...

Posted 07 January 2008 01:12 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 4 (Available MB)

Memory Object -> Available MBytes This measurement is the amount of megabytes of memory on the computer (from the OS perspective) that is available to be allocated to processes. It's the sum of free, standby, and zeroed memory pages. Look at this to...

Posted 06 January 2008 02:09 PM by vinodkumar | 1 comment(s)

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 3 (Pages/sec)

Memory Object -> Pages/sec This counter measures the number of memory pages read from or written to disk. Defined as the number of pages read from or written to disk to resolve hard page faults. Hard page faults that occur when a process requires code...

Posted 05 January 2008 02:07 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

SQL Counter: Part 2 (Processor Queue Length)

System Object -> Processor Queue Length Watch the value over a sustained period of time to see if the CPU is a bottleneck. The counter measures how many threads are waiting for processor time. The count includes all threads that are "ready" and not...

Posted 04 January 2008 02:00 PM by vinodkumar | with no comments

Filed under: SQL Server, Misc, Counters

Vinod Kumar - ExtremeExperts.com

Browse by Tags

Search

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News