Post reply

> 3000 simultaneous hits/calls to the db & ip

  • February 10, 2010 at 1:12 am

    #137135

    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

  • February 10, 2010 at 1:48 pm

    #1117183

    You can use activity monitor to findout from which SID, Host name and Database name the connections are coming from. There is no way to findout what is the IP of the Host using SSMS.

    EnjoY!

    EnjoY!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply