Processor@50+ %

Hi, I have SQL server 2000 at my office used by our management software and
sometimes when we do certain operations like an update, or delete over some
of tables, some with 50.000+ records the server processor goes up to 50+ %
for a considerable amont of time... causing the application to hang for some
time. The database has 1.5GBs in size +/- the server is a HP Compaq Proliant
with a Xeon 2.0 and it had 1GB of ram, and I just installed + 1GB to see if
it helped, but I had the exact same result, so it's not memory lack. SQL's
version is 8.00.194.
Do you think that this problem might have been resolved with SP3/4 ?
Do you think it will help to install these?there is at least one remote exploit for SP2, so IMHO u really should apply
SP4
i had similar problem not long ago - the solution was changing the AV on
that server ^_^
"Márcio Santos" <MrcioSantos@.discussions.microsoft.com> wrote in message
news:8DB469E6-9E40-4046-AE08-C82E81D0A647@.microsoft.com...
> Hi, I have SQL server 2000 at my office used by our management software
> and
> sometimes when we do certain operations like an update, or delete over
> some
> of tables, some with 50.000+ records the server processor goes up to 50+ %
> for a considerable amont of time... causing the application to hang for
> some
> time. The database has 1.5GBs in size +/- the server is a HP Compaq
> Proliant
> with a Xeon 2.0 and it had 1GB of ram, and I just installed + 1GB to see
> if
> it helped, but I had the exact same result, so it's not memory lack. SQL's
> version is 8.00.194.
> Do you think that this problem might have been resolved with SP3/4 ?
> Do you think it will help to install these?|||AV like in Anti-Virus '
I have Symantec Antivirus Corporate Ed. v. 9.0.0.338.
"Coldman" wrote:
> there is at least one remote exploit for SP2, so IMHO u really should apply
> SP4
> i had similar problem not long ago - the solution was changing the AV on
> that server ^_^
> "Márcio Santos" <MrcioSantos@.discussions.microsoft.com> wrote in message
> news:8DB469E6-9E40-4046-AE08-C82E81D0A647@.microsoft.com...
> > Hi, I have SQL server 2000 at my office used by our management software
> > and
> > sometimes when we do certain operations like an update, or delete over
> > some
> > of tables, some with 50.000+ records the server processor goes up to 50+ %
> > for a considerable amont of time... causing the application to hang for
> > some
> > time. The database has 1.5GBs in size +/- the server is a HP Compaq
> > Proliant
> > with a Xeon 2.0 and it had 1GB of ram, and I just installed + 1GB to see
> > if
> > it helped, but I had the exact same result, so it's not memory lack. SQL's
> > version is 8.00.194.
> >
> > Do you think that this problem might have been resolved with SP3/4 ?
> > Do you think it will help to install these?
>
>|||Hi,
Are u using simple insert and delete statement or u use hetogenious
queries.
Else i can suggest to check ur code.
hope this help u
from
killer|||Well, the code wasn't written by me, but SQL Profiler says on EventClass
column: "SQL: Batch completed". I'm not sure if this answers your question,
but...
thx
"doller" wrote:
> Hi,
>
> Are u using simple insert and delete statement or u use hetogenious
> queries.
> Else i can suggest to check ur code.
> hope this help u
> from
> killer
>|||Márcio Santos wrote:
> Hi, I have SQL server 2000 at my office used by our management
> software and sometimes when we do certain operations like an update,
> or delete over some of tables, some with 50.000+ records the server
> processor goes up to 50+ % for a considerable amont of time...
> causing the application to hang for some time. The database has
> 1.5GBs in size +/- the server is a HP Compaq Proliant with a Xeon 2.0
> and it had 1GB of ram, and I just installed + 1GB to see if it
> helped, but I had the exact same result, so it's not memory lack.
> SQL's version is 8.00.194.
> Do you think that this problem might have been resolved with SP3/4 ?
> Do you think it will help to install these?
50% utilization is nothing to worry about unless it's accompanied by
poorly performing queries. Check those updates to make sure they are
optimized. Sounds like you are running into table scan / clustered index
scan operations. If that's the case, there is a lot of blocking going on
and that's the reason for the application slow-down, not the cpu issue.
Also, you appear to be running the RTM release of SQL Server 2000 from 5
years ago which is quite buggy. Any reason you have chosen to not
install any service packs? You should install SP3 or SP4.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Márcio Santos (MrcioSantos@.discussions.microsoft.com) writes:
> SQL's version is 8.00.194.
> Do you think that this problem might have been resolved with SP3/4 ?
> Do you think it will help to install these?
From your description, I would not expect SP3/SP4 to solve your urgent
problems, but nevettheless, I strongly recommend that you install at least
SP3, preferrably SP4.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.aspsql