Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tishri
Yak Posting Veteran
95 Posts |
 Posted - 2007-07-24 : 06:57:45
|
| im configuring my server its windows 2003 and 1 gig ram. i am going to use this computer as dedicated server for sql 2000. Is it better to enable static memory allocation or dynamic? :)TCC |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-24 : 07:32:05
|
| static and dynamic memory allocation for sql server?? what's that?sql server takes all the memory it needs._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2007-07-24 : 07:37:13
|
| there is an option for sql server to set the minimum and maximum size of memory and also there is a fix size of memory.. i mean does fix or dynamic memory allocation affects the performance of the sql server.?TCC |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-24 : 07:49:54
|
| yes it does.if sql server lacks memory it will read data from disk. and that is not good for performance._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
dynamic or static