One of the most frequent questions which I receive from my client is about activity going inside SQL Server and how to list all sessions.
Activity Monitor and Running Query – SQL in Sixty Seconds #115
Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.
SQL SERVER – Fixing Freezing Activity Monitor
I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which was Freezing suddenly.
SQL SERVER – How to Find Free Log Space in SQL Server?
One of the most popular question on this blog is about how to shrink the log file. I have previously written about that subject on the following blogs. However, today we are not going to talk about Shrinking the log file but rather going to talk about how to monitor free log space in SQL Server.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Since I started consulting, I never had “Monday Blues” because I don’t get any weekends. I am always ready to help without time boundaries. Consulting gives me exposure to the real customer issue, learn more and blog more. This also helps me to see what customers are implementing rather than what Microsoft has provided as features. This blog is an outcome of a consulting where everything was deployed successfully, but project sign-off was pending due to an issue with log-shipping monitoring. In this blog we would learn about fixing error There was an error configuring the remote monitor server.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
Question: How to Measure Page Splits Counter Value via T-SQL?
SQL SERVER – Monitoring SQL Server Never Got This Easy
In administering SQL Server databases, the DBA is often presented with the task of identifying resource bottlenecks on the system and the sources of those bottlenecks. Also, the DBA is challenged with the task of identifying why specific queries take significant time to execute or affect the performance of other queries on the system. This allows the DBA to find opportunities to tune queries and improve their performance and the overall performance impact on the system. In this blog we will explore identifying if any disk I/O bottlenecks are present that impact query performance on the system. Such action would allow a DBA to further deal with the I/O bottleneck. Let us learn about Monitoring SQL Server.