April 16, 2003 at 4:17 am
I am looking for recommandations regarding the memory distribution for SQL 2000 server. In the memory tab of the server properties you can define use a fixed memory size or dynamically configure SQL server or even reserve physical memory for SQL server.
Are there any hints available or must it be handled according trial and error?
Thanks for any info
mipo
April 16, 2003 at 4:20 am
Hi,
if you are a subscriber to SQL Server Magazin you can follow this link
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37890, that's what I have just read, but I'm sure there are plenty of other sources out there as well.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 16, 2003 at 6:53 am
In most situation, The memory should be configured dynamically to allow SQL Server to adjust memeory allocation as it needs. But if you have large amount memory in your machine, for example, above 4GB, and you have to configure AWE in order to use them. In this case, you may have to fix the memory allocation. At least SAP suggests for their application running in SQL Server.
By monitoring memory usage, you will get some ideas to adjust the memory allocation. See BOL "Monitoring Memory Usage".
April 16, 2003 at 7:12 am
Agreed. Use dynamic without AWE, use static with AWE.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply