Using a file target is not difficult from a creation point of view (event session creation). But, some basics are critical or you could end up with fewer follicles.
How to: File Target use in Extended Events
Tag: XE
Upgrading From SQL Server Profiler
How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.
As luck would have it, there is a means to correlate trace/profiler events to Extended Event events (yeah that sounds weird). With the release of SQL Server 2012, Microsoft introduced a couple of catalog views to help with this correlation effort.
How To: XEvents as Profiler
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to notify people or follow process.
Quick and Easy XE for Azure DB
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to configure the session quickly and then to subsequently script that configuration before creating the session.
The Mystery of Missing Backup Files
Managing database backups is a critical role of the successful DBA. Understanding what the backup plan is and ensuring backups occur on schedule is not always transparent to the DBA as exposed in this tale.
Capture the Flag – The Trace Flag
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to notify people or follow process.
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking when the data file(s) grow(s).
Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to the tool – sort of. Now we have the power to run traces on SQL Server via ADS.
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or microseconds?
Monitor Database Offline Events
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend to do very strange things.