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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-06-06 : 09:26:16
|
| Guys,How do I increase the SQL Server Instance memeory from 2GB to 4GB. The OS is 32bit with 4GB memory.Any suggestions and input would help.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-06 : 15:51:26
|
| You can't get 4 GB RAM for SQL Server then.To get 3 GB user mode, you can enable 3 GB\ Switch . |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-11 : 06:57:18
|
quote:
Originally posted by amsqlguy
Guys,How do I increase the SQL Server Instance memeory from 2GB to 4GB. The OS is 32bit with 4GB memory.Any suggestions and input would help.Thanks
Before enabling /3GB switch, chk that u dont have other application running on the server...I remember using /3GB on an application and database server..which led me to memory issues with the OS processes...Regards,Ahmad Osama |
|
|
|
|
|
|
Increase memory of SQL Instance