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
NewbieTry 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|||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|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment