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 |
|
Flamasteris
Starting Member
2 Posts |
 Posted - 2005-02-14 : 04:59:25
|
| There's a 500 mb database.A server with MSSQL, 3 GB RAM.There's a limit, that SQL can use a maximum of 2,5 GB RAM.After a few hours of intense using of the database, MSSQL reaches a 1,7 GB RAM and doesn't change since then.What does MSSQL use these 1,7 GB RAM for? If there's something useful, then why the whole system slows down when the memory usage reaches that 1,7GB? The system uses 60-90% CPU and there's a great slowdown in comparinson with the system that is just started. When the memory usage reaches 1,7GB, I restart MSSQL and everything works just fine, CPU usage drops down to 30-40%, although the same processes as before restart are running. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-14 : 06:14:03
|
| Which service pack are you running with?==========================================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. |
 |
|
|
Flamasteris
Starting Member
2 Posts |
Posted - 2005-02-14 : 06:33:40
|
| Windows 2003 Server Standart EditionMSSQL 2000 Enterprise Edition Services Pack 3a |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-02-14 : 13:41:34
|
| Is that machine doing anything else besides SQL Server?Do you use a lot of Temp Tables?A 500MB database should not use that much RAM. Maybe 1GB, but not more than that I would think.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
abid1pak
Starting Member
6 Posts |
Posted - 2005-02-14 : 23:34:27
|
| Did you receive any RPC errors on machine ? Sr. DBA Developerwww.sqldba.org |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-14 : 23:53:24
|
| >> A 500MB database should not use that much RAM. Maybe 1GB, but not more than that I would think.Depends on the queries - they can be written to minimise the use of memory or not.What happens when the server isn't doing anything?Have a look at the queries that are runningthis will help in thathttp://www.mindsdoor.net/SQLAdmin/sp_nrInfo.html==========================================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. |
|
|
|
|
|
|
|
|
MSSQL and Memory