This problem arrises about once every 3 days. We have on average about 125 users running an application that connects to 64 bit microsoft sql. the server has 24 gig of memory and 16 gig is allocated to the application. The developer says that 10 gig of mem to sql is more than enough. the users run a remote desktop environment between 8 terminal servers. all users slow down dramatically at about the same time. There seems to be nothing wrong with the server. no memory utitlization increase. no spikes in cpu. the select statements in real time monitor seem to snap along. also some of the other applications running on the users session will seem to slow at the same time. outlook for example. when we restart the sql service all problems clear up. users are fine for a few days. until it arrises again. we are scratching our heads.
8 terminal servers hosting 200 sessions.
all slow at the same time. especially the app running on the sql server.
restart the service associated with that instance of sql server and everything speeds up.