Bob Duffy's Blobby Blog

SQL Server | BI | Dot.Net | Office | Sharepoint | MCE | Database Stuff

Browse by Tags

Tagged Content List
  • Blog Post: 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,...
  • Blog Post: 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 size...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (5 items)