We in the first post saw how capturing and analyzing wait statistics can help a SQL DBA to look for potential performance issue. In the second post we looked at some of the example and potential scenario of wait stats which were similar to a production environment. In this post, we will see how we … Read more
Recently I worked on an interesting scenario where an incident was reported for very low PLE value. Very low PLE value indicates memory pressure on SQL server and should be fixed to ensure good SQL server performance. First lets check the definitions of PLE and BCHR as per Microsoft BOL: Page Life Expectancy: Indicates the … Read more
In our last post, we started a journey for SQL Server DBAs so that they can establish an approach for performance tuning issue. We went through some of the basic wait types are and shared links for downloading queries to gather those. Now that you have gathered total wait statistics from a SQL Server instance, … Read more
As a SQL Server DBA one of the most important part of our job is to do performance tuning. But, as soon as some says performance tuning, most DBAs are clueless on how to start troubleshooting. There are many articles, blogs which focuses on key aspects of performance tuning. However, in this series, we will … Read more
One of my DBA friend was troubleshooting some issue on a SQL database server hosted on AWS EC2 Windows Instance. He was able to take remote desktop connection of EC2 instance. But as part of troubleshooting, he needed to see various details for that EC2 instance on AWS portal. He was able to login on … Read more