Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memory usage config

Status
Not open for further replies.
moolie

moolie

Programmer
May 7, 2002
193
CA
Can this be done from command line or script?

Ie. server has 2 GB of ram installed, I would like to limit sql server usage to 1 gb. Normally done from properties dialog inside sql registration.

Any thoughts?
 
Sort by date Sort by votes
Yes.
Code: 
sp_configure 'Max Server Memory', 1024
reconfigure
go
The 1024 is in Megs.

Denny

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(My very old site)
 
Upvote 0 Downvote
Thank You. This was the last piece of my puzzle for automatic configuration script. Thanks again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
643
CodeWell
CodeWell
mattmontalto
  • Locked
  • Question
SQL Server 2008 RAM Usage
Replies
2
Views
266
mattmontalto
mattmontalto
wp1
  • Locked
  • Question
Database base memory usage question!
Replies
2
Views
263
wp1
wp1
niall5098
  • Locked
  • Question
SSIS amd always on config
Replies
0
Views
159
niall5098
niall5098
disturbedone
  • Locked
  • Question
RAM memory management
Replies
6
Views
389
PghMikeH
PghMikeH

Part and Inventory Search

Sponsor

Back
Top