By Lori Brown | Security , SQL Server
Well…..I just learned about these and thought that it would be good to understand them a little more and have some links to read more about them. I honestly don’t have a lot of SQL 2022 servers in our customers SQL estate, so this has flown under the radar for me. This will be an […]
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 | Helpful Scripts , Indexes , Replication , SQL Server
Problem Have you ever had transactional replication mysteriously start showing significant latency at a subscriber server? If so, check to see if the primary keys from the publisher database are missing on the subscriber database! Replication was showing long latency while the publisher and subscriber servers were not heavily utilized. Microsoft generated stored procedures that […]
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 readingBy Lori Brown | Function , Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
This is kind of a continuation of one of my previous posts. (https://www.sqlrx.com/find-and-modify-file-growth-settings-for-all-databases/ ) Thousands of databases in a SQL instance can make a DBA’s life a bit challenging. Automation suddenly becomes very important. My new client had been shrinking their databases frequently, mistakenly thinking that doing so was a good thing. I needed to […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server
I have a client who is challenging me in a lot of ways. They have over a thousand databases in one of their 2 SQL instances. Over. A. Thousand. Admittedly, the databases are not big but the sheer quantity of them is daunting to say the least. To make it more fun, some of the […]
Continue reading