Posted by: Pdfprep
Post Date: January 29, 2021
You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from an existing server to the new server.
You want to evaluate the new server’s performance based on the workloads of the existing server.
To do so, you need to run the workloads captured from the existing server against the new server from multiple computers.
Which SQL Server tool should you use?
A . Distributed Replay
B . Data Tools
C . Migration Assistant
D . Upgrade Advisor
Answer: A
Explanation:
With Distributed Replay, you can replay a workload from multiple computers and better simulate a mission-critical workload.
References: https://technet.microsoft.com/en-us/library/ff878183(v=sql.110).aspx
Leave a Reply