Released – Cumulative Update Package 1 for SQL Server 2005 Service Pack 3

Microsoft has just shipped the first Cumulative Update for SQL Server 2005 SP3.   This CU contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 and Cumulative Update 11 for SQL Server 2005 Service Pack 2. These hotfixes are not included in SQL Server 2005 Service Pack…

1

SQL Server 2005 SP3 is out!

Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035) is now available and ready to download at http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en.   A complete List of the bugs that are fixed in SQL Server 2005 Service Pack 3 can be found at http://support.microsoft.com/?kbid=955706   Note: Service Pack 3 includes SP2 CU 1 to 9,  therefore If…

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

X64, Lock Pages in Memory and AWE – Should I or Should I Not?

I’ve heard this question thousands of times so I’ve thought to try to summarize some recommendation in this blog post.    For 32 bits, things are pretty straight-forward. If they are not, I’ve posted some comments some time ago: \3GB \PAE and AWE – Taking away (some) confusion http://blogs.technet.com/beatrice/archive/2008/08/29/3gb-pae-and-awe-taking-away-some-confusion.aspx   For 64 bits, things are…

1

The Hidden Database in SQL Server 2005 and 2008

Have you ever had to move your master database? Or have you ever opened the folder which contains your master database? Both cases – if that ever happened to you, you should already know about the Resource Database – a hidden, read-only database introduced with SQL 2005 which contains all the system objects that are…

0

Performance Monitor, SQL Counters and Tresholds

Whilst surfing on the web last week, I’ve found this very nice blog from Vipul Shah, which happens to be a Microsoft colleague, which explains which are the key performance counters to monitor for your SQL Server instances and most importantly summarizes which are generally the thresholds you want these counters to fit within.  …

0

Reading User Group Meeting – 20th Nov

For those which live or work close to Reading – there will be a UserGroup on the 20th Evening held in TVP – Microsoft Offices.   Agenda:   6pm – 6:30 Registration and networking + Tea/Coffee with biscuits.   Meet and greet.   6:30pm – 7 Round Table discussion – ALL   Take stock and…

1