March 2007 - Posts

• Performance Dashboard Reports available

  As you might have seen, you can plug in your own reports in SQL Server Management Studio as of sp2. The MS tool team has made such a package, the SQL Server 2005 Performance Dashboard Reports. Check it out at:: http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=e Read More... Posted Wednesday, March 14, 2007 1:15 PM by TiborKaraszi | 1 Comments Filed under: Tools

• Whats in the default trace?

  As you probably know, there's a trace running by default in SQL Server 2005. The directory for the trace file is the SQL Server log directory, and you can turn off and on this trace with sp_configure. But how do we find out what events and columns are Read More... Posted Monday, March 12, 2007 12:23 PM by TiborKaraszi | 1 Comments Filed under: Tools, General

• Be aware: Sp2, maint plans and CHECKDB

  Tony Rogerson brought to my attention that with sp2, a plan that does CHECKDB seems to always do it against the master database. Technicalities seems to be in how SSIS executes SQL commands, separates batches and connection pooling (sp_reset_connection). Read More... Posted Thursday, March 08, 2007 10:44 AM by TiborKaraszi | 3 Comments Filed under: Tools, Maintenance

• New revision of sp2 and GDR

  Because of the problems with Maint cleanup task in sp2 (see my earlier post and http://support.microsoft.com/kb/933508 ), potentially removing old backup files prematurely, a refresh of sp2 has been released. If you have already installed sp2, you can Read More... Posted Thursday, March 08, 2007 10:38 AM by TiborKaraszi | 0 Comments