August 1, 2013 at 12:21 pm
Hi everyone
Was wonder if anyone encountered this issue querying sys.dm_exec_procedure_stats before.
A user queried the sys.dm_exec_procedure_stats view and caused a system wide WRITELOG wait.
We killed the query and is ended up still stuck in a Rollback for about 4 hours now.
Any ideas on how to resolve this issue?
_________________________________________________________________
User "I need more space"
BOFH "Well, why not move to Texas?"
The reason I love IT
August 1, 2013 at 12:25 pm
Report it to Microsoft, sounds like a bug to me. Schedule a graceful server reboot.
The probability of survival is inversely proportional to the angle of arrival.
August 1, 2013 at 12:50 pm
Was that the only object in the query? How long was the query running before you killed it?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 1, 2013 at 1:02 pm
The query was :
"SELECT * from sys.dm_exec_procedure_stats where plan_handle = 0x05001400C4176E3B40819447060000000000000000000000"
It was running for 2 hours when they killed the process and it has been rolling back ever since.
_________________________________________________________________
User "I need more space"
BOFH "Well, why not move to Texas?"
The reason I love IT
August 1, 2013 at 1:05 pm
What is your service pack level?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 1, 2013 at 1:07 pm
SQL Server R2, service pack 2
_________________________________________________________________
User "I need more space"
BOFH "Well, why not move to Texas?"
The reason I love IT
August 1, 2013 at 1:09 pm
No blocking on that query while it was running (it being blocked)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 1, 2013 at 2:02 pm
None what so ever, did find this though http://support.microsoft.com/kb/2803799
Does not seem like good news
Thanks for the reply guys. Appreciate it
_________________________________________________________________
User "I need more space"
BOFH "Well, why not move to Texas?"
The reason I love IT
August 1, 2013 at 4:01 pm
That is intriguing. Good find. At least it may be fixed in the CU.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply