Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Hanging Ignite process on SQL Server for long time!

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

Find more posts tagged with

Accepted answers

All comments

mandevil

Hany, do you mind opening a support ticket on this one?

You can access support via your customer portal. Thanks!

FormerMember

Thank you, already did, but I managed to fix the issue by restarting the SQL Server service and the hanging sessions were released without the need to reboot the whole server.

rlhuston02

hany.helmy : will try your solution. Thanks for posting.