|
by Wayne Walter Berry via SQL Azure Team Blog on 8/13/2010 4:02:11 PM
Slow or long-running queries can contribute to excessive resource consumption and be the consequence of blocked queries; in other words poor performance. The concept of blocking is not different on SQL Azure then on SQL Server. Blocking is an unavoidable characteristic of any relational database management system with lock-based concurrency. The query below will display the top ten running queries that have the longest total elapsed time and are blocking other queries. SELECT TOP 10 r.session
... [ read more ]
|
