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.
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations – whether they be Azure SQL or the traditional on-premises SQL Server.
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
Linked Servers can certainly provide an enigma to your finely tuned Database environment. In this article, I share how to decrypt that enigma via XEvents.
This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
This article has just shared the power of XEvents and yet another use in helping to audit the database environment for changes. Not only do we have this powerful tool at our disposal for troubleshooting, but it is there for use as an audit tool as well as to help us create an RCA when needed.