Cumulative waitstats per session/query
We were troubleshooting a long running batch job when we suddenly realized that there is no easy way to get wait information for a specific session or query. With the rich information already available to us in SQL Server 2005 this might be a great addition to the product.
I decided to launch a suggestion on Microsoft Connect. This great
initiative makes it possible for everyone to give suggestions to improve Microsoft's products.
Check out my suggestion here (and while you are there do vote
)