Performance problem

As of yesterday there have been strange performance problems with SQL Server
2000. I'm hoping someone will know the best way of figuring out where the
problem is coming from.
The problem is this, certain things are taking forever on the SQL Server.
For example, reading the sysindex is taking a second or more, changing an
index on a table with 450 rows is taking a long time (been 4 minutes and am
still waiting). SQL Profiler shows that dropping the current index took
over 1 second. The table consists of two int columns, 1 varchar, and one
datetime. Returning all rows within that table takes 5 seconds through the
Enterprise Manager. Again, there are only 450 rows.
Everything was working fine and fast up until yesterday. I rebooted the
server but it didn't fix the problem. I'm defragging now, but have little
hope that that will fix it since the performance hit was huge when it
happened.
Anyone know what may have caused this or any tips on fixing it? It's a
major problem since this is a production server. Things that used to take a
few milliseconds now take several seconds and even minutes.Greg
Cold it be possible that you experience some HW problems? Maybe you have
many retries when doing disk IO?
Or, just to check - are you using SP3a? Maybe is worth checking if you are
experiencing soe DOSattack (Slammer)?
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Greg" <nospam@.nospam.com> wrote in message
news:OZmS3IxDEHA.2768@.tk2msftngp13.phx.gbl...
> As of yesterday there have been strange performance problems with SQL
Server
> 2000. I'm hoping someone will know the best way of figuring out where the
> problem is coming from.
> The problem is this, certain things are taking forever on the SQL Server.
> For example, reading the sysindex is taking a second or more, changing an
> index on a table with 450 rows is taking a long time (been 4 minutes and
am
> still waiting). SQL Profiler shows that dropping the current index took
> over 1 second. The table consists of two int columns, 1 varchar, and one
> datetime. Returning all rows within that table takes 5 seconds through
the
> Enterprise Manager. Again, there are only 450 rows.
> Everything was working fine and fast up until yesterday. I rebooted the
> server but it didn't fix the problem. I'm defragging now, but have little
> hope that that will fix it since the performance hit was huge when it
> happened.
> Anyone know what may have caused this or any tips on fixing it? It's a
> major problem since this is a production server. Things that used to take
a
> few milliseconds now take several seconds and even minutes.
>|||Perhaps someone has installed Anti Virus Software on your SQL Server and
it's scanning like a Banshee...
?
Greg Jackson
PDX, Oregon|||"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eoITZPzDEHA.2308@.tk2msftngp13.phx.gbl...
> Greg
> Cold it be possible that you experience some HW problems? Maybe you have
> many retries when doing disk IO?
> Or, just to check - are you using SP3a? Maybe is worth checking if you are
> experiencing soe DOSattack (Slammer)?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
Thanks for the reply. There didn't seem to be any disk problems when I
defragged. I thought about this as well, but haven't checked for problems
yet.
Already using SP3a and checked for DOS attacks.|||"Jaxon" <GregoryAJacksonN0SPAM@.hotmail.com> wrote in message
news:OMg2Jc2DEHA.2576@.TK2MSFTNGP11.phx.gbl...
> Perhaps someone has installed Anti Virus Software on your SQL Server and
> it's scanning like a Banshee...
> ?
>
> Greg Jackson
> PDX, Oregon
>
Unfortunately, nothing was using up the CPU. I did figure out the problem.
When I disabled a third-party stats program that uses the SQL Server the
speed went back to normal.