You work as the network 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. Recently the MiracleInfocom .com network users started complaining that server response has degraded rapidly. You decided to monitor the following counters: 1. Processor: % Processor Time You discover that the performance counter is consistently over 90 percent. The Baseline values for this counter are typically in the 40 to 60 percent range. During the course of the day you determine that the SQL Server process accounts for less than 50% of the processor time. You are required to identify and correct the problem as quickly as possible. What should you do?
A. The server should be scanned for missing updates.
B. The server should be rebooted.
C. The SQL Server service should be stopped.
D. The server should be scanned using anti-virus software.
Answer:D
You work as the network 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. Recently the MiracleInfocom .com network users started complaining that server response has degraded rapidly. You decided to monitor the following counters: 1. Processor: % Processor Time You discover that the performance counter is consistently over 90 percent. The Baseline values for this counter are typically in the 40 to 60 percent range. During the course of the day you determine that the SQL Server process accounts for less than 50% of the processor time. You are required to identify and correct the problem as quickly as possible. What should you do?
A. The server should be scanned for missing updates. B. The server should be rebooted. C. The SQL Server service should be stopped. D. The server should be scanned using anti-virus software.