SQL Server using 70% of RAM !!. Pls advise

Question

SQL Server using 70% of RAM !!. Pls advise

aj-156165

SSC Veteran

Points: 230
More actions
December 30, 2005 at 11:55 pm

#113058

Hi,
I have win2k server with 1 GB RAM hosting a ASP.NET application and SQL2k Engine. I have about 35 users (concurrent expect 15-20 users) to access ASP.NET applicaiton which is basically a reporting tool.
I have a feeling that my Win2k server RAM is not enough to provide better performance to my users upon seeing 'Memory Usage' of "sqlserver.exe" in the task manager.
Top Memory usage applicaiton repoted in the Task Manager on 31st Dec at 09h00 as folllows on
ImageName          CPU Time          Memory Usage
sqlsrver.exe          1:57:27            704,236 K
aspnet_wp.exe      00:01:16            43,832

Is there anything abnormal on above results ? Would be there any major impact on application performance if I continue keeping the server with same spec. ?
Pls advise.
AJ

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

rsharma SSCarpal Tunnel Points: 4865 More actions · Answer 1

1GB of RAM is very less if you have your application, IIS and SS2k running on the same machine. If you are using SQL Server Standard Edition, then you can only use up-to 2GB RAM. I would recommend that you bump up the memory to 3 or 4GB so that SS2k has 2GB available to it and the OS + the application + IIS has the remaining 1 / 2GB.

If you have not used the "max server memory" parameter to limit the memory available to SQL Server (not typically recommended unless you are in a memory crunch and based on a couple of other factors -- search this site, it has some discussions on those), then the above numbers are not surprising at all based on how SS2k uses memory.

aj-156165 SSC Veteran Points: 230 More actions · Answer 2

Thanks for your advise.

I'm thinking about moving whole applicaiton to new box with dual processor with 4 gb RAM.

Yes, I'm using SQL2k Standard Edition. At the moment memory has been configured with dynamic otpion with maximum memory of 1 GB (total RAM).

Once I have server with 4 gb ram, I think you mean that I would configure memory with option "use a fixed memory" where I would assign 2 gb.

Please correct me if my understading is not correct.

Thanks..

AJ

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Once you get 4GB, you can just let SQL run. I never see it run above 1.8GB.

I'd give it at least that much and you should be better off.