http://msmvps.com/search/SearchResults.aspx?q=app:weblogs&tag=VDI,performance&orTags=0&o=DateDescendingSearch results for 'app:weblogs' matching tags 'VDI' and 'performance'en-USCommunityServer 2008.5 SP2 (Build: 40407.4157)/http://sqlserver-qa.net/blogs/tools/archive/2010/04/22/sql-server-i-o-affinity-and-snapshot-backups-speed-up-the-maintenance-activity-on-your-database.aspxThu, 22 Apr 2010 05:00:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1764029AnonymousBack in SQL Server 2000 version days (I think) SP1 onwards the affinity mask configuration option has been introduced, which refers to IO_affinity_mask_switch using SP_CONFIGURE statement. I/O affinity dedicates special, hidden schedulers to performing core buffer pool I/O and log writer activities. Just a brief background about the affinity mask (from Technet) as follows: Specify which CPUs in a multiprocessor computer are eligible to process SQL Server disk I/O operations. The IO_affinity_mask...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/04/22/sql-server-i-o-affinity-and-snapshot-backups-speed-up-the-maintenance-activity-on-your-database.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=6432" width="1" height="1" alt="" />