Tag: Performance Troubleshooting

How to troubleshooting SQL Server Storage IO Issues using open source tool

Dynamic SQL To Collect Remote SQL Server Health

Troubleshoot CPU Issue on SQL Server using SQLMonitor

Resolve high cpu issues on SQL Server using Open Source tools

Troubleshoot SQL Server Memory Related Performance Issues using Free Tools

Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor

Remove High Virtual Log File (VLF) (@OptimizeLogFiles) This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is

Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer

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.

Hi Friends, Ever wanted to check heartbeat of SQL Server. It is very common activity for a SQL Server user to check CPU, SQL Memory Utilization, Available Memory