Posts by Jason Brimhall
Checkpoint Analysis: Your Exclusive How-To with XEvents
Checkpoints are essential in SQL Server to help with the durability and reliability of data persisted in the database.
Read MoreBulk Insert – Insights That Will Make You Drool
Bulk insert can be an extremely helpful tool to help ingest data into SQL Server efficiently. Sometimes, it is necessary to capture metrics in regards to the bulk insert in order to understand the who, when, and potentially why related to the insert process.
Read MoreAzure DB – A Quick Spelunk Into XEvents to Love
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB.
Read MoreMemory – How to Find when Excess is a Bad Thing
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue.
Read MoreOwner is Missing in the GUI – An Easy Fix
In this article, I will share an oddity that happens when the database owner is seemingly missing.
Read MoreStatistics Auditing to make you Omniscient
Statistics in SQL Server, love them or hate them, are essential to good performance. Statistics help to drive execution plan selection and thus can have quite a profound impact. If you have bad stats, you can end up with a very poor plan. Conversely, good stats can help the optimizer in selecting an optimal and…
Read MorePowerful Monitoring for Your Linked Servers with XEvents
Linked servers are the bane of good performance and are wrought with all sorts of “hidden” problems.
Read More3 Highly Improved Help Queries for XEvents in Azure SQL
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events.
Read MoreTop 3 Easy Help Queries for XEvents in Azure SQL
I would like to share a few quick scripts to help find some of the event information for SQL Azure when attempting to use XEvents. In the long run, these little helper queries will help make your life easier.
Read MoreExtended Events Categories: An Introduction
Packages come with a pair of descriptors (or classifiers) that will be useful in correlating related events contained within a given package.
Read More