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 Performance Monitoring
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 […]
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
