Re: SQL Server 2005 32 bit Standard and Windows 2003 64 bit Standard to use more RAM
- From: ISSDBEngr@xxxxxxxxx
- Date: Sat, 8 Mar 2008 11:09:29 -0800 (PST)
On Mar 6, 3:17 pm, n...@xxxxxxxxxxxxxxxxxxxx wrote:
Hello folks,
The issue I am having is
we have SQL Server 32 bit installed on Windows 2003 64 bit
server ,that has 8 cpus 2Ghz and 16GB RAM.
Windows 2003 64 bit version can support high
The issue is SQL Server is not using more then 3.7GB ram. Though I
have defined in the SQL Manager to use minmum 10GB
We have DBs in there that are huge and in constant use.
How to resolve the issue.
useing command
DBCC MEMORYSTATUS
gives
VM Reserved 3647092
VM Committed 3623200
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
Where can i fix it so, SQL server see the large memory present in the
system.
Already tried AWE option, w/o any sucess.
Any help will be greatly appreciated.
Thanks
Has the 'Lock page in memory' setting been enabled for the account tha
SQL server is running in?
Please look at http://msdn2.microsoft.com/en-us/library/ms190730.aspx
thanks
Meenal
.
- References:
- Prev by Date: Memory issues after migrating to new server and upgrading to sql 2005
- Next by Date: Re: SQL Server Setup could not connect to the database service for server configuration
- Previous by thread: SQL Server 2005 32 bit Standard and Windows 2003 64 bit Standard to use more RAM
- Next by thread: Remote Installattion
- Index(es):
Relevant Pages
|
