Monitoring

Milena Petrovic

SQL Server memory performance metrics – Part 2 – available bytes, total server, and target server memory

February 21, 2014 by
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 Server performance – Available memory bytes, Total server memory, and Target server memory Read more »
Milena Petrovic

SQL Server performance monitoring with Data Collector – Part 2 – set-up and usage

February 21, 2014 by
In the previous part of this article, we described SQL Server Data Collector, its features, and pre-defined collection sets. We showed what data is collected and described the mechanisms used to collect, store, and purge the saved records. In this part, we will give detailed steps to provide all necessary pre-requests and set up Data Collector Read more »
Milena Petrovic

SQL Server performance basics

February 19, 2014 by
Monitoring is recommended in dynamic environments. When it comes to SQL Server – users, DBAs, and the system itself are performing events constantly – changing data and database structure, user privileges, etc. SQL Server can manage automatically all these requests, but its self-tuning doesn’t provide best results, and additional monitoring and manual tuning can provide better performance Read more »