Wednesday, August 11, 2010

Take advantage of over 4 GB's memory in MS Sql server 2000

So you are having performance issues in MS SQL 2000? SQL server is sluggish and you have 6 GB's or more of memory.What could be the problem? Your tables all have indexes and databases are not set to auto shrink.

This sounds like you need AWE enabled. AWE
Launch Enterprise Administrator and run. this example is for 6 GB's
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
this command works for 32 bit only it does not work for 64 bit

No comments:

Post a Comment