Tag Archives for SQL

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 }

If I am running multiple instances of SQL Server, how do I figure out which instance of the sqlservr.exe process data maps to which SQL Server instance?

On machines where multiple instances of SQL Server are installed, you will see multiple instances of the sqlservr.exe process running. You will need a procedure for associating the performance data at the SQL Server process level — which provides processor utilization statistics and overall memory consumption — with the SQL Server performance counters for that […]

Read full story Comments { 0 }