Azure SQL Extended Events – Using Azure Storage

Posted on May 8, 2018 by blobeater

Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks via the ring buffer. Ever since then I wanted to do a follow-up post but using Azure storage as the target for my XEL files.

This is more complicated than using the ring buffer as the target and requires a couple of things:

Azure storage account where you create a dedicated container for the files.
SAS key.
Database master key.
Database scoped credential.

Continue reading →

Extended Events – Using Azure Storage

Posted on May 8, 2018 by blobeater

This is more complicated than using the ring buffer as the target and requires a couple of things:

Azure storage account where you create a dedicated container for the files.
SAS key.
Database master key.
Database scoped credential.

Continue reading →

SQL Server Tracking Tempdb Size

Posted on October 3, 2017 by blobeater

Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for both the data and log file. I wanted to know who caused the tempdb growth, when it was done, what the T-SQL was and what sizes were involved. Not exactly complicated but hopefully useful.

Continue reading →

Find when your SQL Server database grew

Posted on May 25, 2017 by blobeater

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it.

Continue reading →

Extended Events – I am dangerous (sometimes)

Posted on May 9, 2017 by blobeater

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same.

I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following code where I was after a guy called Shane:

Continue reading →