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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-04-22 : 22:13:18
|
| Hi ,We have a couple of SQL Servers in Dev. and Production . What I have observed is on most of the servers the SQL memory is configured in such a way that min memory is 0 MB and max memory is 2048 GB . The server has total 2 GB memory . This is an example of one of the SQL server configurations . Is it proper to allocate all the physical memory to SQL Server ? There are 52 databases in all where most of them are small volumes . There are no other applications running on SQL Servers . Similarly there are other SQL servers where full physical memory is allocated as max. memory . Further i observed that some servers have boost SQL priority over Windows option and Auto start MSDTC service box checked I am mentioning this b'cause we have some performance issues on some servers . I checked in BOL but the info. was not clear . Would like your expert comments from practical experience if you could share .Tks and Regardsadmin001 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-24 : 12:55:29
|
| Have you determined if the lack of available memory is the cause of the performance problem? Have you run the Performance Monitor/System Monitor tool or how about SQL Profiler to determine what the performance problem is?By default, SQL Server is configured to use all of the physical memory (occurs at installation time). We always subtract about 128MB of RAM from the max server memory parameter so that the OS and other processes/applications are also able to use memory.Tara |
 |
|
|
|
|
|
SQL Server memory and MSDTC .