As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 … Continue reading Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the information that the DMV contains. In this post, we are going to look at the locking and blocking columns. Base Columns Before we jump over to the meat and potatoes, let's first take a look at … Continue reading Index Black Ops Part 1 – Locks and Blocking
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter today at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of … Continue reading Webcast Today – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter next week. It’ll be on July 28 at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution … Continue reading Webcast Next Week – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Performance Virtual Chapter later today starting at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. Often the purpose of … Continue reading Webcast Today – Performance Impacts Related to Different Function Types
I’ll be speaking for the SQL PASS Performance Virtual Chapter next week. It’ll be on July 6 at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. … Continue reading Webcast Next Week – Performance Impacts Related to Different Function Types
Today started with some quality time getting to know a deadlock that had occurred. While working through the deadlock, I noticed that there were a number of foreign key relationships that weren't indexed on the parent side of the relationship. I am going to skip over the why to index foreign keys and save that … Continue reading Index Those Foreign Keys
A while back I wrote a post on a procedure I created for the DBADiagnostics database that I talk about from time to time. This procedure allowed users to search the procedure cache to find plans for procedures by database name and object name. This had worked out pretty good until I noticed something the … Continue reading Searching for Plans
Ever come across performance counter log that isn’t in your desired format? This is a situation I’ve been in a number of times. And wouldn’t you know, I usually space off the command line tool that I can use to do this. The gem of a tool that you can use to change performance log … Continue reading Changing A Performance Counter Log Format
I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
Strate SQL 