1 DBA's Professional Blog
Having a Database Owner is not something that most people think about until something breaks. Usually, people will just kind of ignore it because it is just so innocuous and uncommon for the owner to not be “present”.
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue. Memory grants are directly linked to the queries.
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
By combining the raw power of the Extended Events engine in SQL Server with the Blocked Process Report, we are able to achieve real value in blocking monitoring.
Stability and reporting go hand in hand. You cannot truly have stability without reporting. Take the time to share the stability successes with the business. Let them revel in the successes you have brought to the enterprise data footprint.
No matter how you name it, “hairball”, “spaghetti code”, “tech debt” or “DIY code”, the result is the same – you are dealing with legacy code that nobody wants to update or maintain.