SQL Server Maintenance

A database maintenance plan is implemented using a series of DBCC commands and system stored procedures. DBCC stands for database consistency check or database console command. There are numerous documented and undocumented DBCC commands, but only a few of them are used for maintenance. A typical database maintenance schedule involves the following activities.
1. Check database consistency and data integrity (DBCC CHECKDB)
2. Rebuild indexes or remove index fragmentation (DBCC DBREINDEX)
3. Update statistics (DBCC SHOW_STATISTICS)
4. Report on space utilization in data and log files (DBCC SHRINKFILE)

Article by Kevin Kline and Baya Pavliashvili from SearchSQLServer, more

Comments

Post a Comment

Popular posts from this blog

SQL 2008

SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. more
Read more

Microsoft a BI Force

Image
Microsoft BI is a new tool. It is delivered through three layers or workloads: data warehousing, reporting and analysis, and performance management. These are designed to provide a consolidated, comprehensive data source and tools to help improve decision making. Microsoft BI is to help decision makers at all levels. An IDC report issued this summer—found that Microsoft’s BI market share growth outpaced that of most rivals. More to the point, both Gartner and IDC now agree: Microsoft is now a BI force to be reckoned with, trailing established leaders such as Business Objects SA, SAS Institute Inc., and Cognos Inc. for overall BI market laurels. more
Read more

Understanding DBCC SHOWCONTIG

Image
DBCC SHOWCONTIG is a wonderful tool which helps you to understand quite a bit more about your system than is obvious at first glance. And, frankly, the documentation doesn't use terminology that makes it very obvious either. So, this article will focus on a few of the big ideas behind the tool using SQL Server, and how you can use it to better understand what is going on inside your SQL Server box. Probably one of the most significant performance problems found in databases is centered around table data fragmentation. One situation that may be analogous to table fragmentation might be an index at the end of a large book. A single index entry in such a book might point to several pages scattered throughout the book. You must then scan each page for the specific information you require. This differs significantly from the index of the phone book which stores its data in sorted order. A typical query for the name "Jones" might span multiple consecutive pages, but are always ...
Read more