I take that you are not allowing ad-hoc sql to be run against your sql server. We had the same problem until i got the developers using stored procedures as each time they ran some ad-hoc sql it created a new query plan which uses memory. When we got them to use stored procedures the memory...
Mike
You might want ot try BMC WebDba. It is free and seems ok. I managed to get it working without too much trouble.
You can get it from
http://www.bmc.com/ddm/webdbafree.html
Mark
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.