June 26, 2009 at 7:37 am
Hi Experts,
I am using SQL Server 2005 having a database of size less than 10GB and user connects less than 50.
RAM :32GB
Disk Space:360GB
The problem Is that SQL server is using more than 9GB of memory.
Is that an issue?
Please advice on this . What is the normal memory usage of SQL Server?
TIA
June 26, 2009 at 9:03 am
It shouldnt be a problem. SQL server uses as much as it needs and with the kind of RAM , it is happy...
Are you running X64 or x32 and is it windows Ent.Edition 2003 or R2 Ent Edition.
what about SQL is it Enterprise or Standard Edition: and x64 or x32.
Maninder
www.dbanation.com
June 26, 2009 at 12:15 pm
It is not a problem, but why would you spend that kind of money and allocate those kinds of resources to support such a small system?
Are you looking at adding instances/databases to this server in the near future? Are you expecting a tremendous amount of growth that you need 360GB of storage?
If you are in fact looking to add instances/databases to this server, then make sure you limit each instance to a maximum amount of memory so that the total does not exceed 26-28GB (leave at least 4GB for the OS, and for multiple instances you would want to leave 6GB).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 27, 2009 at 12:26 am
Thanks for the reply.
We are using x64 windows server 2003 and SQL Server 2005 Enterprise Edition.
Can anyone please tell me the memory characteristics and management of SQL Server?
We are going to have a banking application to use this server thats why we use this much resource.
TIA
June 27, 2009 at 3:35 am
You may want to go through this blog for details on memory management by Sql Server.
http://blogs.msdn.com/slavao/archive/category/9005.aspx
June 27, 2009 at 9:53 am
Hi Ratheesh,
You are probably not in a position to be able to share the information with us but which Banking Application are you looking to deploy?
I may be able to provide you with specific advice so pleased feel free to send me a private message if you prefer.
The provider/source of the application should be able to provide you with what their minimum recommended configuration is in order to support their application platform?
To help you configure your SQL Server Platform take a look at the following Link:SQL Server Resources[/url]. There are also specific references to memory configuration articles and posts which will no doubt assist you.
Hope this helps.
Cheers,
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply