Its both curiosity and a bug. A machine with 512 MB (this is all we can
ask our customer) that has MSDE and it's database is just 26 MB takes
around 200 MB of RAM. This seems to be a problem. SQL 7.0 doesn't use
to do this.

You haven't answered my question you have simply restated the memory
usage observation. Is this actually a performance problem?

Is your application noticably slower with the 2K version of MSDE?

Are other applications running on the same machine crawling to a halt?

SQL Server will rightly take as much memory as it can but should be a
good citizen when it comes to playing nicely with other apps demands.

Malc
www.dbghost.com - Build, Compare and Synchronize = Database Change
Management for SQL Server

Bardolator (Bardolator (AT) gmail (DOT) com) writes:
Just because you don't like, does not mean that it is a bug.

Use sp_configure to constrain how much memory SQL Server may use.

exec sp_configure 'max server memory', 100
go
reconfigure

100 is 100 megabyte.

You have have to first say:

exec sp_configure 'show advanced', 1
go
reconfigure


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp