November 9, 2015 at 9:50 am
I know this is a very common question, i read different blogs and tried there scripts but none of them worked for me. I have a extended stored procedure by 3rd party back up solution, when i execute that i want to know what is the query waiting on. Is it because it is extended stored procedure i can't see it in the cache?
November 9, 2015 at 10:39 am
Have you tried Adam Machanic's sp_WhoIsActive? I know it does a great job of showing what a query is waiting on. I haven't experienced your exact situation, but I would think it would show any waits for that query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 9, 2015 at 11:05 am
Extended stored procs don't typically show useful wait info, because as soon as the extended proc starts to run, it's outside of the SQL scheduler control. You'll probably see a PREEMPTIVE* wait, that's the scheduler saying that the code is running outside of SQL's scheduling system and that it'll be done when it's done.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 9, 2015 at 8:04 pm
GilaMonster (11/9/2015)
Extended stored procs don't typically show useful wait info, because as soon as the extended proc starts to run, it's outside of the SQL scheduler control. You'll probably see a PREEMPTIVE* wait, that's the scheduler saying that the code is running outside of SQL's scheduling system and that it'll be done when it's done.
That sounds right. May be perfmon will show something?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply