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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-01 : 07:44:34
|
| Ray writes "I have SQL 7 standard edition running on windows 2000 advanced server with 4 GB of ram and 4 processors. SQL Server is configured to use 2 GB (max allowed with this configuration?). But SQL SERVER only uses max of 1.7 GB; does anyone know why the other 0.3 GB is not being used?I'm getting paging but SQL server shows 0.3 GB of memory free.Thanks for any help you can offer." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-01 : 12:34:09
|
| How do you know that SQL Server needs to use the other 0.3GB? Maybe SQL Server already has what it needs. When you say that you are getting paging, is the paging occurring on sqlservr.exe or just paging in general on the box? SQL Server is designed to do very little paging if there is enough memory.Tara |
 |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-08-02 : 17:29:42
|
| SQL Server will never get to use this 0.3 because it thinks that all memory reserved for it is 2GB (the limit for processes on Windows, without using 4GT), and it will allocate all memory the system allows it to allocate for Data processing minus a fixed amount reserved for internal threads, thats sum up to - are you ready - around 0.3 GB.That's why it will never allocate all the 2GB. You can use /3GB in your boot.ini to allow processes to allocate more than 2GB of linear memory.Take a look on excellent articles by Kalen Dellaney on Memory Engine in SQL Server Magazine.Hey, Graz would be nice if we could get a discount for subscription of SQL Magazine. What do you think, Obi Kenobi?Sérgio MonteiroTrust in no Oracle |
|
|
|
|
|
|
SQL SERVER 7 memory