Re: 8 GB of RAM installed
From: Martin Ha (martin.ha_at_gmx.net)
Date: 08/03/04
- Next message: Uri Dimant: "Re: MSSQL Backup fails! Please Help!"
- Previous message: Steen Persson: "Need some knowledge about indexes"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 03 Aug 2004 10:50:11 +0200
Serverdba wrote:
> SQL Server 2000 Enterprise Edition machine running Windows 2000 Advanced Server. The server has 8 GB of RAM installed but for some reason SQL Server is only utilizing less than 4 GB. What would the likely cause be?
Hi,
The Account which starts the SQL Service must have the privilege "lock
pages in memory" - you can set this in the local policy settings
- Next message: Uri Dimant: "Re: MSSQL Backup fails! Please Help!"
- Previous message: Steen Persson: "Need some knowledge about indexes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
