SQL 2005 high memeory usage

[helpeach0ther31]

Hi,

I am running SQL server 2005 std with 5 databases. For some reason the SQL server uses 12.8gig of memory. The only way i am able to stop the high usage is by putting min-max limits. How do i troubleshoot the issue. Any advice would be greatly apriciated. Thanks

 

[SQLBill]

That is the intended behavior. This is from the BOL:

The default memory management behavior of the Microsoft SQL Server Database Engine is to acquire as much memory as it needs without creating a memory shortage on the system.

Ref: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2f3c7e4e-3270-4c11-839b-32cc0f40eef7.htm

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875