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 |
|
MrBean
Starting Member
14 Posts |
 Posted - 2003-01-08 : 03:46:36
|
| I administrating a SQL Server 2000 which contains 20+ databases.Somehow the SQL Server service suddenly allocates a lot of RAM even thought the databases are not in use by any users or jobs - why ?This problem causes the server to come to an almost complete halt sometimes.... very strange !Any ideas what causes this problem ?/MrBean |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-08 : 03:57:49
|
| The server will checkpoint each of the databases in turn so the more databases the more it has to do (at least it used to do it like this) - wouldn't think it would cause what you are seeing though.Try running the profiler to see what is happenning.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MrBean
Starting Member
14 Posts |
Posted - 2003-01-08 : 07:11:01
|
| Ok thanks, I'll try to check the profiler next time the problem occures.But I just find the problem strange - does more databases require more memory even if there are no extra users or activity ?/MrBean |
|
|
|
|
|
|
Many database causes performance problems ?