<div>
im not that familiar with Toad <br />
but you can look at the queries in text and any of the that have (tablock) in them are locking tables <br />
<br />
here is a great article from MSDN (not a competing site) <br />
regarding locks<br />
<a href="http://msdn.microsoft.com/en-us/library/ms190345.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190345.aspx</a>
</div>


im not that familiar with Toad
but you can look at the queries in text and any of the that have (tablock) in them are locking tables

here is a great article from MSDN (not a competing site)
regarding locks
http://msdn.microsoft.com/en-us/library/ms190345.aspx [http://msdn.microsoft.com/en-us/library/ms190345.aspx]

<div>
<div class="content wysiwyg-content">
our application is developed in sql server and java.this application will be hit by concurrent users.<br />
<br />
we have written somewhat big queries in this application. sometimes tables are getting locked.we want to know during executing which query &nbsp;this table is getting locked .can we have any option in toad to see these or do we have any queries to see this infornation?
</div>
</div>


our application is developed in sql server and java.this application will be hit by concurrent users.

we have written somewhat big queries in this application. sometimes tables are getting locked.we want to know during executing which query  this table is getting locked .can we have any option in toad to see these or do we have any queries to see this infornation?

how to find on which query is taking lot of time and also table getting locked

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.