Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

AWE Memory

I am running  SQL server 2005 Enterprise on   a Windows 2003 Ent machine

I run the following and it works fine but then I check the running value and its still 0

sp_configure 'awe enabled', 1
RECONFIGURE
GO

How do I get it into the running value?
0
unreal400
Asked:
unreal400
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Did you restarts the sql server after you configure the AWE

sp_configure 'show advanced options', 1
RECONFIGURE
GO

sp_configure 'awe enabled', 1
RECONFIGURE
GO

restart the sql server / server
0
 
unreal400Author Commented:
didn't do it the first time but I rebooted again and then it  actually became the running value.  

Strange but seems to work now.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now