Tag Archives for SQL Server Performance Monitoring

What do these SQL Server counters mean?

MS SQL Server tuning is very similar to any other powerful Database Management System (DBMS), with similar performance and tuning considerations. For example: 1. How effective are the memory-resident database buffers at reducing disk I/O? 2. Where have you placed the database transaction recovery log files? 3. Does the database design minimize contention for SQL […]

Read full story Comments { 0 }

Where are my SQL Server 2000 counters?

Beginning with SQL Server 2000, performance objects are named differently depending on whether you are running a single, unnamed instance of SQL Server or either a named instance or multiple instances of SQL Server. If you are installing SQL Server on a machine that is also running a previous version of SQL Server, then you must install […]

Read full story Comments { 0 }