we have a sql2005 installed on windows 2003 server with 4gb of RAM.
We have lot of transaction intensive procedures/functions running on every minute through sql agent. My 'Available Physical Memory' is going down hour by hour and after some point of time, the sql agent stops automatically due to memory pressure. I checked
blocks and lock on the database server and failed to see anything of those kind.
Can I use dbcc commands to clear memory related cache?
This is driving me crazy and please help me to resolve this.
Best regards, Sengwa
View Complete Post