Last post May 14, 2015 05:06 AM by saffy
May 06, 2015 07:08 AM|saffy|LINK
We have a query that running millions of times in MS SQL, and its very small query.
How can we find from which server/service its fired.
May 06, 2015 09:07 AM|bbcompent1|LINK
I think your only recourse at this point would be to turn on SQL Server Trace and keep an eye on your logs. Here is an article to explain how to turn tracing on in SQL Server.
May 07, 2015 01:28 AM|saffy|LINK
Thank you for your suggestion.
Will check and update.
May 14, 2015 05:06 AM|saffy|LINK
bbcompent1, it works.