• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 plan for both your system and user databases. If performance bottlenecks still occur, the SQL Server Profiler and the Windows Performance Monitor can help you to identify those difficult-to-diagnose performance problems.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint