Top 10 Performance Monitor counters

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Performance Monitoring and Tuning Using traces in SQL Server Profiler SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Data restoration and DB property management Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Troubleshooting Distributed Transaction Coordinator errors in SQL Server Clearing the Windows page file and its effect on server performance Optimizing SQL Server indexes –- even when they're not your indexes Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works Database Management and Administration Password cracking tools for SQL Server Using traces in SQL Server Profiler Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server How SQL Server 2008 components impact SharePoint implementations Troubleshooting Distributed Transaction Coordinator errors in SQL Server Achieving high availability and disaster recovery with SharePoint databases Clearing the Windows page file and its effect on server performance Deploying a SQL Server virtual appliance for Microsoft Hyper-V

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

e of all page files that are in use The higher the page-file usage, the more memory is needed to support the system in excess of the physical memory on the server
5 PhysicalDisk -- Avg. disk queue length The number of read and write requests that are queued for the physical disk subsystem The higher the average disk queue length, the more resources are waiting for earlier requests to finish prior to fulfilling their request
6 SQL Server: General statistics -- user connections The number of users on the system The lower the number of users indicates that the server is unable to support the system load
7 Network interface bytes Total/sec The bytes sent and received over a single network card Determine if excessive network traffic is occurring on a network card or if the system has issues isolated on the SQL Server with no network traffic
8 SQL Server: locks -- Lock waits/sec -- _Total The lock request waits per second Determine if excessive locking is limiting resources for users to access the system
9 System -- Threads The number of threads on the computer Determine if the number of threads greatly exceeds the typical baseline indicating more processes are occurring on the system
10 System -- Context Switches/sec The number of processes that are changing threads per second The higher the context switching, the more the server is stressed

Stay tuned for Jeremy Kadlec's next tip on performance baselining.

About the author: Jeremy Kadlec is the principal database engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server users groups and nationally at SQL PASS. Kadlec is the SearchSQLServer.com Performance Tuning expert. Ask him a question here.

More information from SearchSQLServer.com