Paul,

Thanks for that, I could move tempdb to the Raid 0 array that the OS lives on but that still wouldn't explain why it is only on the 64bit platform...

Hi Phillip,

The Databases were originally SQL 6.5 databases and have been upgraded to each version as it hase come along, there was originally 25 subscribers to this main publisher, over...

Paul,

Yes I think it is something with the 64bit version, it's very frustrating, you get a large box throw RAM and Disc at it and then are held back by...

Hj all

I have given up running DBCC CHECKDB on the production server, If I run it on a 32bit version it completes in about 15 - 18 mins.

The results of...

Phillip,

The database is just over 17GB.

The results from sp_configure are:-

Test Box:-

name ...

Paul

That is what we have done, we took a backup of the DB and moved it to another server and ran checkdb, it took about 20 mins to complete.

What is...

Paul,

Thanks for the reply, you are right I dont think it is CHECKDB that is causing the problem as we took the same DB onto a 32 bit system and...

Hi Paul,

Unfortunately both of your suggestions failed. It seems that with SQL x64 standard edition you cannot lock pages in memory so DBCC CHECKDB keeps paging and therefore gets itself...

Phil,

Thanks for that I will try running DBCC CHECKDB with PHYSICAL_ONLY option. and also upgrade to the cumulative update.

Unfortunately whilst I can run it against a test database I have...