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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memory

Status
Not open for further replies.
djj55

djj55

Programmer
Feb 6, 2006
1,761
US
Hello, 2008R2
I pulled a very bad thing this morning in that I set the 'max server memory' to 4 MB not 4 GB.

How do I set it to the desired amount now that I cannot get into the server properties. I have tried to start using sqlservr.exe -f but this gives a red circle with white X.

I hate Mondays.

Thank you,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Sort by date Sort by votes
Finally got it. Not sure how though. I did try the -g4096 (4G memory) switch.

Thanks.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wp1
  • Locked
  • Question
Database base memory usage question!
Replies
2
Views
93
wp1
wp1
disturbedone
  • Locked
  • Question
RAM memory management
Replies
6
Views
108
PghMikeH
PghMikeH
TheBugSlayer
  • Locked
  • Question
Memory issues 1
Replies
5
Views
88
yelworcm
yelworcm
VE
  • Locked
  • Question
Simple way to estimate memory for small SQL 2008 DW
Replies
1
Views
70
gmmastros
gmmastros
disturbedone
  • Locked
  • Question
SQL2008R2 memory configuration 1
Replies
6
Views
57
biglebowski
biglebowski

Part and Inventory Search

Sponsor

Back
Top