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 |
|
chowardakahitman2
Starting Member
3 Posts |
 Posted - 2012-01-09 : 11:19:19
|
| I use an agency management system that was archaically running on a windows 2003 server with SQL 2000. I've stayed on windows 2003 x86 with 4GB memory, but updated SQL to 2008. The sqlservr.exe process only uses 1.7 GB of memory during a brutal workload.... The task manager is reporting 2GB free. My question is simple--How do I make it use mo' memory?In addition, the upgrade process for the application was to restore the SQL 2000 database to the SQL 2008 server, set it to SQL 2000 Compatibility mode. Did these guys just boost me to SQL 2008 only to maintain support maintenance with M$ and lock me into SQL 2000 performance settings? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-09 : 11:31:05
|
| Compatibility is nothing to do with performance. It's to do with what T-SQL constructs are valid. A database attached to SQL 2008 is a SQL 2008 database.You're on a 32-bit OS. The max memory SQL can use on a 32-bit OS is 1.7GB, the upper 2GB is kernel-mode VAS. You can add the /3GB switch to boot.ini to allow SQL to use up to 3 GB (well, 2.7 more like)--Gail ShawSQL Server MVP |
 |
|
|
chowardakahitman2
Starting Member
3 Posts |
Posted - 2012-01-09 : 11:34:31
|
| Thanks for the quick response! I must add that I'm running on standard edition for windows 2003 32-bit. Does that negate the use of the /3GB switch? Also, I read in the Microsoft KB that adding the 3GB switch can negatively impact paging performance when used with an application like SQL. |
|
|
|
chowardakahitman2
Starting Member
3 Posts |
Posted - 2012-01-09 : 11:39:51
|
| Actually, ignore that.... Just answered my own questions. I was thinking PAE, not /3gb. Thanks. This was the answer I was looking for! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-09 : 11:48:56
|
| This link may be helpful for things you should do when migrating from SQL 2000 to SQL 2008, and has details about changing compatibility mode etc.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
|
|
|
|
|
|
SQL 2000 Database on a SQL 2008 Only using 1.7gb