Old MPS Reports Dismissed - New Version Ready!

A new version of MPS Reports has been released late April, at the following link: Microsoft Product Support Reports http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en   Amongst the main differences:   With the new MPS reports, there is only one download, based on your system architecture (x86 or x64).  The supported Operating Systems for the new tool are Windows XP,…

0

Troubleshooting Performance Problems in SQL Server 2008

A new great whitepaper to bookmark amongst your favourites:   Troubleshooting Performance Problems in SQL Server 2008 http://msdn.microsoft.com/en-us/library/dd672789.aspx   This documentation provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as:   SQL Server Profiler System Monitor (in the Windows Server 2003 operating system) or Performance Monitor (in…

0

SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update

If you recently found yourself in installing latest SQL Server 2005 Security Update (you did installed it right?):   Microsoft Security Bulletin MS09-004 – Important http://www.microsoft.com/technet/security/bulletin/MS09-004.mspx   ..and had a look to the known issues page… You might have had a heart attack (as I did at first) in seeing the following:   SQL Server…

1

DBCC DBREINDEX (aka INDEX REBUILD in 2005) and Statistics Update

So – today I’ve been made this question.   “I have a DB, AUTO_UPDATE_STATISTICS option OFF (very bad idea, anyway :-)), I rebuild my indexes every week.  I do not have major changes in my database. As update statistics with fullscan is a side effect of DBCC DBREINDEX (aka INDEX REBUILD in 2005), can I…

0

Best Practices for installing SQL Server service packs, hotfixes, cumulative updates

There isn’t much information around (other than the readme for service packs) on which are the best practices on installing Service Packs, Cumulative Updates, Hotfixes on SQL Server installation. …well till today really 🙂   This is nothing official from Microsoft but still the following are the best practices recommended from my PFE colleague Uttam…

3

How To - Proactively Know Upcoming SQL Server CUs and SPs

Umh, it has been a long time since my last post. I must admit, I’ve had brilliant holidays (relax and skiing) followed by a very bad flue, which summed up with all the XMas parties of 2008 makes 3 weeks without any post on my professional blog :-).   Well, if anybody out there had missed me,…

0

Resource Governor Demos

If you are looking for some demos to play and learn about Resource Governor, you should have a look to the SQL Server SQLOS team blog, which has posted a couple of interesting ones.   1) Anatomy of SQL Server 2008 Resource Governor CPU Demo http://blogs.technet.com/sqlos/archive/2007/12/14/part-1-anatomy-of-sql-server-2008-resource-governor-cpu-demo.aspx   This demo will use a single CPU to…

1

Data & Backup Compression (Part 3) - Tests, Numbers and Tuning Tips

One of the most common question I’ve received regarding data and backup compression in SQL Server 2008 is related to achievable results in terms of performance and compressio-ratio on very large databases.   I’ve just found some interesting data published by Unisys which you can review at: Microsoft SQL Server 2008 Data and Backup Compression…

0

How to: Troubleshoot SQL Server 2008 Features

This is a nice section in 2008 Books On Line which I just found and wanted to blog about – mainly for my reference so that I can quickly find it when needed 😉   I’ve found it whilst looking for recommendations to troubleshoot Resource Governor,  but there are actually many other troubleshooting how-to’s which I…

0

SQL Server 2008 Upgrade Technical Reference Guide

The SQL Server 2008 Upgrade Technical Reference Guide is now Live and available to download.   It is a 490-page white paper  (hold on, do not get scared, you don’t need to read it all :-)) which covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL…

1