nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

AppInsight for SQL - Select specific databases.

masonstryker

Currently when you apply AppInsight for SQL, all databases, including default databases like MSDB, model, etc are selected. We would like to be able to select which databases we monitor.

Find more posts tagged with

appinsight_for_sql

Status: None

Comments

aLTeReGo

This is already possible today, albit it in reverse. Once AppInsight for SQL is applied, simply unmanage the Databases you don't wish to monitor. This will remove any status and prevent them from alerting.

masonstryker

I thought I looked this over in detail before posting this but I didn't see where I could unmanage specific databases. Can you point me in the right direction please?

aLTeReGo

It's located on the Database Details view for each database

Unmanage Database.png

izzy_g

I know this issue was resolved over 8 months ago, but I just installed SAM 6.2 and imported the AppInsight for SQL on my SQL server. Unfortunately I cannot, for the life of me, find where to unmanage the databases. I've been looking for the "Database Details" view as you listed above but I don't know where to find it.

aLTeReGo

Click on the name of the Database from the "All Databases" resource located on the AppInsight for SQL Application Details view as shown below.

http://oriondemo.solarwinds.com/Orion/APM/SqlBlackBox/SqlBlackBoxApplicationDetails.aspx?NetObject=ABSA:115

All Databases.png

izzy_g

Thanks for the quick response. I feel a lot better with your response, because that was exactly what I was doing. The issue for me to now troubleshoot is whyI am receiving this error for the majority of my databases. Thanks.

aLTeReGo

Looks like this may be an issue with the settings for your user account that is outlined in the following KB article.

SolarWinds Knowledge Base :: AppInsight for SQL: 401 Error

izzy_g

Perfect workaround! That resolved the issue immediately and gave me access to the databases and metrics! Thanks for help and support on this; you have been a life saver!

afetters13

When I try and unmanage a specific SQL performance counter it in turn unmanges all of the performance counters in there a way to only unmanage one?

ctn app.png

ctn 2.png

aLTeReGo

It is not possible to unmanage a specific component in SAM. You can however remove the warning and critical thresholds so they do not alert. That should provide the desired result.

cfizz34

All I ever see which this module is a sea of errors and warnings even for servers that have ZERO databases running or 10 databases running. I can't depend on the status since it always "thinks" something is wrong.