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 SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 is running a default SQL Server instance and a named instance named MI_Sales. MiracleInfocom .com users complain that performance for both instances has deteriorated over the last six months. You want to determine the memory and processor resource requirements of the two instances as well as any resource conflicts between the two instances. What should you do?
A. Use SQL Server Profiler to create a trace and capture typical activity for each instance with both instances running.
B. Use Windows Performance to create counter log that captures performance counters for each instance with both instances running.
C. Use Windows Performance to create counter log that captures performance counters for each instance separately with each instance running on its own.
D. Use SQL Server Profiler to create a trace and capture typical activity for each instance separately with each instance running on its own.
Answer:B
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 SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 is running a default SQL Server instance and a named instance named MI_Sales. MiracleInfocom .com users complain that performance for both instances has deteriorated over the last six months. You want to determine the memory and processor resource requirements of the two instances as well as any resource conflicts between the two instances. What should you do?
A. Use SQL Server Profiler to create a trace and capture typical activity for each instance with both instances running. B. Use Windows Performance to create counter log that captures performance counters for each instance with both instances running. C. Use Windows Performance to create counter log that captures performance counters for each instance separately with each instance running on its own. D. Use SQL Server Profiler to create a trace and capture typical activity for each instance separately with each instance running on its own.