Blocking means that one query (Query1) is locking resources that another query (Query2) is waiting to use. Blocking can seriously affect response time and throughput. Response time measures how long it takes for a user who issues a query to get a...
New features extend SQL Server's performance & scalability...