• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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 ?
0
delphilenny
Asked:
delphilenny
  • 3
  • 2
1 Solution
 
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
 
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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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
 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now