You work as the database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. You use a client computer named MiracleInfocom -WS444. The MiracleInfocom .com network contains a SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 hosts a database named MI_Products. The recent increase in database usage at the company has resulted in several MiracleInfocom .com users complaining of poor query performance and query timeouts try to retrieve data from the MI_Products database. You need to determine the cause of the poor performance. You need to minimize the effect of your monitoring strategy on system performance. What should you do?
A. Run the SQL Server Profiler from MiracleInfocom -WS444 and create a trace that monitors MiracleInfocom -DB01. Save the trace file to a table.
B. Run the Performance tool on MiracleInfocom -DB01 to create a log that monitors MiracleInfocom -DB01. Save the log file to a folder on MiracleInfocom -DB01.
C. Run the SQL Server Profiler on MiracleInfocom -DB01 and create a trace that monitors MiracleInfocom -DB01. Save the trace file to a table
D. Run the Performance tool on MiracleInfocom -WS444 to create a log that monitors MiracleInfocom -DB01. Save the log file to a folder on MiracleInfocom -WS444.
Answer:D
You work as the database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. You use a client computer named MiracleInfocom -WS444. The MiracleInfocom .com network contains a SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 hosts a database named MI_Products. The recent increase in database usage at the company has resulted in several MiracleInfocom .com users complaining of poor query performance and query timeouts try to retrieve data from the MI_Products database. You need to determine the cause of the poor performance. You need to minimize the effect of your monitoring strategy on system performance. What should you do?
A. Run the SQL Server Profiler from MiracleInfocom -WS444 and create a trace that monitors MiracleInfocom -DB01. Save the trace file to a table. B. Run the Performance tool on MiracleInfocom -DB01 to create a log that monitors MiracleInfocom -DB01. Save the log file to a folder on MiracleInfocom -DB01. C. Run the SQL Server Profiler on MiracleInfocom -DB01 and create a trace that monitors MiracleInfocom -DB01. Save the trace file to a table D. Run the Performance tool on MiracleInfocom -WS444 to create a log that monitors MiracleInfocom -DB01. Save the log file to a folder on MiracleInfocom -WS444.