MS SQL Server - Real memory usage

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Real memory usage

Pablo Garateguy

2006-10-31, 12:15 am

Hi,

I'm trying to define our business continuity schema.

We have a SQL Server 2000 (Entreprise Edition) with SP4, Windows 2003
Server; an IBM Server, 2 CPU, 6 discs (2 RAID 1 + 2 RAID 0) and 4 GB of RAM.

We have another server, IBM, but with 1 disc and 2 GB of RAM (same SQL
Edition and Windows Edition).

How can I determinate if that hardware can support normal database activity,
Producción Server use 3 Gb of RAM for SQL Server (obviously SQL allocate all
memory).

¿Can I determinate how many users can work without problems?

Thanks and sorry but my pour english

--
Pablo Garateguy
MCP - Visual Basic 6
MCTS - SQL Server 2005

Sponsored Links