Using a SAN to Initialize Replication

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 a bit light on the ground on this apporoach, and people have been cautious to try…

1

Improving SQL Disk Performance #2 Windows Stripe Size

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 a Storage Area Network will have a 64k block…

1

Improving SQL Disk Performance #1 Partition Alignment

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 thereof. Longhorn Server and Vista resolve this issue by using am offset…

8

The Humble Desktop Reaches a Terra

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 the SCSI system completely with SATA. I’d be…

0

Flash – aha Saviour of the Database

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! The RamSAN from Texas Memory Systems claims 1TB of Solid State Storage with 3.2 million…

0