How much memory can SQL Server 2000 std. address

How much memory can SQL Server 2000 std. address?
SQL Server 2000 std. is running on Windows 2003 server std edition.
Total memory was 1.5 GB but extra memory was added later.
How can I check how much memory is the SQL server configured to
address? Is there a dbcc command.
Any help will be appreciated.
2 GB.
You can check the "max server memory (mb)" setting using sp_configure ...
But remember that just because it is configured to use 2 GB doesn't
necessarily mean that it will do so -- it might not need that much.
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>
|||Hello,
SQL Server standard can support at a maxuimum of 2 GB RAM. If the memory is
configured to access dynamically then based on the
requuirement SQL Server will use the memory. Use task manager to see how
much memory SQLServr.EXE is using...
Thanks
Hari
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>
|||On Jun 20, 5:00 am, sql <s...@.discussions.microsoft.com> wrote:
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
> Any help will be appreciated.
SELECT * FROM sysperfinfo WHERE counter_name ='Total Server Memory
(KB)'