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

Permormance Issues

Status
Not open for further replies.
qsac

qsac

Programmer
Jan 22, 2002
242
US
I am getting this on startup? Server has 4GB memory though!

Warning: unable to allocate 'min server memory' of 2955MB.
 
Sort by date Sort by votes
How much memory does windows show? What version of Windows and what version of SQL are you using?

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
SQL Server 2000 EE

Windows 2000 and it shows 3.898 GB memory
 
Upvote 0 Downvote
Have you tried changing the setting to a lower number? Try like 1 Gig? Any reason that you're forcing SQL to take 3 Gigs or Memory on startup? As time goes on the SQL Server will take all the memory that it needs up to the limit that you give it.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
158
intel233
intel233
dgillz
  • Locked
  • Question
SQL 2016 installation issues
Replies
1
Views
136
yelworcm
yelworcm
TheBugSlayer
  • Locked
  • Question
Memory issues 1
Replies
5
Views
137
yelworcm
yelworcm
grippy
  • Locked
  • Question
Remote connection issues cant Telnet to 1433
Replies
1
Views
139
gmmastros
gmmastros
katekis
  • Locked
  • Question
Security issues in SSRS 2008 R2.
Replies
0
Views
58
katekis
katekis

Part and Inventory Search

Sponsor

Back
Top