By Lori Brown | Helpful Scripts , Maintenance , SQL Administration , SQL Server
Anytime we check someone’s SQL Server for the first time, we need to find out if backups have been happening. Here are some queries that will help with that. One of my favorite queries to know when the last backup was done is from the estimable Glenn Berry’s scripts. Glenn’s SQL Server Performance – Focused […]
Continue readingBy Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server
Since I posted about jobs that run too long (Stop Jobs That Run Too Long – SQLRx), I thought I would also post about a way to have a daily failed jobs report sent to whomever needs it. One issue that seems to be prevalent on many servers is that jobs get set up and […]
Continue readingBy Jeff Horner | SQL Administration , SQL Server
One of the simplest yet most impactful performance optimizations for SQL Server is relocating the tempdb system database to a fast, dedicated disk—especially if that disk is temporary or ephemeral. This is a common practice in cloud environments and high-performance database systems where tempdb churn is high and doesn’t require persistence across reboots. In this […]
Continue readingBy Jeff Horner | Expert , SQL Administration , SQL Server , SQLRX
I have a client that has thousands of databases. They asked for a script that would tell them which databases had not been accessed in the last 90 days. I thought this would be an easy ask because we could just look at the index usage stats DMV and see which databases had no seeks, […]
Continue readingBy Lori Brown | Extended Events , SQL Administration , SQL Server
Here is a way to set up an extended events session that can be used to collect blocked processes and deadlock records. I use similar code to collect this type of data each day and have a job that pulls the data into tables which can be used to evaluate the resources that are being […]
Continue readingBy Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server
Since I seem to run across lots of questions about how to make sure that no jobs get in the way of ETL or other stressful data loads, I thought that I should post some ways you can stop jobs. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-stop-job-transact-sql?view=sql-server-ver16 I have always done this by having a monitoring job that executes on a […]
Continue readingBy Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server
On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete. I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang. Since the issue only occurred intermittently, […]
Continue readingBy Lori Brown | Log Shipping , SQL Administration , SQL Server
Log Shipping has been around a long time and it looks like it will continue to be useful and therefor supported. Since I still find Log Shipping being used, let’s talk about a T-SQL way to monitor it.
Continue readingBy Ginger Daniel | Always On , Installation , SQL Administration , SQL Server
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to our previous article https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/ , and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Add Windows Failover Cluster (WSFC) Install […]
Continue reading