3 Replies Latest reply on Feb 27, 2017 2:34 PM by Rob Huston

    Hanging Ignite process on SQL Server for long time!

    hany helmy

      Hi all,

       

      I have this issue: Monitor for database [<>] failed to start due to [max allowed monitored database sessions exceeded: 11 > 10]. Will attempt to retry every [60] seconds...


      I already tried to kill the Ignite sessions from SQL Server, it`s hanging, rollback & waiting on MSQL_XP wait type for a long period of time.


      I guess this becuse you are using extended stored procedures in your code, now what is the solution for this as there is nothing I can do from within T-SQL or SQL Server to alleviate these proc calls; the wait is completely dependent on the external process.


      Please Help.

      Thanx.

      Hany