TheSQLGuru (3/14/2013)
You have been going round and round with this for over 2 weeks now. May I suggest that you get a performance tuning professional on board to really help you diagnose and correct the problem(s) you are encountering? Seems somewhat silly to hunt-and-peck on a forum for production problems that a good tuner could pinpoint and resolve in a matter of hours (or at worst a day or two)!!
As I said earlier:
I've opened a premier support case on it,
And and as I also said earlier
I have been working with SQL Server for a bit over 10 years
So while I've acknowledged that there are defintely a few people around this place that know more than I do, I'm no accidental DBA.
You can also see that another forum user is reporting similar problems, so I'm keeping this thread updated with new information mostly for his benefit, clearly the normal "can answer just about everything" users of the forum were unable to provide much assistance in this particular case.
I'm not sure what happened to this forum, the level of courtesy and respect seems to have dropped off. Perhaps it has become too cliquey.