May 21, 2014 at 7:57 am
I have two environments both are virtualized, I have three drives C (OS), D (data), and E (log), of course the host handles the volumes.
1) SQL Server 2008 R2, Windows Server 2008 R2 enterprise, 18GB RAM memory, 10GB speed drives, 2 connections to the array
2) SQL Server 2008 R2, Windows Server 2008 R2 enterprise, 32GB RAM memory, SSD drives, 4 connections to the array
We're testing a vendor application on both environment to check for performance and find the best hardware configuration for it. We have a few test scenarios that we run through both environments. My question is how would SQL take advantage of the different hardware configurations? For example, if I ran the same query on both system would SQL utilize all four paths to the storage to improve the wait time or just one? Any articles and reading materials on this can be very appreciated.
I believe the second environment should give us a lot better results, however, we are not seeing any considerable improvement on our tests. I need to understand how SQL works in a virtual environment so we can configure it to best take advantage of what the hardware has to offer.
Thank you.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply