Summary
The best-designed system will fail to meet users' needs if it performs poorly. The first line of attack when attempting to optimize performance is to ensure that the hardware on which SQL Server runs is adequate for the job at hand. When all the proper hardware is in place, you must determine that you have properly configured the SQL Server software. After you configure your hardware and the SQL Server software, you must make sure that you take all of the steps to properly maintain the server. You must implement and test a backup and restore procedure, as well as take steps to complete other maintenance tasks such as performing database integrity checks. The Database Maintenance Plan Wizard helps you quickly and easily set up a maintenance ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
