November 2005 - Posts
Q: When querying SS2005 Partitioned Tables, what kind of parallelism should I expect to see and how will that affect performance? A: First, a brief background on partitioning. SQL Server 2005 table partitioning provides many improvements in terms of manageability
Read More...
Prem Mehra and Mike Ruthruff In an earlier blog, Deploying SQL Server 2005 with SAN #1, we addressed three topics: 1) the core SQL Server requirements with respect to IO subsystem, 2) the complexity introduced by virtualization of the IO subsystem and
Read More...
Prem Mehra and Mike Ruthruff We recommend that prior to deploying SAN in a SQL Server production environment you conduct a bench-mark to establish a performance base-line. There are several benefits: 1) Establish a base-line so that you know ahead of
Read More...
