PDW Whitepaper and more … December 2nd, 2010

Vinod Kumar

Deploying SQL Server 2008 R2 Parallel Data Warehouse at Microsoft Microsoft IT is deploying a highly scalable appliance that delivers performance at low cost through massively parallel processing (MPP) to address the needs of its internal global forensic security tool which captures, filters, stores, and queries security events that occur across the Microsoft global corporate network.

Am I supported? (now you know) Anyone who has worked with virtualization software knows that sometimes the hardest question to answer is “but is this configuration supported?”  Recently the SVVP team updated their website to make this question even easier to answer – by adding the Support Policy Wizard.

HOW IT WORKS: IO Affinity Mask – Should I Use It? The IO Affinity mask is a very targeted optimization for SQL Server.  We have only seen 6 cases where the use of it improved performance and was warranted.  It is much more applicable to very large database needing high rates of IO on 32 bit systems. The blog explains with a simplified example on these scenarios.

Happy reading and do share what you read recently …

Tags: , , , , , , , ,

This entry was posted on Thursday, December 2nd, 2010 at 04:33 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply