Finding the contents of the Plan Cache
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database Health Reports and you can get this through a nice user interface. But if you …
Year: 2012
Blair’s Repairs – These guys are awesome!!!
NOTE: My opinions on Blairs have been retracted after finding out that they were a front for dealing drugs. It is not that often that I have an excellent enough customer service experience that I want to rave about it. …
Beta 2 of the Database Health Reports Released
Beta 2 of the Database Health Reports has just been released. The new Beta contains several bug fixes, and several new features. Here is a breakdown of what is new or changed since the last beta. New Features Added the Memory …
Finding tables that don’t have a clustered index.
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a …
Finding tables that don’t have a clustered index. Read more »
Working on Beta 2 of the Database Health Reports
Beta 2 of the Database Health Reports will be available in the next 7 to 10 days as I finish it up. There has been a good acceptance of Beta 1 so far, and with feedback here are some of …
Working on Beta 2 of the Database Health Reports Read more »
It is finally here. Beta 1 of the Database Health Reports for SQL Server.
In October last year I started work on the Database Health reports project. It started out as a series of SSRS reports that I released and updated in December 2011 to March 2012. After that it became clear that the …
It is finally here. Beta 1 of the Database Health Reports for SQL Server. Read more »
Preview of the Table Size Advisor
As I get the Database Health project ready to release as a beta, more of the components are coming together. For instance shown here is the Table Size Advisor which can be accessed from the Disk Space Report. In this …
Should I Use A Unique Identifier As A Primary Key?
Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other with newsequentialid(). Once the tables are created and we insert 100,000 rows into each, they …
Should I Use A Unique Identifier As A Primary Key? Read more »
TSQL to Determine Plan Cache Size
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here are the before and after queries to determine the plan cache size in SQL Server …
Index Defragementation and Management
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole project is the index defragmentation part of the project. This has turned out to be …