What is the command line command to limit SQL 2000 server to 640MB of RAM?

Question

What is the command line command to limit SQL 2000 server to 640MB of RAM? This is MSDE2000 and so I don't have access to Enterprise Manager.

squillman · Answer 1 · 2009-09-18 17:13:54Z

up vote 3 down vote accepted

Have a go at this:

EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
GO

EXEC master.dbo.sp_configure 'max server memory (MB)', 640
RECONFIGURE
GO

If you have to do this via a command line tool you can put that into a .sql file (LimitMaxMem.sql) and do this:

osql -E -S servername -i LimitMaxMem.sql

BTW- Enterprise Manager should hook up with MSDE just fine. I used to use it all the time.

answered Sep 18 '09 at 17:08

squillman
25.4k43485

	thanks. that was what I was looking for and it worked. ;-) – djangofan Sep 18 '09 at 17:21
	out of curiosity, which method did you use/work for you? exec or osql? – shufler Sep 18 '09 at 17:26
	@shufler: You're running the exact same code in either case, it's just whether or not you have a GUI interface like Query Analyzer or if you're using a command line tool like osql. With a GUI you can just type that in and execute it. With osql you can feed in the SQL from a file (or a command line parameter, but a file's much easier). – squillman Sep 18 '09 at 17:37
	i just realised now that the osql command was just taking the code from the file. thanks :) – shufler Sep 18 '09 at 19:39

feedback

1 Answer