We using a third party company software that talk to SQL database and retreives and inserts all the information.
When user uses this software sometimes it freezes at particular step. I need to troubleshoot it and find out why it happens.
For that I am using SQL Profiler to see what query causes this bottleneck. But how would I trace steps only for that particular software and only for particular user? I dont want to see all other information.
I am able to filter NTUserName, which I am assuming its just UserName, correct? But how can I find out what is the ApplicationName?
If I ran this query I see 13 different applications, including Microsoft Office, Report Server etc. None of them sounds lile the name of the software we use. (MGA Systems. Insurance Management System)
select distinct
program_name
from sys.dm_exec_sessions
where is_user_process = 1;
You need to know the username(s) of the people using the app. Then, where you are, you enter their username in
NTUsername > Like > [User Name without the domain if they are on the same network]
for windows AD connection strings, or the same steps forusername
instead ofntsurename
if it is a sqlserver user. You can then filter their queries coming in.