Performance
Perfmon: SQL Server memory performance metrics – Part 2 – available bytes, total server, and target server memory
In the first part of this series, we started with most important SQL Server performance memory metrics. We described Pages/sec and Page faults/sec, what they indicated, and what the normal values were
In this part, we will present three more memory metrics that affect SQL...
Perfmon: SQL Server memory performance metrics – Part 1 – Memory pages/sec and Memory page faults/sec
In the SQL Server performance basics article, we explained why performance monitoring was important and what you should consider before you start monitoring SQL Server performance
Different environments and applications require different metrics to be measured. The first task is...
Top 10 SQL Server Counters for Monitoring SQL Server Performance
Do you have a list of SQL Server Counters you review when monitoring your SQL Server environment? Counters allow you a method to measure current performance, as well as performance over time. Identifying the metrics you like to use to measure SQL Server performance and collecting them...