You work as the database administrator at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all database servers run SQL Server 2005. The MiracleInfocom .com network contains two database servers named MiracleInfocom -DB01 and MiracleInfocom -B02. MiracleInfocom -DB01 hosts a database named MI_Sales that stores sales data for the company. The MI_Sales database is also used for online transaction processing (OLTP). MiracleInfocom .com develops a new Web application that you deploy on MiracleInfocom -DB01. MiracleInfocom .com’s Web customers start complaining about excessive delays and intermittent timeout errors. You monitor the systems resources on MiracleInfocom -DB01 on Windows System Monitor and are satisfied that system resource usage is well within expected parameters. You request that the application developers test the Web application and identify the cause of the performance problems. The application developers report that the problem is related to the time required to retrieve data from MI_Sales. You need to create a SQL Server Profiler trace to identify the poorly performing queries in the Web application. What should you do?
A. Capture events related to the Sessions and Stored Procedure event classes. Group data by EventClass.
B. Capture events related to the Stored Procedure and TSQL event classes. Group data by Duration.
C. Capture events related to the ExistingConnection event classes. Group data by EventClass.
D. Capture events related to the ExistingConnection and Sessions event classes. Group data by ClassProcessID
Answer:B
You work as the database administrator at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all database servers run SQL Server 2005. The MiracleInfocom .com network contains two database servers named MiracleInfocom -DB01 and MiracleInfocom -B02. MiracleInfocom -DB01 hosts a database named MI_Sales that stores sales data for the company. The MI_Sales database is also used for online transaction processing (OLTP). MiracleInfocom .com develops a new Web application that you deploy on MiracleInfocom -DB01. MiracleInfocom .com’s Web customers start complaining about excessive delays and intermittent timeout errors. You monitor the systems resources on MiracleInfocom -DB01 on Windows System Monitor and are satisfied that system resource usage is well within expected parameters. You request that the application developers test the Web application and identify the cause of the performance problems. The application developers report that the problem is related to the time required to retrieve data from MI_Sales. You need to create a SQL Server Profiler trace to identify the poorly performing queries in the Web application. What should you do?
A. Capture events related to the Sessions and Stored Procedure event classes. Group data by EventClass. B. Capture events related to the Stored Procedure and TSQL event classes. Group data by Duration. C. Capture events related to the ExistingConnection event classes. Group data by EventClass. D. Capture events related to the ExistingConnection and Sessions event classes. Group data by ClassProcessID