HardDisk very busy while access SQL db

Dear all:
I'm using IIS6 + ASP + SQL2000sp3a. And between these month, when I connect
to my website, the harddisk will very busy, so my website become very slow.
But after HD read finished, the website will work fine.
I'm using virutal server, and another website work fine because it not
access sql server. I think its DB's problem.
Is there any method to check my db? Should I defrag my db or fix it'
Thank you very much for your read and reply!Fragmentation might be contributing to the performance problem, but there
are also many other problems as well. Performance tuning is a big topic & it
would be hard to suggest any one thing as being the most likely fix for your
problem given the limited info you've given here.
You need to follow a basic performance tuning approach - check high level
system metrics such as cpu, memory, disk queues etc. Then you make further
assumptions based on your observations & perhaps perform deeper system
analysis or go to the sql server performance tuning tools - such as SQL
Profiler. You might determine that large tables are being scanned or there
are concurrency / blocking issues.
The SQL Profiler also provides an out of the box performance tuning template
which is worth looking at. Long running query filtering from Profiler can
often reveal as single or small group of problem queries.
Ultimately, you may even have a hardware resource issue.
You might find some interesting material on
http://www.sql-server-performance.com
HTH
Regards,
Greg Linwood
SQL Server MVP
"Come2" <come2@.ms76.url.com.tw> wrote in message
news:#NWpd4ExDHA.2308@.TK2MSFTNGP11.phx.gbl...
> Dear all:
> I'm using IIS6 + ASP + SQL2000sp3a. And between these month, when I
connect
> to my website, the harddisk will very busy, so my website become very
slow.
> But after HD read finished, the website will work fine.
> I'm using virutal server, and another website work fine because it not
> access sql server. I think its DB's problem.
> Is there any method to check my db? Should I defrag my db or fix it'
> Thank you very much for your read and reply!
>