Duplicated lines in SSMS 2008 R2 activity monitor - by Kedrik

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 496162 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/6/2009 8:18:46 AM
Access Restriction Public


When a SQL session is executing using a parallel plan (multiple excution contexts), the activity monitor do a cross join on these line (ie: if there are 3 execution contexts, 9 lines are displayed).
Sign in to post a comment.
Posted by Ellen2 on 10/23/2013 at 6:01 AM
That is pathetic. It is my understanding that this incorrect query is still used by the Activity Monitor in SQL Server 2012 and SQL Server 2014. It should be fixed. It is not that complex to fix this query that is used every day by thousands and thousands of SQL Server users. The Activity Monitor is a core tool for SQL Server .... it should be accurate.
Posted by Microsoft on 6/1/2011 at 7:57 AM

We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.