We are a CRM SAAS Provider. For some reason each morning between 8h00 & 9h30 am SA (Harare) time our system crawls almost to a halt.
According to the SQL logs the tempdb file is cleared and there is a restart. Straight after the restart for the rest of the day the system performs very well.
We are on SQL 2008 R2 which is hosted at a secure third party data centre.
There are 820 users on the system - not all at the same time.
How do we prevent this reoccurring. The problem is critical.