SQL Server Support, Failover Clustering and Virtualization

On May 19th, Microsoft has updated the Support Policy for Microsoft SQL Server products that are running in a hardware virtualization environment, which you can find at the following link: http://support.microsoft.com/kb/956893/en-us   The main update is related to guest failover clustering, therefore when you create a SQL Server failover cluster inside a virtual machine where…

0

Whitepaper - Disk Partition Alignment Best Practices for SQL Server

I’ve blogged some time ago about Microsoft recommendations for maximizing the performances of your disks subsystem for a SQL Server implementation:   SQL Server – Speed up your Disks! http://blogs.technet.com/beatrice/archive/2008/06/09/sql-server-speed-up-your-disks.aspx   Collection of SQL Server Storage Best Practices http://blogs.technet.com/beatrice/archive/2008/04/07/collection-of-sql-server-storage-best-practices.aspx   Finally there’s available directly from the SQL CAT Team a new whitepaper stating which are the …

0

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

Download SQL Server 2008 SP1

SQL Server 2008 SP1 final version has been released.   It contains all the announced great new features that we were all looking forward to, especially the slipstream and uninstall ones, which could save a lot of time (and headhackes) at installation time.   So just to recap, new features are:   Slipstream – You…

0

SQL Server 2008 Service Pack 1 (SP1) CTP

Just woke up ready to celebrate my birthday (do not try to ask a woman how old she is :-P) and discovered the CTP version of SQL Server 2008 Service Pack 1 (SP1) is now available. Hum, well, I will check it out but definitely not today I am afraid as I have other plans in…

0

FREE e-book: Introducing Microsoft SQL Server 2008

  A great opportunity to download (for FREE :-))   Introducing Microsoft SQL Server 2008 by Peter DeBetta, Greg Low, and Mark Whitehorn   Learn about major new features in SQL Server 2008 including security, administration, and performance.   Chapter 1: Security and Administration Chapter 2: Performance Chapter 3: Type System Chapter 4: Programmability Chapter…

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