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 |
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
 Posted - 2009-03-18 : 09:21:06
|
| Hello,Within the properties of SQLServer (2K5), the min memory is set to 0, and maximum (in MB) set to 2147483647. This translates to over 2 million GB's. The server has 8gb of physical RAM and a 12GB page file.Can anyone please confirm if this figure looks crazy?!? I have inherited this system, which is a primary one, and would like to avoid any memory consumption issues going forward.Many thanks! |
|
|
pootle_flump
1064 Posts |
Posted - 2009-03-18 : 09:31:40
|
| That's just the default. If you have memory issues you might want to limit it. Are you experiencing memory pressure? Is this a 64bit installation? Anything else running on the box (IIS etc)? |
 |
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
Posted - 2009-03-18 : 09:35:46
|
quote:
Originally posted by pootle_flump
That's just the default. If you have memory issues you might want to limit it. Are you experiencing memory pressure? Is this a 64bit installation? Anything else running on the box (IIS etc)?
Gotcha. I figured it must have a good reason for being there :)This is a 64-bit installation, and yes - it seems they often run out of physical memory and SQL starts paging. Based on the notes I've received, the netlogon service is then affected?? Event viewer logs from past instances show the server can no longer communicate with the domain controller.I've seen SQLServer lock-up and stop accepting incoming connections, but usually at the database level. This appears to be happening at the server level. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2009-03-18 : 10:05:27
|
| Well staring point is to make sure there is a ceiling for SQL, allowing a minimum of half a gig (probably more like a gig - see how you go) for the OS.Memory pressure doesn't always mean you have a memory bottleneck - it can be caused by other hardware or configuration issues. |
|
|
|
|
|
|
SQL Server Properties - Min/Max Memory