December 28, 2003 at 5:09 am
I need aid to learn to define the ideal amount of memoria to sqlserver it.
December 28, 2003 at 9:45 am
The easy answer: As much as possible. SQL Server will by default dynamically adjust it's memory and use as much as it can. If you don't have any other applications running on the server you can leave it that way.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles: http://www.sqlservercentral.com/columnists/chedgate/
December 29, 2003 at 3:04 am
Really it depends on your applications.
If your databases are not big, then it doesn't make sense give more RAM as your databases sizes are (+256 MB for Windows)
If you are only using OLTP like (well positioned and indexed) select/insert/update statements, not too many big sorts and not too many big selects which retrieves too many rows, then you don't need too many RAM
Bye
Gabor
Bye
Gabor
December 29, 2003 at 12:17 pm
When you think for RAM, you have to consider also what edition of SQL server you are running and what is the OS (running SQL on Win2000 server is not the same as Advanced or Data Center server). It's not only how much SQl will use, but aslo how much you have available. For examlpe, SQL Standard on Win2000 server will use no more then 2G doesn't matter how much available you have. If this is a machine designated to SQL server, then you do not need to worry about the memory - whatch for memory usage by SID, get the query/SP, etc. and tune the queries. If there are other applications running on the same server, then you could see how to limit them or SQL server itself. As much memory as possible is the right answer you already got, but if you have unefficient structures and statements, this will not help. (the last comment is just in case...)
December 29, 2003 at 2:19 pm
The simplest answer might be like this:
Are you using Standard Edition ?
Are you using Replication ?
Are you running applications Other than SQL Server or is this a Dedicated DB Server ?
If you are using Replication on SQL 2000 STD Edition
Min Memory 64 MB
Max Memory 75% of Total System Memory
Verify The Page File on The OS is not a miss matched Amount i.e. 256 MB - 1024 MB when possible use a fixed amount and spread over more than one drive if possible (check with your NT ADMIN)
In Most Cases Yes the Defaults work very well but I have found it very use full to follow the initial 25% Min Memory 75% max memory rule based on Total System memory
...Do not bump up the Query Memory Option !
Jim Babington
Jbabington
Jbabington@hotmail.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply