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 |
|
sgoodwi3
Starting Member
6 Posts |
 Posted - 2007-02-23 : 11:18:35
|
| For anyone with a larger number of databases (500+): How many do you have in a single instance. If you are using multiple instance on a single server, how many dbs per instance. This is why I'm askingWe are experiencing 701 "out of system memory" and temporary (usually) system freezes when the error occurs. We have 32bit 2005 version 9.00.2153.00, 32GB of memory, AWE enabled, quad dual-core 3GHz hyperthreaded server. Nether the bPool or VAS show any pressure when the "out of system memory error" occurs. Since this error usually indicates a VAS problem we tried increasing VAS to 1GB w/the -g flag. It made no difference. PSS has been working on the case for 3 weeks. They dont seem to be finding any evidince of memory pressure either. When I last spole to the escalation engineer yesterday it seemed that they are going to recommend reducing the number of databases on the server. I asked for clarification as to whether we are hitting a 32 bit barrior, an instance limitation, or both. I am awaiting the answer. How many databases do you have on your server? We had between 1700 and 1900 (the number varies) at times when the error occured. We are now at 1500, and have not had the error in the 2 days since reducing the number of databases... |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-23 : 13:30:19
|
| Step 1: Revoke dbcreator from all logins, except the administrator.Gads! How do you keep the backup lists up to date? |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-02-23 : 14:02:49
|
| I have run 64 instances on a single box. 4gb ram and 2cpus attached to a DMX SAN. Each instance could have about 20-30 Databases, which were not required to be backed up. Not all of these dbs were full sized(100GB or more) some would be only 500MB or 50MB...Hope this helps. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
|
|
sgoodwi3
Starting Member
6 Posts |
Posted - 2007-02-23 : 17:15:01
|
| Thanks for everyones comments. It turns out we were running out of memory in the visible region (MemToLeave). In short the amount of space allocated to this region of memory on Win32 is limited (~1.2GB/instance). Having a very large number of active databases (1500 to 2000) consumed the majority of this memory, leaving to little to support larger multi-page allocations that we periodically are encounter (large plan optimization, backup, etc). The quick fix is to distribute the databases over multiple instance and or servers. The ideal solution is to migrate to 64 bit where this are of memory is limited only by the physical memory limitations of the server. |
|
|
|
|
|
|
|
|
Large Number of Databases on 2005