What is the best way to get Locking information during a period of time? For example, I want to create a log file/ table of all the locking issues in the database during a day (on NAV2009 R2 database on SQL Server 2008 server). Is SQL Profiler the right tool? Will it not increase the load of server significantly?
Is there any other tool for this purpose?
Looking forward for your reply.