Welcome to MSDN Blogs Sign in | Join | Help

January 2008 - Posts

Improving SQL Disk Performance #2 Windows Stripe Size

Posted Saturday, January 26, 2008 8:42 PM by boduff
There are some urban legends around the Windows stripe size that you should set for SQL Server. I have seen recommendations of 64k for both data and log internally at Microsoft by some heavy hitting data Dudes, so that is good enough for me ;-) Generally Read More...
1 Comments
Filed under: ,

Improving SQL Disk Performance #1 Partition Alignment

Posted Saturday, January 26, 2008 8:31 PM by boduff
There is a great article that you should read before configuring a disk subsystem for SQL Server. Predeployment I/O Best Practices . As mentioned, one of the common pitfalls is not ensuring that the offset of the first block is "64k" or a multiple Read More...
8 Comments
Filed under: ,

SQL 2008 Questions from Users Group

Posted Thursday, January 24, 2008 3:48 PM by boduff
Thanks to everyone who attended the SQL Ireland Users group. We discussed some of the main new features in SQL 2008: compression encryption business continuity Resource Governor Entity Data Model Synchronisation Framework DWH Improvements Change Data Read More...
0 Comments
Filed under: ,

Why Should I use SQL Enterprise Edition?

Posted Thursday, January 24, 2008 1:31 PM by boduff
A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is that EE is sold mainly on the enhanced features which can be compared at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx You will Read More...
3 Comments
Filed under: ,

2008 Launch Tour

Posted Wednesday, January 16, 2008 3:28 PM by boduff
I've been a bit off radar: up to my neck in a large  sql server / dot.net project and some time off for Christmas. Believe it or not I managed to get my thumb trapped in a Transformer on Christmas day and an ensuing infection - so if you see a consultant Read More...
1 Comments
Filed under: ,
 
Page view tracker