Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Extended Events Categories

I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left a couple of things un-said about packages – leaving them for this article.

Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what… Read more

1 comments, 176 reads

Posted in SQL RNNR on 9 September 2015

One Easy Strategy for the Database Enterprise


Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server community, that means it is time for TSQL2SDAY. This month the host is Jen McCown (blog / twitter), half of the MidnightDBA team, and the topic that… Read more

1 comments, 181 reads

Posted in SQL RNNR on 9 September 2015

Learning Extended Events in 60 Days

This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The purpose of these posts will be to help somebody progress through the Extended Events Concepts and become more proficient at implementing and using them.

The 60 days of XE will… Read more

2 comments, 245 reads

Posted in SQL RNNR on 8 September 2015

Extended Events Objects

So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started to dive into the individual components of that metadata.

Today I want to start diving into some of this data a little deeper as we progress through some of the… Read more

3 comments, 1,214 reads

Posted in SQL RNNR on 8 September 2015

Extended Events Packages

Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects of session metadata whether the session is running or stopped. Today, I want to take a step back and look at the framework that helps give us this tool.

The… Read more

0 comments, 160 reads

Posted in SQL RNNR on 7 September 2015

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated some quick and simple means to retrieve some metadata via the catalog views and DMVs.

Beyond the metadata in the the catalog views and DMVs, there are a… Read more

1 comments, 584 reads

Posted in SQL RNNR on 4 September 2015

Viewing Running XEvent Metadata

In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata relevant to deployed Extended Event sessions. Today, I will continue talking about metadata. One difference being that today I will focus on diving into the metadata of running sessions. Read more

2 comments, 847 reads

Posted in SQL RNNR on 3 September 2015

Viewing Deployed XEvent Metadata

Today will be the first of a few introductory level posts about Extended Events.

When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events. Some of the metadata is pertinent to…

Read more

6 comments, 283 reads

Posted in SQL RNNR on 2 September 2015

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events.

Well, today I present to you another opportunity for you to renew your love/hate… Read more

1 comments, 284 reads

Posted in SQL RNNR on 1 September 2015

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.

Despite that, Extended Events takes advantage of XML much like we have seen in… Read more

2 comments, 164 reads

Posted in SQL RNNR on 26 August 2015

Compressing Outcomes

You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a spare chair in your cubicle to talk about the weather.

Well, not entirely true there. The CIO dropped in because the alerts for disk space have been blowing up everybody’s… Read more

0 comments, 196 reads

Posted in SQL RNNR on 24 August 2015

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a black box database server, or maybe due to the acquisition of a new application.

No matter the cause, you are now responsible for maintaining that database and you also really… Read more

0 comments, 1,476 reads

Posted in SQL RNNR on 19 August 2015

Compressing Encrypted Backups

A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much smaller.

This was a knock for the early days of Transparent Data encryption (circa SQL Server 2012). If TDE were enabled,… Read more

1 comments, 199 reads

Posted in SQL RNNR on 11 August 2015

What is DBCC?

If I ask you what is DBCC, what would your answer be?

I want you to think about that one for just a little bit. What comes to mind when you hear DBCC? Is it the default go-to used when talking about consistency checks? Is it something more involved? Maybe… Read more

1 comments, 288 reads

Posted in SQL RNNR on 11 August 2015

HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or even what the health was like a few months back? Sure, one could anecdotally say the databases and servers are healthy, but how do you quantify it?

Many have asked… Read more

0 comments, 1,839 reads

Posted in SQL RNNR on 7 August 2015

Table Size Script Update for 2015

As was recently promised, I have an update to an old tried and true script for calculating the size of an object.

That promise was doled out in the previous article when I discussed the internal table types. You can read the article here. Information from that article was… Read more

2 comments, 431 reads

Posted in SQL RNNR on 4 August 2015

Internal Tables and Space Used

Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.

I enjoy the… Read more

0 comments, 244 reads

Posted in SQL RNNR on 30 July 2015

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).

That is grand when it comes to quickly finding which objects happen to be… Read more

0 comments, 1,867 reads

Posted in SQL RNNR on 27 July 2015

Extended Events Removed from 2016

SQL Server 2016 is on the horizon. We have a few CTP versions already released for download, allowing people to become more and more familiar with the product.

Recently, I wrote about how SQL Server 2016 has many more Extended Events that have been added for our use. You can… Read more

0 comments, 197 reads

Posted in SQL RNNR on 22 July 2015

TSQL Recipes – 2014 Edition

Announcing…the book

At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished.

This edition brings several changes and quite a bit of re-write. It has been updated for many of the new SQL… Read more

0 comments, 189 reads

Posted in SQL RNNR on 21 July 2015

Newer posts

Older posts