64gb memory - recommendations, etc..

19 Oct 2006 5:20 AM

SQLCatz

Multi proc server with 64gb memory.
Applications that use SQL Server 2000 & 2005 run on this system.
Can someone point me to a site / document / any material that has
information about best practices, recommendations, etc about configuring SQL
Server to use this much of memory ?

Cheers
sqlcatz

19 Oct 2006 5:36 AM

Arnie Rowland

Here are some items that you can use to shed light on the issues with large
memory.

Configuration -Memory, Large Memory Support Is Available in Windows 2000
(AWE)
http://www.support.microsoft.com/?id=283037

Configuration -Memory, SQL Server 7 & 2000 memory usage
http://www.support.microsoft.com/?id=321363

Configuration -Memory, SQL Server Memory
http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

Configuration -Memory, SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750/

Configuration -Memory, Using AWE Memory
http://www.sql-server-performance.com/awe_memory.asp

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quoteHide quote

"SQLCatz" <SQLC***@discussions.microsoft.com> wrote in message
news:F7C8E4BB-39A2-4898-88B3-AC0BEA469E19@microsoft.com...
> Multi proc server with 64gb memory.
> Applications that use SQL Server 2000 & 2005 run on this system.
> Can someone point me to a site / document / any material that has
> information about best practices, recommendations, etc about configuring
> SQL
> Server to use this much of memory ?
>
> Cheers
> sqlcatz
>

Thread options