Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20

    Unhappy Unanswered: SQL Server Performance Issue

    We've got a clustered environment in which we run several SQL servers. However, one of the platforms, Greats Plains hangs for no reason. Is there a tool out there that we can use to determine what is causing the load ?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    If you check the Process Info under Current Activity in Em, it should at least show you who was doing what when it hung....also you could run profiler to record activity through the database.

  3. #3
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20
    Thanks - will look into it!

  4. #4
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20
    Please clarify how I do the following :-

    "..also you could run profiler to record activity through the database..."

Posting Permissions

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