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!
>

Hackers or worm worries

I have IIS5.1 installed on my PC to run my personal website. I use ZoneAlarm
pro. The problem is that on my internet meter, I see a steady use of
downloading (6kb/s) and uploading (2kb/s) since maybe 24 hours or so. When I
block internet access with ZA, internet access is stopped for a while then
restart within minutes or hour.
Is there a program that can monitor live my internet access (cable-modem)
and tell me what program is sucking my bandwidth ? Something like a Task
Manager but for internet access ?
Note : I ran Ad-aware Se and except for cookies, it found nothing. NAV2004
found nothing either. (both uptodate ref files)
tiaRun netstat to see what connections are from and to your computer.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Junkyard Engineer" <jackeric@.engineer.com> wrote in message
news:e2QLos61EHA.3616@.TK2MSFTNGP11.phx.gbl...
> I have IIS5.1 installed on my PC to run my personal website. I use
ZoneAlarm
> pro. The problem is that on my internet meter, I see a steady use of
> downloading (6kb/s) and uploading (2kb/s) since maybe 24 hours or so. When
I
> block internet access with ZA, internet access is stopped for a while then
> restart within minutes or hour.
> Is there a program that can monitor live my internet access (cable-modem)
> and tell me what program is sucking my bandwidth ? Something like a Task
> Manager but for internet access ?
> Note : I ran Ad-aware Se and except for cookies, it found nothing. NAV2004
> found nothing either. (both uptodate ref files)
> tia
>|||Why not try a google search for "Ethereal"?
"Junkyard Engineer" <jackeric@.engineer.com> wrote in message
news:e2QLos61EHA.3616@.TK2MSFTNGP11.phx.gbl...
> I have IIS5.1 installed on my PC to run my personal website. I use
ZoneAlarm
> pro. The problem is that on my internet meter, I see a steady use of
> downloading (6kb/s) and uploading (2kb/s) since maybe 24 hours or so. When
I
> block internet access with ZA, internet access is stopped for a while then
> restart within minutes or hour.
> Is there a program that can monitor live my internet access (cable-modem)
> and tell me what program is sucking my bandwidth ? Something like a Task
> Manager but for internet access ?
> Note : I ran Ad-aware Se and except for cookies, it found nothing. NAV2004
> found nothing either. (both uptodate ref files)
> tia
>|||hummm... interesting... a nice complement to netlimiter !
thanks
"The Poster" <nospam@.nospam_dontyoudare.net> a crit dans le message de
news: ufGlppR2EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Why not try a google search for "Ethereal"?
> "Junkyard Engineer" <jackeric@.engineer.com> wrote in message
> news:e2QLos61EHA.3616@.TK2MSFTNGP11.phx.gbl...
> ZoneAlarm
> I
>|||Yes I would use a network sniffer like Ethereal or netmon. This way you can
view what packets of data are leaving your box and where they are going.
However there is a big learning curve as far as making sense of what you are
seeing.
Another good set of tools I would recommend is TCPView and TDIMon from
www.sysinternals.com. You can get a high level view of what is going on
with these. For example, you can see what process on your machine is
sending the packets, this is often good information.
Matt
"Junkyard Engineer" <jackeric@.engineer.com> wrote in message
news:%2323shgV2EHA.3908@.TK2MSFTNGP12.phx.gbl...
> hummm... interesting... a nice complement to netlimiter !
> thanks
> "The Poster" <nospam@.nospam_dontyoudare.net> a crit dans le message de
> news: ufGlppR2EHA.3336@.TK2MSFTNGP11.phx.gbl...
>