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 |
|
dbwilson4
Yak Posting Veteran
50 Posts |
 Posted - 2007-07-05 : 14:29:42
|
| I have 8 gigs of RAM on the machine with 3 gigs dedicated to SQL. In studio management (under memory), it says:Minimum Server memory: 0Maximum server memory: 3000MBUse AWE to allocate memory: offThe reason AWE is off is because I use Vista Ultimate 64-bit which can give ANY process more than 4gig (unlike in 32-bit where processes can only address upto 2gigs).I queried a couple of tables which contain alot of rows (11million, db size is 7gigs) but SQL is not using all of the RAM. In task manager it says, SQL is only using 138MB of RAM (even though it's given 3gigs). How do I make it use all 3 gigs? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-05 : 14:49:45
|
| Have you tried setting the min server memory to 3000MB?Are you sure the server really needs that much memory? Maybe it is possible the queries you ran were able to use indexes and didn't need to bring the whole table into memory and SQL Server only needs the amount of memory it is using.CODO ERGO SUM |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 16:32:11
|
| Did you check sql memory usage in perfmon? |
|
|
|
|
|
|
MS SQL 2005 Dev Edition not using all of RAM