The SQLServer:Deprecated Features object in SQL Server provides a counter (Usage) to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started. This is a very costly object because it generates a lot of [...]
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 [...]
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 [...]
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 [...]
- How does the Performance Sentry collection service work?
- What is the minimum sampling period for Performance Sentry?
- “Have you ever wondered how to determine the logical disk size looking at Performance Monitor performance metrics?”
- What is the meaning of the message “Insufficient data in performance name table” in the NTSMF.LOG File?
- What is Performance Sentry and how does it relate to NTSMF?