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 […]
Tag Archives for SQL Server
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 […]
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 […]
Explore the Site
From the Blog
- Windows Performance and Capacity Planning Challenges in Virtualized Environments
- Defining and Using Machine Groups in the Performance Sentry PDB
- Microsoft’s Hyper-V Performance — Introduction
- Performance Sentry Cumulative Maintenance Released
- Demand Technology Software Announces v2.4 of the Performance Sentry Web Portal
- Performance Sentry VM 2.0 now available
- Performance Sentry supports Windows Server 2012 R2 and Windows 8.1
- New Performance Objects in Windows 8 and Server 2012
- MXG and Performance Sentry for Cost Effective Windows Performance Monitoring
- Performance Sentry supports Windows Server 2012 and Windows 8
- Performance Sentry Performance Database (PDB) Data Model
