Chapter 21. Ten Ways to Keep Your SQL Server 2008 Databases Humming

Administering a SQL Server 2008 database can certainly be a full-time job! Throughout this book, I share some tips that will help you reduce the amount of time you spend on database administration and improve the effectiveness of your efforts. In this chapter, I summarize the top ten things you can do to improve your SQL Server database performance and preserve your sanity!

Monitor Query Performance

When it comes to SQL Server 2008 performance tuning, one size definitely does not fit all. You should monitor your database performance to watch for bottlenecks and tune the database to the specific queries that your users commonly perform. SQL Server 2008 provides two tools to help you with this monitoring:

  • SQL Trace: Allows you to monitor the performance of individual queries running on a SQL Server database.

  • SQL Server Profiler: Provides a user-friendly graphical interface to SQL Trace functionality.

For more detail, see the discussion of SQL Server Profiler and SQL Trace in Chapter 14.

Back Up Your Data Routinely

Something will go wrong with your SQL Server database at some point. This isn't a question of "if", but "when." Therefore, you should routinely perform database backups to ensure that your data is available in the event of a disaster or technical failure.

For more information on backing up and restoring SQL Server 2008 databases, see Chapter 18.

Verify Database Integrity Often

As with any complex information systems, ...

Get Microsoft® SQL Server® 2008 For Dummies® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.