Category Archives for "SQL Maintenance"

Tip of the Month: WAIT_AT_LOW_PRIORITY option for Index Rebuilds

By Lori Brown | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

— By Lori Brown  @SQLSupahStah Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds. Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION […]

Continue reading

Large MSDB Database From sysmaintplan_logdetail Table

By Lori Brown | Miscellaneous , SQL Administration , SQL Maintenance , SQL Server

— By Lori Brown  @SQLSupahStah I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing […]

Continue reading

Backup Database Commands

By SQLRx Admin | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

SQL Server Administration: Backup database to one file or multiple files. Use these commands to back your databases up without using a maintenance plan. Backing up to multiple files is good to use for large databases and will break up a single large backup file to several smaller files. Good to use when large backups […]

Continue reading

Remove maintenance plans left after a server rename.

By SQLRx Admin | SQL Maintenance , SQL Server , Tip of the Month

Many times when upgrading SQL Server or migrating to new hardware, it is necessary to rename the server when it’s ready to be used as production.  However, if any maintenance plans created before the server was renamed are still present after the rename, you may find that trying to delete the old jobs results in […]

Continue reading

What’s Causing Files to Automatically Grow

By SQLRx Admin | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Every DBA has encountered a database that has a mystery statement that will unexpectedly cause either the transaction log or a table to grow out of control and fill the drive.  Here is a way to find out who is running what statement that is causing the problem.  Find out what statements are causing database […]

Continue reading

Attempt to Recover a Suspect Database

By SQLRx Admin | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Databases will go into suspect state for a multitude of reasons. If you find your database in SUSPECT state, check all error logs and the Windows Event Log for any related errors, and try to resolve them. This is a disaster situation!  Refer to the script below for help. SQL Server Administration:  You can try to […]

Continue reading

September 2010 Tip of the Month

By SQLRx Admin | Performance Tuning , SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Performance Monitor: Monitor the performance counters SQLServer:Buffer Manager (Page reads/sec) and SQLServer:Buffer Manager (Page writes/sec) to detect poor performance. These counters measure physical IOs and not logical IOs. Heavy activity can indicate lack of database memory, a poor table implementation or can show that applications are not accessing a database correctly. Monitoring these counters will […]

Continue reading