PrepAway - Latest Free Exam Questions & Answers

Tag: sql server barch requests /secthroughput

What should you do to improve the performance of the CK_Sales database?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Sales. The CK_Sales database stores sales data for the company. Domain.com users complain that the performance of the CK_Sales database has deteriorated over the last few weeks. You use System Monitor to monitor the performance of Certkiller -DB01 and receive the output as shown in the exhibit.

You also notice that the ratio of SQL Recompilations/sec to Batch Requests/sec is unusually high. You suspect that the number of recompiles is causing the high processor time value. You need to improve the performance of the CK_Sales database.
What should you do?