Database Maintenance - Category Archive
The following is a list of all entries from the Database Maintenance category.
Management Studio Improvements in SQL Server 2008
Database Administration, Database Maintenance | August 8, 2009 | 3:17 amSQL Server Management Studio in SQL Server 2005 has faced some tough criticism from DBAs over the years. Microsoft has tried hard to make up for the troubles of the past, bringing a multitude of improvements in SSMS 2008 that I go through in this article. Read more…
The Maintenance Plan Wizard Can Lead You Astray
Database Maintenance | April 16, 2009 | 3:57 pmIn theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is that unless you really know what you are doing, you can hurt the performance of your SQL ...read more
Don’t Make Dumb Mistakes by Duplicating Indexes
Database Maintenance, Indexing | April 15, 2009 | 3:59 pmJust today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server Bible; and Itzik Ben-Gan. The script is available ...read more
Do You Verify Your Database Backups?
Database Administration, Database Maintenance, Opinion | February 24, 2009 | 12:47 pmIn the past, I have written and spoken a lot about SQL Server “best practices”. One that I emphasize over and over again is the need for DBAs to verify, regularly, the integrity of their database backups. However, I sometimes feel my advice is falling on deaf ears. When giving a presentation, I often ask ...read more
Check Out the Free Performance Analysis of Logs (PAL) Tool
Database Maintenance, Performance Tuning | December 23, 2008 | 4:23 pmTraditionally, analyzing Performance Monitor data has not been an easy task. It often involved viewing Performance Monitor logs in graph view, seeing what was happening, and hoping that your knowledge and background in SQL Server and the Windows OS provided you with enough information in order to help you to be able to pinpoint specific ...read more
How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data Collector
Database Maintenance, Performance Tuning | September 25, 2008 | 4:53 pmIn SQL Server 2008, a new feature called the Performance Data Collector was added. It has the ability to collect SQL Server-related performance data, store it in a database called the Management Data Warehouse, and then produce various performance reports based on the collected data.
By default, the Performance Data Collector includes three different data collection ...read more
Twitter
Linked In