Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: Enterprise Manager causing extensive network traffic

    Does anybody have any idea what is happening here. On 3 out of five workstations when entering Enterprise Manager the network traffic jumps drastically to the point that the server needs to be rebooted. Any information would be greatly appreciated.
    Thanks
    Newbie

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Try Using the SQL Profiler that comes with SQL Server

    This underused programme will list every command that hits the SQL Server in Real time.

    Just run the default trace & see whats happening when a client logs on

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Oct 2003
    Posts
    3
    I used profiler this morning, using the default trace and I also set it to log everything. It didn't log anything out of the ordinary, and there was nothing that coincided with the amount of traffic being generated.



    Originally posted by GWilliy
    Try Using the SQL Profiler that comes with SQL Server

    This underused programme will list every command that hits the SQL Server in Real time.

    Just run the default trace & see whats happening when a client logs on

    GW

  4. #4
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    OK

    My next step would be to download a trial version of Commview 3 - install it onto the client.

    This App is an excellent packet sniffer and will show you exactly any traffic that is happening & to which IP Address it is going to

    You could try and decipher the packets with this tool if you are brave - at very least it will show how much traffic is generated on which port to where.

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

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