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 |
|
laserovic
Starting Member
11 Posts |
 Posted - 2007-06-23 : 12:10:22
|
| Hello,I have 2 processor server with 4GB memory. It is dedicated SQL server. Currently I have Windows 2003 standard edition and SQL 2005 standard edition. It used only about 1,7 GB for the SQL server and 300 MB for other application, task manager showed 2,0 GB of use.Then I added /3GB switch to boot.ini. After that, system shows use of about 3GB, but SQL stayed on 1,7 GB max (even I set more in properties), the only advantages was, that I could use another 1,3 GB for other applications.But I would like to give more memory to SQL server. I searched web, but I am still not sure about if it is -possible on current software or if not, -what is the cheapest way how to do that (upgrade to Windows Enterprise is of course much cheaper than to SQL 2005 Enterprise, will AWE memory help me?)P.S. I can use only 32-bit software. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-23 : 13:20:32
|
| sql server will take as much memory as it needs._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
laserovic
Starting Member
11 Posts |
Posted - 2007-06-23 : 15:16:34
|
quote:
Originally posted by spirit1
sql server will take as much memory as it needs.
I don't agree with you, I wittingly run a query using the biggest table (45 mil. rows) with order by, that should take as much as memory possible (i tried more various selects). It always stops on she same value - about 1,7 GB. Don't tell me that SQL wouln't use more memory if it would be allowed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-23 : 22:17:40
|
| What do you have in perfmon -> sqlserver:memory manager -> target server memory? |
|
|
|
laserovic
Starting Member
11 Posts |
Posted - 2007-06-25 : 03:53:17
|
quote:
Originally posted by rmiao
What do you have in perfmon -> sqlserver:memory manager -> target server memory?
I have 1619968 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-25 : 22:30:07
|
| Did you reboot server after modifying boot.ini file? Does sql service account have 'lock pages in memory' user rights on the server? |
|
|
|
laserovic
Starting Member
11 Posts |
Posted - 2007-06-26 : 04:30:12
|
quote:
Originally posted by rmiao
Did you reboot server after modifying boot.ini file? Does sql service account have 'lock pages in memory' user rights on the server?
there was parameter /userva missing. After that, I found out that if I don't check "use awe memory", SQL server always use maximum 1,7 GB, but I can use another 1 GB for other apps (in this case it is only related SQL services like IS). But if I check it, the SQL process in taskman shows about 80MBytes, but target memory in performance monitor is 2500 (I set 2500 in memory properties). |
|
|
|
|
|
|
|
|
Use more memory on 4GB server