Performance : SSIS/DQS VS Operating System
-
Tuesday, March 12, 2013 1:45 PM
Hi,
Does Windows Server 2012 will give any significant performance boost over Windows Server 2008
for SSIS (DQS cleanding & other ETL activities) , DQS engines and SQL server?
Note: its regarding SQL Server 2012
Regards,
Uday
All Replies
-
Wednesday, March 13, 2013 4:44 AMModerator
No, Not especially the OS itself.
The most common bottleneck with SQL Server features is disk IO. So if you want to compare performance, generally you can use Solid State disk and it will get much faster. You can put tempdb on different drive, and mdf separate from ldf files.
Thx, Jason
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
- Proposed As Answer by Jason H - SQLMicrosoft Employee, Moderator Wednesday, March 13, 2013 4:46 AM
