Archive for the ‘MS SQL’ Category

Советы по обслуживанию серверов баз данных от Paul S. Randal

Several times a week I’m asked for advice on how to effectively maintain a production database. Sometimes the questions come from DBAs who are implementing new solutions and want help
fine-tuning maintenance practices to fit their new databases’ characteristics. More frequently, however, the questions come from people who are not professional DBAs but for one reason or another have been given ownership of and responsibility for a database. I like to call this role the «involuntary DBA.» The focus of this article is to provide a primer of database maintenance best-practices for all the involuntary DBAs out there.
As with the majority of tasks and procedures in the IT world, there isn’t an easy one-size-fits-all solution for effective database maintenance, but there are some key areas that nearly always need to be addressed. My top five areas of concern are (in no particular order of importance):
  • Data and log file management
  • Index fragmentation
  • Statistics
  • Corruption detection
  • Backups
An unmaintained (or poorly maintained) database can develop problems in one or more of these areas, which can eventually lead to poor application performance or even downtime and data loss.
In this article, I’ll explain why these issues matter and show you some simple ways to mitigate the problems. I will base my explanations on SQL Server­® 2005, but I’ll also highlight the major differences that you’ll find in SQL Server 2000 and the upcoming SQL Server 2008.

Тег «Далее»

Рубрики:Database, HOW-TO, MS SQL Метки: ,