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. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. You are in the process of collecting information that will be required for ongoing server management which includes hardware performance statistics. You are required to collect the statistics during average use and peak periods. You want to collect the hardware baseline performance statistics. What should you do?
A. A Windows counter log should be created.
B. A Windows Alerts should be created.
C. A Windows trace log should be created.
D. A SQL Server Profiler trace should be created.
Answer:A
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. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. You are in the process of collecting information that will be required for ongoing server management which includes hardware performance statistics. You are required to collect the statistics during average use and peak periods. You want to collect the hardware baseline performance statistics. What should you do?
A. A Windows counter log should be created. B. A Windows Alerts should be created. C. A Windows trace log should be created. D. A SQL Server Profiler trace should be created.