Database Mirroring

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.

Thesaurus Files

Mirrors

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.

Get Rid of All Those Pesky 1 MB File Growth DB Files

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?

Shrinking all log files on SQL Server 2008R2

It shrinks all log files for the databases created by users.

Tracking Processes

DBA Basics