Ok, here is my story. If someone can help me solve this I will seriously send you a bunch of pizzas and award you any points I can.
We have a client that runs a mission critical server - server 2008 R2 with SQL 2012 as the database for the application. They are both one server now because of this problem.
It seems that somewhere near the middle of each month the server slows to a crawl and SQL cannot finish queries and the web app it runs just stops working. We tried everything with the software vendor (their software uses SQL, they setup sql and the software and we have a very expensive support contract with them). Had dell scan the systems, held it in stasis with no updates or changes for a month, poured through even logs, restarted all services, restarted the server and so on.. the ONLY thing that will fix it is shutting down the server, unplugging the server for 10 minutes and booting it back up. Then its super fast and everything runs again.
while this problem is happening processor utilization is up, at about 50 percent, the server slows down to half speed (EVERYTHING runs slow) and SQL slows to a crawl. There are no special scripts, queries, anything like that running that we can see or know about.
- previous to this setup, the server software and SQL server were on 2 new separate physical servers (everything is physical, no virtual)
- when this problem came along oringally, vendor, IT nobody could figure it out, didn't know the power off trick yet so only option was a complete re-install of the software and sql on another server together. problem comes back a couple months later on this completely different physical server
- at least now we can fix it but it seriously disrupts the company and everyone freaks out