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 ?
delphilennyAsked:
Who is Participating?
 
Anthony PerkinsCommented:
>>how i set the maximun memory for an application (SQL)?<<
In order to set the maximum memory used by MS SQL Server see the follwoing from BOL:
Server Memory Options
http://msdn.microsoft.com/en-us/library/ms178067.aspx
0
 
chapmandewCommented:
could be anything...sql is a resource hog.  This is why you should run SQL on its own server....
0
 
Anthony PerkinsCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
delphilennyAuthor Commented:
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.
0
 
Anthony PerkinsCommented:
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.
0
 
delphilennyAuthor Commented:
how i set the maximun memory for an application (SQL)?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.