Running DBCC CHECKDB on your databases is critical to avoid a potential nightmare. Ideally we do this regularly to find & fix corruption. However, because of the possible performance impact on server resources, sometimes it isn’t cost effective to run. Many companies actually forgo it; simply because they do not have the means to handle it. With SQL Virtual Database software, we can make it accessible for them to start.

In this session John Morehouse will show you how to use the IDERA SQL Virtual Database in conjunction with PowerShell to ensure all of your databases get checked by this critical process with minimal impact.

Speaker: John Morehouse is a Database Architect with Farm Credit Mid-America out of Louisville, KY. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. He is also heavily involved with the Professional Association of SQL Server (PASS).

Topics: Database Performance, Database Diagnostics
Products: SQL Server Tools for Better Performance