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 views in a custom view?

Hello, I am trying to build a custom view for our SQL databases and I am trying to pull some of the views out of the AppInsight view into a custom view for more of a top 10 or top 50 for all database instances instead of individual instances. Does anyone know how to pull the multiple views into one page with left navigation, or even under the databases tab? I am looking for most expensive queries, which I can get with a custom table, but I would like to have the ability to collapse the query in the table like you can in the AppInsight view. What I cannot find is dead locks, or fragmented tables or so on.

Thanks

Find more posts tagged with

Accepted answers

All comments

aLTeReGo

Have you tried creating a new custom summary view and using the Custom Object Resource to add the necessary information to the view?

kk19115

You have to do this manually by adding Custom Object Resource objects and selecting 'AppInsight for SQL: Applications' as the object type. When you edit this and click 'select object', you'll see the different AppInsight for SQL applications you currently have in your environment. After you have one selected, you'll get a drop down for all the different object resources available (only select one application at a time or the drop-down will be limited). What I did was have one window open with the AppInsight application so I could see the various resources and layout then manually recreated it in the custom view using a bunch of copied and edited Custom Object Resource objects.