How much RAM Required for 2.5 GB of SQL Server 2000 EE database.

Hi,
I have one server with OS Windows 2003 Enterprise edition, SQL Server
2000 Enterprise Edition and 512 MB RAM. The database size is 2.5 GB.
Currently i am faceing performance issue. I want to know that this
issue is due to low RAM or due to any other factor.
Should i increase the RAM.
Is there any matrix of Memory Required for SQL Server based on Database
size.
Please give me reply.
Thanks & Regards,
Sajid C.Hi
Does the OS have 512 MB RAM? Are you serious?
<csajid@.gmail.com> wrote in message
news:1156245366.871169.255540@.m79g2000cwm.googlegroups.com...
> Hi,
> I have one server with OS Windows 2003 Enterprise edition, SQL Server
> 2000 Enterprise Edition and 512 MB RAM. The database size is 2.5 GB.
> Currently i am faceing performance issue. I want to know that this
> issue is due to low RAM or due to any other factor.
> Should i increase the RAM.
> Is there any matrix of Memory Required for SQL Server based on Database
> size.
>
> Please give me reply.
> Thanks & Regards,
> Sajid C.
>|||It has very little to do with the database size and more to do with the
queries that you run.
As you probably realize 512M is way too little, I would say that if this is
a dedicated SQL Server you should have at least 2G, if you run other thing
son the server (IIS, Exchange, ...) you should have 3G or more.
But it all depends, there is no magical limit, the more memory the better
for performance, however more than 4G is more or less pointless on 32 bit
systems (although there are somewhat buggy ways to exceed the limit).
KL.
<csajid@.gmail.com> skrev i meddelandet
news:1156245366.871169.255540@.m79g2000cwm.googlegroups.com...
> Hi,
> I have one server with OS Windows 2003 Enterprise edition, SQL Server
> 2000 Enterprise Edition and 512 MB RAM. The database size is 2.5 GB.
> Currently i am faceing performance issue. I want to know that this
> issue is due to low RAM or due to any other factor.
> Should i increase the RAM.
> Is there any matrix of Memory Required for SQL Server based on Database
> size.
>
> Please give me reply.
> Thanks & Regards,
> Sajid C.
>|||Hi All,
Thanks U All for ur reply.
Thanks & Regards,
Sajid C.
KL wrote:
> It has very little to do with the database size and more to do with the
> queries that you run.
> As you probably realize 512M is way too little, I would say that if this is
> a dedicated SQL Server you should have at least 2G, if you run other thing
> son the server (IIS, Exchange, ...) you should have 3G or more.
> But it all depends, there is no magical limit, the more memory the better
> for performance, however more than 4G is more or less pointless on 32 bit
> systems (although there are somewhat buggy ways to exceed the limit).
> KL.
>
> <csajid@.gmail.com> skrev i meddelandet
> news:1156245366.871169.255540@.m79g2000cwm.googlegroups.com...
> > Hi,
> >
> > I have one server with OS Windows 2003 Enterprise edition, SQL Server
> > 2000 Enterprise Edition and 512 MB RAM. The database size is 2.5 GB.
> >
> > Currently i am faceing performance issue. I want to know that this
> > issue is due to low RAM or due to any other factor.
> >
> > Should i increase the RAM.
> >
> > Is there any matrix of Memory Required for SQL Server based on Database
> > size.
> >
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid C.
> >