Baseline-SQL-Server
Get Core SQLServer Health Metrics using Dynamic SQL
| October 11, 2022
Dynamic SQL To Collect Remote SQL Server Health
Read More
Tag: Troubleshooting
Baseline-SQL-Server
Troubleshooting High CPU on SQL Server – Part 2
| October 6, 2022
Troubleshoot CPU Issue on SQL Server using SQLMonitor
Read More
Baseline-SQL-Server
Live Troubleshooting High CPU on SQL Server – Part 1
| October 3, 2022
Resolve high cpu issues on SQL Server using Open Source tools
Read More
Baseline-SQL-Server
Troubleshooting SQL Server with High Memory Grants
| September 30, 2022
Troubleshoot SQL Server Memory Related Performance Issues using Free Tools
Read More
Errors
Error/Fix: Msg 924. Get Database Out of Single User Mode
| September 23, 2022
Losing single_user database connection is painful, and this script helps to regain the database access by getting database back to multi_user mode.
Read More
Baseline-SQL-Server
SQL Server Live Health Check
| September 17, 2022
Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor
Read More
SQL Agent Job
How to Setup Blocking Alerts on SQL Server
| August 18, 2018
It’s very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when
Read More
Ola-Hallengren-Maintenance-Solution
Indexing Maintenance Solution for Replication
| July 10, 2018
Like any other DBA, I fell into the trap of using straight maintenance solution using Reorganize operation for Indexes with avg fragmentation with 30% or less with Index
Read More
Errors
Error/Fix: There is insufficient system memory in resource pool ‘default’ to run this query.
| July 7, 2018
Recently I was reading about Temporal Tables feature that has been introduced with SQL Server 2016. So, as usual, I thought to get the knowledge in practice with
Read More
Performance Tuning
Should we check [context_switches] for SQL Server Query from Performance Point
| May 27, 2018
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal.
Read More