You are a database administrator for AIOTestKing.com. The company has a SQL Server 2005 computer named AIOTestKing A database on AIOTestKing A stores sales history data for the company’s Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. The performance of AIOTestKing A is routinely slow. You need to find out which business analyst is causing the problem. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
A.
Run the sp_who system stored procedure
B.
Use the Activity Monitor to view the activity of specific business analysts
C.
Run SQL Trace system stored procedures to gather database activity
D.
Create a trace that uses a predefined template by using SQL Server Profiler.