I have a database that I have run every optimization on I can think of. We have tuned the server to the best we are going to get and I have tuned the queries as well and response times are reasonable.
The only thing left to do is to get caught up on maintenance. CHECKDB has not been run in over 1000 days. I actually do not think it has ever been run. I am afraid to do it because of what it might find. If the data is corrupt the backups will be corrupt. There is potential loss of data if fixes are needed and certainly some work if anything else is found.
They were on RTM and I had them patch to SP 3 does this help?
What are the issues I could face? Would anyone advise a course of action? PHYSICAL_ONLY at first? NOINDEX? I just created about the only ones that are there.