WAITFOR wait type

Question

WAITFOR wait type

VastSQL

SSC-Dedicated

Points: 36069
More actions
July 3, 2014 at 2:15 am

#308863

Hi Experts,
One of our main application is connecting from different node and all connection from all node is showing WAITFOR waittype. That application is not accessible at this moment and we are investigating into that,can this be the reason??
TIA
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

The WAITFOR wait type indicates that the session in question is currently running a WAITFOR DELAY or WAITFOR TIME statement.

http://msdn.microsoft.com/en-us/library/ms187331.aspx

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36069 More actions · Answer 2

Thanks Gail,

I have read that and its mentioned like someone have to manually give that. I dont think someone will call that from application.

Is there any other possibility??

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

The WAITFOR wait type means that the session is running the WAITFOR statement. Hence, if you're seeing that wait, the app is running that statement. Look through that app's code for the presence of the WAITFOR statement anywhere.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36069 More actions · Answer 4

VastSQL

SSC-Dedicated

Points: 36069

July 3, 2014 at 2:34 am

#1726709

Thanks a lot Gail.

mister.magoo SSC-Forever Points: 47068 More actions · Answer 5

Ratheesh.K.Nair (7/3/2014)
Thanks Gail,
I have read that and its mentioned like someone have to manually give that. I dont think someone will call that from application.
Is there any other possibility??

Actually, the site owners do it in one of their SQL products (Monitor, I think).

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);