Hi
There will be around 3000 simultaneous calls. They will be coming via 10 session servers. When i ran sql profile during the testing (say with 100+ connections) i only get the sql login name but not able to figure out which server is sending these many calls. I have three questions in this regard,
1. Is sql profiler the best tool to track sessions? If not what other feature of Mgmt.Studio i can use? If not any other tool (3rd party included?).
2. I do not remember seeing provision for seeing the IP in sql profiler. How do i then identify which server the call is coming from?
3. Anyone out there has gone through such volume hits (3000 calls to the db/sec)? If so what pitfalls did you face? Any pre-active suggestions?
TIA