delphilenny
asked on
sql services too much memory
i'm running 2003 server and its run fine for 2 to 3 days then the sql takes over and from 2.39 gb of memory and consumes 3.7 gb of memory making the server to slow. sql jumps to a 900 mn of memory usuage. what can trigger the sql ?
could be anything...sql is a resource hog. This is why you should run SQL on its own server....
That is be design. Why is it a problem? If you are running other apps on the same box such as (God forbid) IIS, than you may not have any recourse but to cripple MS SQL Server and limit the Max memory used by it.
ASKER
is sbs 2003 server is not running iis, but is running 3 programs that runs in sql and it has 3 sql separate services, is running fine now for 4 days, today but eventually out of nowhere the service memory climbs from 200 to 900 leaving the server without memory. i run act, quantum and ecs (service software) all are running sql services, aldo i have backupexec.
If (against all recommended practices) you are running other apps on the same box you will have to set the maximum memory used by SQL Server and restart the service. This way you limit the amout of memory used by MS SQL Server which will not perform as well, but at least it will allow other apps to run.
ASKER
how i set the maximun memory for an application (SQL)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.