Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Disks   (RSS)

Using a SAN to Initialize Replication

Posted Saturday, May 16, 2009 10:50 AM by boduff
I've chatted to a few customers about the possibnility of using a SAN based snapshot to initialise transactional replication. This can be fantastic when you are using a replica to provide "near real time" reporting. Up until now, documentation has been Read More...
1 Comments
Filed under: ,

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: ,

The Humble Desktop Reaches a Terra

Posted Wednesday, May 16, 2007 11:55 AM by boduff
Hitachi have released a 1TB SATA II drive. What is more impressive than the size is the fact that according to Toms Hardware Guide it benchmarks as well as the famous Raptor drives. One of which I have lovingly in my development box at home, having replaced Read More...
0 Comments
Filed under:

Flash - aha Saviour of the Database

Posted Wednesday, May 16, 2007 11:44 AM by boduff
A new wave of tecnology is about to hit enterpise SQL SAN's. The humble flash disk scaled up to 1TB. In theory this gives incredibiliy low IO latency and eliminates the descrepancies between random/sequential IO and slowness due to a disk filling up! Read More...
0 Comments
Filed under:
 
Page view tracker