Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Disks » SQL   (RSS)
Sorry, but there are no more tags available to filter with.

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: ,
 
Page view tracker