What should you do?

You work as a database administrator at Domain.com. Domain.com is using a remote SQL
Server 2008 instance. One morning you have received complaints that the applications are
running sluggish. To get hold of the workload, you need to trace the table on the remote SQL
Server instance. You need to use the Database Engine Tuning Advisor and use the SQL Profiler
tool to analyze the workload of the remote SQL Server instance on a local SQL Server instance.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a remote SQL
Server 2008 instance. One morning you have received complaints that the applications are
running sluggish. To get hold of the workload, you need to trace the table on the remote SQL
Server instance. You need to use the Database Engine Tuning Advisor and use the SQL Profiler
tool to analyze the workload of the remote SQL Server instance on a local SQL Server instance.

What should you do?

A.
You should consider enabling the XP_MSVER stored procedure on the local server.

B.
You should consider enabling the XP_MSVER stored procedure on the remote server.

C.
You should consider recapturing the workload to a trace file by using the SQL Profiler tool.

D.
You should consider capturing the workload to a trace file by using the SQL Profiler tool.



Leave a Reply 0

Your email address will not be published. Required fields are marked *