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 |
|
heliang
Starting Member
38 Posts |
 Posted - 2008-12-17 : 21:45:02
|
| I got lots of "insufficient memory available" error recently. This database server has 4GB of memory and I can see from task manager it is only 2GB has bee usedn almost of times. I configered SQL server to use Dynamically configure SQL memory and with maximum to 4GB.Please help! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 22:19:53
|
| What edition is server and SQL Server? Is /3gb switch enabled? |
 |
|
|
heliang
Starting Member
38 Posts |
Posted - 2008-12-17 : 22:57:13
|
| I have Developer Edition. How much memory Developer Edition can use up to? Can I enable 3GB swith on Developer Edition. If so, How?Thanks! |
|
|
|
heliang
Starting Member
38 Posts |
Posted - 2008-12-18 : 00:56:38
|
| P.S this is windows 2003 enterprise server. will enable AWE helps? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-18 : 09:00:51
|
quote:
Originally posted by heliang
P.S this is windows 2003 enterprise server. will enable AWE helps?
You can /3GB switch to get 3GB for SQL Server. |
|
|
|
heliang
Starting Member
38 Posts |
Posted - 2008-12-18 : 11:54:02
|
| I currently have SQL 2000 developer Edition. I am going upgrade the server memory to be 8GB. How can I configer SQL server to use more than 3GB of memory?Thanks! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-18 : 22:49:22
|
| Then use /PAE in boot.ini file and enable AWE . Give atleast 2GB memory to OS and managing Awe. |
|
|
|
|
|
|
insufficient memory available