My SQL Server 2000 system is pegged. Disk activity is maxed out and system is very unresponsive. Several people have database tasks running through this system and I'm pretty sure there is a single application that is the culprit and I'd like to identify which one.
Does anyone have any practical tips on using "Process Info" in Enterprise Manager? What units are CPU and Physical I/O displayed in? Why does the column sort on these fields not work as expected?
Do I just pick the process with the largest Physical I/O and assume that's the problem?Use profiler...but I'd look for a high cpu and no I/O
That would be a process stuck in a loop, or a very labor intensive in memory process (less likely)
Although I did build 1 like that once...extremeley quick compared to the I/O version...took 1/2 hour...22 hours with I/O...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment