You are a database administrator for AIOTestKing.com. A new SQL Server 2005 computer named AIOTestKing B hosts a mission-critical customer relationship management (CRM) database. All of the companys 500 employees in the sales and marketing departments access the CRM database. Your department has an annual budget for the purchase of new hardware and software. You need to devise a monitoring strategy that enables you to make decisions about the history of server performance. The monitoring strategy should also advise you on how to best allocate funds for hardware upgrades. What should you do?
A.
Create a series of performance alerts to notify you when %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec exceed acceptable thresholds.
B.
Use System Monitor in graph mode to display information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. Perform this task at regular intervals during periods of peak server activity.
C.
Use SQL Server Profiler to capture information to a SQL Server database table.
Perform this task at regular intervals during periods of peak server activity.
D.
Configure a counter log to capture information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. Schedule the log to execute at regular intervals, and store the information in a comma-delimited text file.
Explanation:
By the capturing the %Processor Time, Average Disk Queue Length, Pages/Sec, and Bytes Total/Sec you monitor all the relevant data needed to base your decisions on. By running them on a reoccurring interval and saving the data you provide the possibility to create graphs showing decreased performance over time.