>> 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.
Thanks! Thomas ------------------------------------------------------------------------------ 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
