Performance Counters To Use in sql server

Posted Date: 03 Nov 2009	Resource Type: Articles	Category: Databases
Author: Lalji	Member Level: Diamond
Rating:	Points: 2

When choosing Performance Counters we don't just want to know how our SQL Server software is performing, we
also want to know how our hardware and network is performing. The best list of core counters that I have come
across, and have been using for years, come from an article by Brad McGehee entitled "How to Perform a SQL
Server Performance Audit ". I experiment with some other counters but always use the ones mentioned in the article
as the foundation. The counters are:

• Memory: Pages/sec
• Memory: Available Bytes
• Network Interface: Bytes Total/Sec
• Physical Disk: % Disk time
• Physical Disk: Avg. Disk Queue Length
• Processor: % Processor Time
• System: Processor Queue Length
• SQL Server Buffer: Buffer Cache Hit Ratio
• SQL Server General: User Connections

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Performance Counters To Use .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: ADO.NET
	Previous Resource: Diff between CHAR and VARCHAR datatype
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources