October 24, 2001 02:24 PM

Performance Counters

Rating: (0)
SQL Server Magazine
InstantDoc ID #22222
Installing SQL Server adds SQL Server—specific performance counters to the Windows 2000 System Monitor (Performance Monitor in Windows NT 4.0). You can use these counters with the standard Win2K or NT performance counters to keep tabs on your system's response to gradual load changes. To establish a baseline, begin system monitoring when the system is running as usual. Seven important performance counters can give you a quick idea of your SQL Server system's overall status.

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

Good basic article that plots out a starting point in perfom monitoring.

big fish 8/26/2004 11:23:26 AM


You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Special Report: Perspectives on SQL Server Sprawl
A Essential Guide by PolyServe
SQL Server 2008 Memory and CPU Highlights
A Tip Guide by Intel, Microsoft, Unisys
More

Rename Virtual Server (Cluster)

I am going to rename a clustered instance (default).1. Change SQL Network Name2. Take offline3. Bring online4. Flush DNS, Cache5. Test failover6. Rebu...222-96209

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS