April 20, 2011 at 4:16 am
Hi All,
Iam using sql server7.0
I got a alert mentioned below..
sqlserver service is taking the maximum memory on the box.
could any body tel me how to resolve this.
Thanks in advance..
April 20, 2011 at 8:29 am
Wow, really SQL 7 still?
SQL Server will take all available memory unless you have set the MAX memory setting, which you should set. I don't remember how to do this in SQL Server 7. You'd have to look it up.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 20, 2011 at 11:14 am
Check the alert, and see what it is configured for. This ought to be under SQL Agent in Enterprise Manager.
As far as limiting memory, Jack is correct. You need to set a max. You can do that with sp_configure
http://msdn.microsoft.com/en-us/library/aa259616%28v=SQL.80%29.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply