In my company we have multiple virtual machines hosting SQL Server 2008 R2 and some of these machines perform differently than others, some because of very busy Vmware hosts some because of slower connections to NAS.
Is there a way I can run some SQL code in a test SQL database or other known best practices I could use to run some performance tests in each VM and baseline/benchmark performance so that I can understand which machine behaves better than others prior to moving those machines to Prod or UAT environments? Thanks, Davide.
Asked by Davide Piras
(324 rep)
Aug 26, 2014, 01:38 PM
Last activity: Dec 27, 2022, 11:02 AM
Last activity: Dec 27, 2022, 11:02 AM