database consistency report

Question

database consistency report

Tobar

SSCarpal Tunnel

Points: 4876
More actions
April 4, 2014 at 4:21 am

#287311

I am afraid this is going to sound stupid as soon as I say it, but here goes.
I ran the database consistency on 2 databases, the first little used (and relatively new), the other much more active. On the little used db the report didn't return any lines. On the much more active DB it returned 6 lines (one each for the last 6 days). They all reported 0 errors. Should I be concerned that the one database is actually reporting information, even if it appears to tell me "all clear"?
<><
Livin' down on the cube farm. Left, left, then a right.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Without seeing the 'six lines' which you refer to, no idea.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 2

OK. Sorry about that.

I am just shutting down my system to head into my workplace. I will update this space when I am re-connected.

Thanks.

<><
Livin' down on the cube farm. Left, left, then a right.

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 3

Here is a screen shot of the report. I appreciate your help. I have always appreciated your opinions, even if I find your user name intimidating for some reason. Maybe it is the guy with the light-saber. 🙂

[OK. HERE is a screen shot of the report].

<><
Livin' down on the cube farm. Left, left, then a right.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

All I can tell from that is that CheckDB is scheduled to run daily and is running daily.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 5

OK. That is a good thing I guess. Evidently one of the other admins turned that on. I was concerned that maybe they started appearing because SQL Server "thought" there might have been an issue/

Appreciate the help.

<><
Livin' down on the cube farm. Left, left, then a right.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

SQL will never, under any circumstances, run CheckDB automatically. That would be a very bad thing.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 7

Another good thing to know.

Is that because of a performance hit?

<><
Livin' down on the cube farm. Left, left, then a right.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Same reasons SQL won't automatically take backups or automatically create indexes for you, impossible to decide correctly for all possible situations and guessing wrongly could open MS to liabilities.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass