Tag: DMO

pass plan cache whisperer

PASS Summit Session Follow-up: The Plan Cache Whisperer

I’ve wrapped up my session at my first session at this year’s PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.  To provide access to the materials now, the slide deck…

nose picking

Can You Dig It? – Find All Plans for a Database

With today’s SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance.  In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you’ll easily see…

Lego Tree

A Replacement for DBCC IND in SQL Server 2012

Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles.  Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare.  Among all of those new features, is the occasional little bell which offers us a chance to change how we investigate SQL…

LostInTranslation

Lost in Translation – Deprecated System Tables – syslockinfo

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view syslockinfo returns information on lock requests.  Whether the lock is granted, waiting to be…

LostInTranslation

Lost in Translation – Deprecated System Tables – sysprocesses

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprocesses returns information on the processes that are running on a SQL Server instance. …

LostInTranslation

Lost in Translation – Deprecated System Tables – sysprotects

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprotects returns rows for permissions within a database.  The view provides information on GRANT…

LostInTranslation

Lost in Translation – Deprecated System Tables – sysservers

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysservers provides information on linked servers, or servers an instance of SQL Server has…

LostInTranslation

Lost in Translation – Deprecated System Tables – sysremotelogins

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysremotelogins returns a row for every remote user with access to call remote stored…

LostInTranslation

Lost in Translation – Deprecated System Tables – sysreferences

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysreferences returns a row for every foreign key constraint in a database.  The constraint…

LostInTranslation

Lost in Translation – Deprecated System Tables – sysperfinfo

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysperfinfo returns rows for all of the internal SQL Server performance counters.  Theses are…