September 1, 2014 at 10:55 pm
HI all,
I would like to grab the query from application server using SQL profiler ... How do i know that query come from that application server ?
Thanks
Cheers
September 2, 2014 at 12:50 am
The profiler has the columns Application Name, Login Name and Host Name. You can use them to figure out from which application, login and machine any statement came from. You can also have a filter based on those columns.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 2, 2014 at 5:02 pm
Adi Cohn-120898 (9/2/2014)
The profiler has the columns Application Name, Login Name and Host Name. You can use them to figure out from which application, login and machine any statement came from. You can also have a filter based on those columns.Adi
Thanks for your response ! Appreciate it
hmm I just run the sql profiler and I wonder there are some records that has no hostname ... but some others have it .
Any idea why ?
I am a bit suspicious the query that has no hostname comes from that application but not so sure yet
September 3, 2014 at 4:50 am
I have to admit that I don't know how come there are records that don't show the host names. Can you see the application's name and user's name for those events?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply