Does anyone know if such a thing as a task manager for SQL exists?
I have a client who has a custom application with a SQL DB, it would seem that when the server goes slow and eats both ram and pagefile, is when a user performs a search, but when the results are huge, ie they didnt put more specific criteria in, they end up end tasking the process, however it still seems to be running and the only way at the moment to clear it is rebooting the server.
Currently sql is using 800mb ram and 800mb pagefile, but the total page file has just hit 2gb and its crawling.
The server has 2gb ram, but only 500mb free now
Thanks


LinkBack URL
About LinkBacks
Reply With Quote

) which may or may not be of some use?
