Bellingham has switched from summer to winter.
In the Pacific Northwest theme of 2 seasons, the weather shifted from Summer weather to Winter weather yesterday and today. Its official Bellingham WA is now in the wet season. It was a good summer.
Now that Database Health Beta 2 is out, whats next…
Now that Beta 2 of the Database Health Project is out, and people are using it, I am going to focus my attention on 2 areas. Fixing any bugs that are reported in Beta 2 of the Database Health Project. Adding new features, specifically related to offline monitoring or history data. Currently all of the reports in the database health project …
Now that Database Health Beta 2 is out, whats next… Read more »
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 still want to get at the Plan Cache contents, I use the following query. Again, the Database Health Reportsgives you a …
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. Here is where the story starts… Last spring my son George received an iPod Touch 4 as a birthday present. …
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 by Database panel to the Database Overview page. Added the Memory by Database report. Added Unclustered Tables Report. Added the Connections Advisor which is linked to …
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 database from someone else who didn’t know enough about indexes. In these cases adding the right clustered index can dramatically …
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 the things included in the next beta. Overall performance tuning, some of the reports run faster now, and 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 SSRS reports weren’t going to do what I was looking for so I started on the Database Health reports version …
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 example you can quickly see that the Demographics column in the Person table is taking up 13MB or roughtly 88% …
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 are very similar, but they take up very different amounts of disk space. Using the Database Health Reports application, we …
Should I Use A Unique Identifier As A Primary Key? Read more »