You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Users report that the application sometimes responds very slowly for several minutes at a time. This problem occurs throughout the day and typically takes place after a large number of database rows are deleted. The database properties are configured as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that this performance problem does not recur. What should you do?
A.
Set Page Verify to None.
B.
Set ANSI Warnings Enabled to True.
C.
Configure the database so that the AUTO-SHRINK option is disabled.
D.
Configure the database to be the simple recovery model.
Explanation:
When a large number of rows is deleted the SQL Server will try to AUTO-SHRINK the database and will temporarily respond slowly due to the increased workload.