Category: SQL Scripts

Find Top 10 SQL Server Performance Problems

Recently, I blogged about the Top 10 SQL Server Performance Tuning Tips, the things we typically see when we healthcheck SQL Servers here at Sequallity. Now, we have developed a simple script to find the top 10 SQL Server Performance Problems. The script can take between 20 seconds and 42 minutes to run, depending on the number of databases present on the SQL server. It looks at the usual suspects

Read More

How to check SQL Server Version

What version of SQL Server do I have? If you’re wondering how to check SQL Server version you are running, then wonder no more. Here at Sequallity, we want to help. And to that end here is a script to find out which version you are currently running with. This is version 1.0 of the script and I shall be adding to it over time. The script is built to

Read More

How to implement SQL Azure Activity Monitor using T-SQL

SQL Azure Database Activity Monitor (Using T-SQL) This script reveals how how to implement a SQL Azure Activity Monitor utilising T-SQL. As with everything in life, this is a good news, bad news story. The bad news is SSMS does not have Activity Monitor for SQL Azure Database and sometimes with my SQL Azure Developer hat on, I am only allowed access to the SQL Azure Database and not the

Read More