SQL Server has had a number of really wonderful new features over the last several releases. One of those features is Accelerated Database Recovery. This enhancement has received some coverage in the community and I want to make my own contribution to promoting this feature. What is Accelerated Database Recovery? Accelerated Database Recovery (ADR) came…
Read more
Low disk space alerts are a common occurrence in I.T. For SQL Server consultants, there could be a few causes: This last scenario related to volume shadow service is what I want to talk about today. This one can be a little confusing at first because your organization may get a low disk space alert…
Read more
Why should you monitor your SQL Servers? You can’t manage what you don’t know about. You can’t improve what you’re not measuring. If you have SQL Servers installed somewhere that people have forgotten about, and you probably do if you haven’t used an automated tool to scan for them, then you can’t manage them. You…
Read more
I understand that people are busy and just need things to work. So, when there’s a performance problem with SQL Server, it can seem like the best, fastest way to get things working again is to restart the SQL Server service, or even reboot the machine. This is an even more attractive option when you’re…
Read more
The resource_semaphore wait can have devastating consequences for SQL Server performance. This wait essentially means that some of the queries in your workload have memory grants that are larger than the memory for the server can support. When that happens, the SQL Server feels like it is frozen and unresponsive. Queries are likely running, but…
Read more
We’ve been learning about SQL Server Query Store lately. We’ve delved into a few benefits of the feature, as well as how to enable it. In today’s post, we’ll discover how this feature can play a role in maturing your SQL Server environment. A Refresher on the SQL Server Maturity Curve First, let’s remind ourselves…
Read more
In my previous post about Query Store, I wrote about the four key benefits to enabling Query Store. Now that I’ve convinced you to turn it on, how do you do that? One thing to point out is that in SQL Server 2022 and above, when creating a new database from the SSMS GUI or…
Read more
Query Store has been around since SQL Server 2016, but its full potential often goes untapped. Some companies were initially wary of it after some edge case problems arose during its initial rollout. However, since its initial release, Query Store has undergone numerous enhancements and is rapidly establishing itself as one of the most significant…
Read more
Recent Comments