Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: Performance Monitoring?

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •