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 |
|
Jhouston132
Starting Member
11 Posts |
 Posted - 2009-09-10 : 11:44:37
|
| Hi. I've just upgraded from 2000 to 2008 on a test machine. On our production site, we run SQL Server 2000 consuming an average of 1.4G of memory. On the machine we just upgraded to, where there's no traffic running SQL Server 2008, it's consuming 4GB. All that has been ran after a fresh installation and migration of the database, are SQL jobs that backup databases. Right now there's no queries running or jobs. Any thoughts why 2008 consumes more memory when there's queries running on it? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-10 : 11:51:06
|
| Did you set the max/min memory configuration? Or is it still on dynamic (default)?Is it 64-bit?What is the physical memory of the server? |
 |
|
|
Jhouston132
Starting Member
11 Posts |
Posted - 2009-09-10 : 12:08:40
|
| On this new server (SQL Server 2008), all settings are default. It's SQL Server 2008 64 bit (Windows Server 2008 64 Bit) and there's 16GB of physical memory. Any help would be awesome. Thanks! |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2009-09-10 : 17:05:09
|
| Any thoughts why 2008 consumes more memory when there's queries running on it?The reason is because it can. That is the best thing about 64 bit OS.As per YellowBugRight click the connected database engine in SSMS (SQL SERVER Management Studio) properties -> memory"it's definitely useless and maybe harmful". |
|
|
|
|
|
|
SQL Server 2008 Consuming Too Much Memory?