my application is getting very slow performance.
Because sql server not responding properly in particular case like run some big query.
Can u any tell me how we can identify the particular query is working fine or not.
i am using sql server profiler. its shows duration of TSQL.
If we know using sql server profiler duration means
What is the maximum response duration for TSQL Query?