---
title: "Discussion on \"Increasing MS-SQL 2000 RAM\" | Hashnode"
description: "Discussion on \"Increasing MS-SQL 2000 RAM\". The MS-SQL 2000 only using 2G RAM by default. If there is a SQL server with huge RAM, than maybe we could increasing the RAM amount of SQL by open the AWE switch.\nHere is the method that open it.\n\nOpen AWE switch\n\n\nsp_configure 'show advanced options..."
url: "https://hashnode.com/posts/increasing-ms-sql-2000-ram/62be735463efe017ba655823"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Increasing MS-SQL 2000 RAM](https://yonny.yoning.com/increasing-ms-sql-2000-ram?utm_source=hashnode&utm_medium=feed)

The MS-SQL 2000 only using 2G RAM by default. If there is a SQL server with huge RAM, than maybe we could increasing the RAM amount of SQL by open the AWE switch. Here is the method that open it. Open AWE switch sp\_configure 'show advanced options...

Nov 27, 2006 · 1 min read · yonny.yoning.com  
Read the article

## Written by

[Yonny](https://hashnode.com/@Yonny)

@Yonny

  
[View profile](https://hashnode.com/@Yonny)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
