Performance Dashboard Reports for SQL Server 2008

During a recent visit to Seattle for a Microsoft conference, I learned from my colleague Michael Thomassy that it’s possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a slight modification. There is a great new feature in SQL Server 2008 called Performance Data Collection, which I have blogged about in the past,…

27

CU #3 for SQL Server 2008 Released

On January 19, 2009 Microsoft shipped the Third Cumulative Update for SQL Server 2008 RTM.                                                                                                                        This CU represents 36 Resolved Issues and 30 Unique Customer Requests. More details and download details can be found here:   http://support.microsoft.com/kb/960484/en-us  

2

SQL Server 2008 Upgrade Technical Reference Guide Released

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides are intended to suppliment the information already available in SQL Server 2008 Books Online.

1

SQL Server 2008 Cumulative Update #2 Released

Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us

1

Scottish Area SQL Server User Group

I’m happy to announce that the next Scottish SQL Server User Group will be hosted at Microsoft Edinburgh on the evening of the 13th November. Full details of the agenda and how to register can be found on the UK SQL Server User Group site here: http://sqlserverfaq.com/events/144/Scottish-Area-SQL-Server-User-Group-Jammin-SQL-Server-2008.aspx The theme of the meeting is “Jammin’ with…

2

SQL Server 2008 – Performance Studio

I’ve been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it’s pretty cool ! Along with Resource Governor and compression, it’s one of my favourite new features and a good reason to consider an upgrade. Performance Studio builds on the concept of…

14

Indexing Strategies

I attended a SQL Server User Group meeting earlier this year and heard a presentation about favourite DMV’s. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance troubleshooting databases that have used a variety of indexing stategies, ranging from none to lots of narrow indexes on…

1

SQL Server 2005 Performance Dashboard

I’ve had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I’ve created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers to monitor the general performance characteristics of a server and investigate the cause of any…

2

SQL Server 2008 RC0 Available

The release of SQL Server 2008 has hit another milestone with the news that Release Candidate 0 (RC0) has been made available for public download this morning. This was initially released to Technet Plus and MSDN subscribers last Friday. It is expected that this will be the final release prior to SQL Server 2008 RTM in Q3…

3

June SQL Technical Rollup Mail

The June SQL Server Technical Rollup Mail has now been released. Check it out for some great SQL Server information and resources… http://blogs.technet.com/trm/archive/2008/06/01/june-2008-technical-rollup-mail-sql.aspx

1