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?
Not another post on shrinking the log file. Here are two ways I monitor free log space in SQL Server: DBCC SQLPERF and sys.dm_db_log_space_usage.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
Question: How to measure the Page Splits counter value via T-SQL? Here is a quick script for DBAs who would rather not open PerfMon.
SQL SERVER – Monitoring SQL Server Never Got This Easy
Monitoring SQL Server for disk I/O bottlenecks does not have to be hard. Here I use Extended Events to find I/O problems that slow down your queries.