Tracing with SQL Profiler

Question

HI Experts , I need a small help .

I have a Database D  ,only one table T1 , some how when an application is  inserting/updating/selecting  data from this T1 table , application gets hanged up and we dont see data here for that time . and there are not more than 10 users and every one uses WITH(NOLOCK) while selecting ..here I have to find out when and what statements causing this issue ..

I ran profiler previously but i gather more data than required , is the standard one give good info for my issue?? with SP, T-SQL batrch , Sessions ,audit, can any one suggest me what  exact column should i use to create my own trace so that i can solve my issue

Thanks

Answer 1

HI Experts , I need a small help .

I have a Database D  ,only one table T1 , some how when an application is  inserting/updating/selecting  data from this T1 table , application gets hanged up and we dont see data here for that time . and there are not more than 10 users and every one uses WITH(NOLOCK) while selecting ..here I have to find out when and what statements causing this issue ..

I ran profiler previously but i gather more data than required , is the standard one give good info for my issue?? with SP, T-SQL batrch , Sessions ,audit, can any one suggest me what  exact column should i use to create my own trace so that i can solve my issue

Thanks

Answer 2

Hi,

You might want to try to follow this post on using profiler for troubleshooting blocking http://www.simple-talk.com/sql/sql-tools/how-to-identify-blocking-problems-with-sql-profiler/ or you could also try the SQL Blocked Process Monitor from Codeplex - http://sqlblockedprocessmon.codeplex.com/

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 3

Please try to run the profiler with following options and check ,if this can help you out.

TSQL
Transaction
Stored Procedure
Sessions
Security Audit
Performance
OLEDB
LOCKS and don't forget to choose the deadlock Graph option

---

Please click "Propose As Answer" if a post solves your problem. OR "Vote As Helpful" if a post has been useful to you. Thanks, Debasish Mohanty Blog:http://sqlcodebank.blogspot.com