Performance Problems Sql2000 SP3 on W2003 Server

I'm running microsoft Sql for a Software called Everest FRom Icode. Two week
s
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the softwar
e
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterpris
e
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:

> I'm running microsoft Sql for a Software called Everest FRom Icode. Two we
eks
> ago was but now when I check the w2003 performance screen sometimes sql us
e
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the softw
are
> trought terminal services and the speed is bad and the performance is wors
t
> any idea.
> Thank you.
>

Performance Problems Sql2000 SP3 on W2003 Server

I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.
Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:

> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>

Performance Problems Sql2000 SP3 on W2003 Server

I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>