Just a quick post as may help any of you searching for this. Scenario Client wants to analyze most recent deadlocks that happened on a specific instance. They asked us to send the xdl files. How do we get the deadlocks? Depending on the version of SQL Server that you are running, there are different … Continue reading Export Deadlocks to file from system_health Extended Event using PowerShell
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of art and know how cool or bad the environments are before start knocking down the bad practices. This client has seven different environments with more than 100 instances and more than 2000 databases. Serial execution … Continue reading dbachecks – Going parallel – Cut off your execution times
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm if they are in "running" state.
On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts to enrich the monitoring