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 |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2003-09-30 : 00:58:15
|
| Hi orlNeed to maintain an amount of free memory for other applications. I assume the way to do this is by setting the max server memory option. The reason I need to do this is because SQL Server takes too long to free the memory required for the other application. (You can probably tell by now I'm not much of an "admin" type)...I know how to do this from enterprise manager, but on this box I'm restricted to osql from the command line.After looking at BOL, I tried using exec sp_configure 'max server memory', 40000000but I get an error saying that 'max server memory' option doesn't exist or is an advanced optionDoes this mean I can't set this if I'm using MSDE - or is it just that I'm plain dumb and haven't got the sp_configure option right?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-30 : 09:29:25
|
| Set the show advanced optios to 1. EXEC sp_configure 'show advanced option', '1'You can't change advanced options without doing this first.==========================================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. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-09-30 : 19:34:36
|
| Thanks nige - always the champ!--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
max server memory on MSDE