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

What service do I stop to release SQL?

SQL databases cannot be detached unless there are no active queries/transactions/locks. We have seen on our SQL servers that we query for information with ORION APM that the database remains "locked" and we cannot detach it until we stop the APM services. However I'm trying to find out which services to stop temporarily while we do this. I don't want to go the route of going into every template with a SQL query and disabling each SQL component/monitor. That would take far too long and we'd rather have the necessary service down temporarily than delay the time it takes to disable each one.

Thanks.

Find more posts tagged with

Accepted answers

All comments

martin.susil

APM might not close connection to SQL server as it uses connection polling (it will reuse the connection during next poll). I've entered this to our internal tracking system so it will be considered for fixing in a future release.

It would be JobEngine 2 service you are looking for.

MrSampsonite

Thanks. Is that different than a feature request? Is this more of a "bug" issue?

macnugetz

More of a bug, although that doesn't matter. The important thing is it should be fixed in the next release.

-Craig