In the last few weeks our vault comes to a complete halt during the day. Does any one have any know issues or reasons that would generate that behavior?
In the last few weeks our vault comes to a complete halt during the day. Does any one have any know issues or reasons that would generate that behavior?
Adrian,
Check your backups and make sure they aren't running long, and make sure you don't have a networking issue or anything like that. I've seen this before on VM and I believe they overbooked the hardware, but you could tell on that server just by remoting in that it had slowed to a crawl. Also verify the simple recovery model, I've seen an oversized log file take down a SQL server before.
Adrian,
Check the SQL server logs in the Management section of SQL Server Management Studio for hints.
Also check your recovery model on the database and make sure it's simple and the log file is getting truncated. If you wouldn't mind could you right click your database in ssms and go to properties and screencapture the general tab: