zenworksb
asked on
insufficent memroy issue
I am getting this on one of our sql servers what can I do to resolve?
Description- There is insufficient system memory to run this query
Type:error
Source mssqlserver
Category(2)
Event id: 701
This is a sql server and it seems to do this after about 4 days and we have to reboot
Description- There is insufficient system memory to run this query
Type:error
Source mssqlserver
Category(2)
Event id: 701
This is a sql server and it seems to do this after about 4 days and we have to reboot
Do you have a memory leak in a program. Look in taskmanager at the delta's for your memory (you can add this by adding memory usage delta in view, select colums by processes in your task manager).
ASKER
i added memory delta and they all just say 0 with once in a whiel one at the top will say like 8 and disapear>?
leave it on for a couple of hours when it is the busiest, when it don't reclaim the memory you have a memory leak in your application.
ASKER
ok so if it does not reclaim the memory then that is a issue
Yep, and you have a memory leak and that's why you have to reboot you server every few days.
Mostly it is an application/sql problem which is bad programmed. U can rewrite the application or u can take precaution actions (like rebooting every night when it is possible).
Mostly it is an application/sql problem which is bad programmed. U can rewrite the application or u can take precaution actions (like rebooting every night when it is possible).
ASKER
sqlserver.exe has had mem allocated for a long time what can I do to reolve this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.