April 14, 2016 at 7:47 pm
Hi Guys,
I need to migrate databases from a physical server to a virtual one. So i need to check if the new virtual servers have similar performance as the physical ones.
Could you please recommend any popular tools that are usually used in the industry.
Thanks,
Jesi
April 15, 2016 at 12:59 am
Being on SQL 2012 Maybe look into distributed replay?
April 15, 2016 at 3:50 am
How about capturing typical activity on the physical server using SQL Profiler and then replaying it on the virtual?
https://msdn.microsoft.com/en-us/library/ms189604(v=sql.110).aspx
April 15, 2016 at 5:28 am
Hi,
what about this tool:
"HammerDB is an open source database load testing and benchmarking tool for Microsoft SQL Server"
Kind regards,
Andreas
April 15, 2016 at 7:11 am
Another vote for distributed replay. That's how I've done this sort of testing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply