Search Results for &#8220;What to Do When DBCC CHECKDB Reports Corruption&#8221;

In my last post, I talked about how you can get 43%-67% faster backups. Today, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage. I don’t expect everyone to go to this level of detail by…

Can I Offload DBCC CHECKDB To Another Server?

Last Updated May 13, 2020

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing…

DBA Training Plan 4: Checking for Corruption

Last Updated August 13, 2019

CHECKDB and Corruption, DBA Training Plan

You would think that when SQL Server writes your data to disk, it’s totally safe. Forever. You would be wrong. It’s almost like there are gremlins out to get you, purposely trying to trash your data. In the really old days, it was problems with magnetic hard drives. Later, it was buggy shared storage arrays.…

An Idea For Improving DBCC CHECKDB

Last Updated January 2, 2019

Erik Darling

Hard Enough At this point, we’ve all probably got a database that’s a terabyte or more in size. If you’re anything like I was, you’ve got a ton of multi-terabyte databases, and the SAN admin has a special folder for your emails. When you’ve got a lot of large databases, normal maintenance is out the…

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Last Updated July 26, 2017

So far in this series, I’ve shown you how to corrupt a clustered index, then how nonclustered indexes can be corrupted independently. If you haven’t read those, you should start there first. Let’s start again with our 50Ways database, but this time we’re going to be good and make sure that we’ve got checksums enabled,…

Corruption 2: DBCC CHECKDB for VLDBs

Last Updated March 11, 2021

CHECKDB and Corruption, SQL Server

“All they know is that a database has exploded” the news reporter will say grimly, staring into the camera while a ticker rolls across the bottom of the screen announcing over and over again that (YOUR NAME HERE) has lost several terabytes of irreplaceable data. Family heirloom data. For charity. Orphans. Big-eyed baby animals who…

How often should I run DBCC CHECKDB?

Last Updated February 13, 2017

Erik Darling

There’s an old DBA saying… May you already have a backup restored A half hour before your boss knows there’s corruption What? There’s no such thing as old DBA sayings? Well, maybe if you all said something other than “no” once in a while, you’d be more quotable. Hmpf. Anyway, this is a serious question! And…

3 Things You Need to Start Doing to Your Database Server

Last Updated February 13, 2017

Jes Schultz

CHECKDB and Corruption, SQL Server

Taking care of your health is incredibly important (says the marathon runner). Eating right, exercising, and getting plenty of rest help you stay healthy and perform optimally. Does “an apple a day keep the doctor away” apply to cupcake apples? Your database server’s health is important to your company’s health. You need to take regular…

[Video] Office Hours Brought to You by Quest Software

Last Updated February 14, 2023

Videos

Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha: Wow, those logos are bigger than I thought. Here’s what we covered: 00:00 Start 01:20 reluctantly_tolerant : I used FCI instead…

Your Top 10 Ideas for SQL Server

Last Updated April 13, 2021

SQL Server

You’ve submitted thousands of bug reports and feature requests at feedback.azure.com, and here’s what you’ve voted as the top 10 requests right now: #10: MIN/MAX as non-aggregate functions. PostgreSQL and Oracle have the GREATEST/LEAST functions that work like COALESCE, allowing you to pass in a list of values and get the top or lowest. Sounds…

[Video] Office Hours 2018/10/3 (With Transcriptions)

Last Updated October 6, 2018

Videos

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tracking how recently a procedure was executed, maintenance plans, recompiling stored procs, parameter sniffing issues, troubleshooting replication with Always On, forecasting database growth and estimating capacity issues, tools for database growth forecast reports, RCSI, and much more.…

[Video] Office Hours 2018/8/8 (With Transcriptions)

Last Updated August 11, 2018

Videos

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips for getting a new SQL Server DBA job, using alias names for SQL Servers, database going into suspect mode during…

How Personally Identifiable Information Gets Around

Last Updated December 24, 2017

Processes and Practices

Let’s say someone – not you, dear reader, because you would surely never be this sloppy – is building a personal web site or a diary or a company or whatever: Transact-SQL CREATE TABLE dbo.People (LastName VARCHAR(50), FirstName VARCHAR(50), Age TINYINT, EmailAddress VARCHAR(50), Password VARCHAR(50), PersonNumber VARCHAR(50)); INSERT INTO dbo.People VALUES ('Bear', 'Papa', 45, 'papa@gmail.com',…

5 Signs Your SQL Server Isn’t Wearing Pants

Last Updated March 24, 2017

CHECKDB and Corruption, SQL Server

We see a lot of SQL Servers. During our sales process, prospective customers run sp_Blitz on their SQL Server, and we talk through the results. I see a lot of horrifying stuff. Over time, I’ve built up a pretty good sense of signs that a SQL Server is running around loose in the data center,…

[Video] Office Hours 2016/12/14 (With Transcriptions)

Last Updated May 20, 2018

SQL Server, Videos

This week, Brent, Erik, and Richie discuss their craziest SQL server troubleshooting issues, common causes of SSPI handshake errors, setting deadlock priority “high” on a query, vmotion high availability, best practices on Windows Server 2012 page files, and whether a career as a Database Administrator will be good for the next 40 years. Here’s the…

[Video] Office Hours 2016/09/21 (With Transcriptions)

Last Updated September 24, 2016

SQL Server, Videos

This week, Brent, Richie, Tara, and Erik discuss enhancing queries, database corruption, availability groups, parameter sniffing, sending mail via SQL server, whether SQL 2016 is solid or not, other versions of SQL, physical servers vs virtual servers, and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…

[Video] Office Hours 2016/08/31 (With Transcriptions)

Last Updated September 9, 2016