2

I'm trying to clean up some of our maintenance plans and noticed that our TempDB is not getting it's weekly dose of DBCC CHECKDB goodness. I've tried to go into the maintenance plan and make sure it's there, but it's not showing up in the checkbox area. Any ideas why that would happen or have any pointers to make tempDB selectable again? I know I can always just add an Execute SQL Task but I'd like to have this all taken care of in one step by the maintenance plan. I've also tried creating a brand new plan and attempted to select it that way, still no joy.

It's a DW environment, 2008R2, 256GB RAM, 64 cores (HT enabled). Our TempDB files/logs are on a FusionIO card by themselves so there's no contention.

Thanks again!

  • 1
    Why do you have to use a maintenance plan for this where you rely on picking databases from a GUI, instead of just building your own checkdb commands? – Aaron Bertrand Oct 14 '14 at 20:49
  • 1
    Also be aware that CheckDB against tempdb does not perform several checks (such as catalog and allocation), and tempdb is re-created from scratch on service restart. I would hope if there are underlying hardware problems that FusionIO would tell you about them long before DBCC will. – Aaron Bertrand Oct 14 '14 at 20:50
  • 1
    It's how this box was configured when I started. I've since moved our primary production server over to a scripted approach and off maintenance plans , this one is next on the list, just wondering if anyone has seen this happen before and knew what was causing it? – Kris Gruttemeyer Oct 14 '14 at 20:52
  • 1
    I don't see tempdb either. Don't know how long it's been like that; I don't use maintenance plans on principle because they promote so many bad things. Maybe you can create one where you just select system databases (which is a separate option). – Aaron Bertrand Oct 14 '14 at 20:55
  • 1
    @KennethFisher I didn't mean to imply it wasn't worth testing. Just wanted to be sure the OP was aware that it doesn't test as much as one might assume. – Aaron Bertrand Oct 15 '14 at 19:22
3

Tempdb won't be available for you in the Mantainance Plan database list box, but you sure can run it as a script:

DBCC CHECKDB(N'tempdb')  WITH NO_INFOMSGS

According to Mr. Brent Ozar, you SHOULD check tempdb for integrity, and if Brent is saying that, that is good enough for me.

regards

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.