03.02.2012 14:10, Thomas Steinmaurer wrote:
>
> what's the meaning of 2 for MON$STATEMENTS.MON$STATE?

STALLED. I.e. an interval between client fetches from the open cursor. 
Priorly this state was reported as ACTIVE because the query is alive and 
running but the CPU time is not spent by the engine in this interval.


Dmitry

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to