We just got a new Windows 2008 server running SQL Server 2008 R2.
Our system is written in 'classic' ASP (I want to retire).
After a reboot the server works great and all aspects of the website function quickly, then, after a few hours, all updates start to generate timeouts and all sorts of screen start to fall over. Then my life becomes hell. At the moment I just reboot the server to give the others another few hours of work time.
Does anyone have any idea what would cause these timeouts to start happening after a few hours of operation?
Thanks in desperation...