What are two possible ways to achieve this goal?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A.
In the SQL Server Maintenance Plan Wizard, use the Check Database Integrity option.

B.
In the SQL Server Maintenance Plan Wizard, use the Reorganize Index option.

C.
In the SQL Server Maintenance Plan Wizard, use the Shrink Database option.

D.
In the SQL Server Maintenance Plan Wizard, use the Clean Up History option.

E.
In the SQL Server Maintenance Plan Wizard, use the Execute SQL Server Agent Job option.

Explanation:
When you indexes are not heavily fragmented you can reorganize indexes, which uses few system resources and runs automatically online. In SQL Server 2005, certain operations such as large delete operations or -one-time data loads might leave database files larger than they need to be. SQL Server 2005 enables a DBA to shrink each file within a database to remove unused pages and regain disk space.



Leave a Reply 0

Your email address will not be published. Required fields are marked *