So I ran:

DBCC CHECKDB() WITH DATA_PURITY

On a recently restored test DB and it ran with no errors. Should I go ahead and schedule a production run? It took...

That is great information. I will do some digging and look into running that process this weekend.

Thanks for all the help,

Dane

No I check the results of CHECKDB every week and haven't seen anything flagged as an issue. I will say that this DB was converted from 2000, and I...

So the update usage seems to have corrected the issue.

Can someone give any additional insight as to why that would of corrected this type of problem?

Thanks for all the help,

Dane

I am 95% sure. All the other databases are the same except the one. I will run those scripts that you caught in a trace...and if I still...

It is RISDB, and I was able to look up some of the metadata with Powershell. I can see that it was created last year by one of our...

Unfortunately it doesn't show up at all in SSMS.

I was able run the rebuild this morning after running a:

DBCC UPDATEUSAGE( db, 'item' ) WITH COUNT_ROWS, NO_INFOMSGS

The rebuild completed under a second...an issue though is that I didn't try...

Here is what I see in sys.dm_os_sys_info:

physical_memory_in_bytes

68718006272

So about 64GBs.

At this point I am only running the individual rebuild. With, or with out, (online=on) I get the same results.

Thanks again!

-Dane

Shouldn't cross terms I suppose 🙂

I immediately saw a blocking chain on the master database. I found it to be dangerous, because I really wanted to troubleshoot it...

In this...

Just ran a reorg and it finished in less than second...tried the rebuild and it immediately created a backup on the master database. I will have to wait until...

Yes. We are using Enterprise. It is just odd that it leads to a lot of blocking though...as soon as the script starts up I see processes marked...

Probably...but no more than the other tables. I do notice that a lot of blocking occurs when it is being rebuilt (even with online=on).

I will see if I can get a backup restored to another box, and see if the same issue shows up...and if it does then I will make adjustments to...