DelayTime

Database
Enthusiast

DelayTime

Hi,

I am wanting to know the delay time for queries, I would like to know the Submit time for a query and the time it started.

The DBQLogtbl has a column DelayTime, does anyone know the unit of measurement here? is it seconds?

Also Are there any views that contain the Time a query was submitted, rather than the time it actually started, or do I need to do some math with the Delaytime and the Time Started?

Random.
2 REPLIES
Senior Apprentice

Re: DelayTime

Please define "delay time".

The column DelayTime is only set for queries delayed by TDWM, it's in seconds.

I think you just want the difference between the StartTime (SQL arrives at the PE) and the FirstStepTime (query is optimized and the first step is sent to the AMPs).

Dieter
Enthusiast

Re: DelayTime

Dieter,

Delay time is the one I meant, We use the Workload manager and it is delaying SAS queries. I was praying that those numbers were milliseconds.

Thanks for the help.

Random.