Vinod Kumar Mindmap : Counters

Performance Monitoring with SQL 2008

vinodkumar — Tue, 29 Jan 2008 13:28:00 GMT

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

SQL Counters: Series 1 (Aggregated)

vinodkumar — Thu, 17 Jan 2008 15:26:00 GMT

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...(read more)

SQL Counter: Part 14 (Avg Latch Wait Time)

vinodkumar — Wed, 16 Jan 2008 17:08:00 GMT

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...(read more)

SQL Counter: Part 13 (Avg Wait Time)

vinodkumar — Tue, 15 Jan 2008 01:51:00 GMT

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...(read more)

SQL Counter: Part 12 (Buffer Cache hit ratio)

vinodkumar — Mon, 14 Jan 2008 14:28:00 GMT

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...(read more)

SQL Counter: Part 11 (Transactions/sec)

vinodkumar — Sun, 13 Jan 2008 13:13:00 GMT

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...(read more)

SQL Counter: Part 10 (Full Scans/sec)

vinodkumar — Sat, 12 Jan 2008 14:23:00 GMT

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...(read more)

SQL Counter: Part 9 (Bytes Total)

vinodkumar — Fri, 11 Jan 2008 02:21:00 GMT

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....(read more)

SQL Counter: Part 8 (Disk Read/sec)

vinodkumar — Thu, 10 Jan 2008 13:19:00 GMT

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...(read more)

SQL Counter: Part 7 (Disk Write/sec)

vinodkumar — Wed, 09 Jan 2008 15:17:00 GMT

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...(read more)

SQL Counter: Part 6 (Idle Time)

vinodkumar — Tue, 08 Jan 2008 14:14:00 GMT

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....(read more)

SQL Counter: Part 5 (Disk Queue Length)

vinodkumar — Mon, 07 Jan 2008 13:12:00 GMT

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...(read more)

SQL Counter: Part 4 (Available MB)

vinodkumar — Sun, 06 Jan 2008 14:09:00 GMT

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...(read more)

SQL Counter: Part 3 (Pages/sec)

vinodkumar — Sat, 05 Jan 2008 14:07:00 GMT

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...(read more)

SQL Counter: Part 2 (Processor Queue Length)

vinodkumar — Fri, 04 Jan 2008 14:00:00 GMT

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...(read more)