The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Sign in to Subscribe

Meeting Details

Making DBCC CHECKDB Go Faster

Thu, Feb 27 2014 19:00 UTC

Making DBCC CHECKDB Go Faster

Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times, along with its performance impact to Production systems, keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like Transaction log and VLF management, TempDB configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey's consistency checks were taken from 7 days down to 6 hours.


Argenis Fernandez

Argenis Fernandez is a Senior Database Engineer for SurveyMonkey based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys large SQL Server farms, high-end OLTP databases, managing Windows environments, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Prior to SurveyMonkey, Argenis previously worked as a Senior Database Administrator for Coinstar/redbox and as a Senior Consultant on SQL Server Core for Microsoft Consulting Services. In 2013 he founded the Security Virtual Chapter for the Professional Association for SQL Server (PASS) (http://security.sqlpass.org) .

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids