You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company. You create a maintenance job named DB_Job for Certkiller -DB01 and configure the job to run when the processor utilization on the server drops below 15%. A week later you notice that the scheduled maintenance job has not yet run. You open System Monitor on Certkiller -DB01 and notice that the processor utilization is currently at approximately 5%. You need to ensure that the maintenance job runs when the processor utilization drops below 15%.
What should you do? (Each correct answer represents part of the solution. Choose two.)
A.
Open the DB_Job Properties dialog box in SQL Server Management Studio.
B.
Open the SQL Server Agent Properties dialog box in SQL Server Management Studio.
C.
Open the DB_Job Properties dialog box in SQL Server Configuration Manager.
D.
Modify the advanced settings for each job step.
E.
Modify the idle CPU condition settings.
Explanation:
Maintenance jobs run under the SQL Server Agent. You must configure the CPU condition settings for the SQL Server Agent on the Advanced tab of the SQL Server Agent Properties dialog box. The CPU condition settings define the threshold and length of time that the SQL Server Agent uses to determine if the CPU is idle.
Incorrect Answers:
A, C: The SQL Server Agent determines when the CPU is idle. Therefore you should configure the threshold and length of time that the SQL Server Agent uses to determine if the CPU is idle. This can be done on the Advanced tab of the SQL Server Agent Properties dialog box, not the Properties dialog box of the job.
D: You must configure the CPU condition settings for the SQL Server Agent on the Advanced tab of the SQL Server Agent Properties dialog box. The CPU condition settings define the threshold and length of time that the SQL Server Agent uses to determine if the CPU is idle.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: SQL Server Agent, CPU idle conditions
Microsoft SQL Server 2005 Books Online (2006), Index: indexes [SQL Server], reorganizing