Web Development

Ask something
Discussion Locked

sql memory issue2

0 helpful
1 reply

by haroon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Respected Sir/Madam,

I need your help and feed back on this matter:

I experienced one a problem that :

1)- SQL server running on Windows 2000 /20003 server machine
2)- all service pack+patches updates applied (sp4)

3)- whenever any kind activity like enterprise manager run or
Clients connect to server
Service of sql start eating of system memory and this memory
Never been freeup completely

One of my experience for get back sql in good working condition is rebooting system or
Sometime some system resource/memory back by service start /stop

If u have any of better solution kind tell me plz

Haroon Ahmed khan

1 reply

by jaqui

rewrite your queries to add a disconnect and flush at the end of each one.
this is a scripting problem, not a server problem

This discussion is closed to new replies.