You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains a database that is used by a mission critical application.
You have received complaints from a Domain.com user named Mia Hamm that the performance
of the server is not running by her as it should be. You need to use the Database Engine Tuning
Advisor to help the functions of the application however you should ensure that the performance of
the server does not affect the other users.
What should you do?
A.
You should consider making the XP_MSVER stored procedure disable on the remote server.
B.
You should consider making the XP_MSVER stored procedure enable on the remote server.
C.
You should consider setting up a test server which has the same hardware setting, before using
the dta.exe utility on the test server along with an XML input file.
D.
You should consider making the XP_MSVER stored procedure enable on the local server.