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
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
- Goal Oriented AI
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

Optimise query

AshuuDixit

How to optimize query if database become bottleneck

Find more posts tagged with

Comments

cnorborg

Maybe attend this class?

https://thwack.solarwinds.com/discussion/151779/tired-of-the-sql-tuning-race-let-s-talk-query-optimization-on-march-10

NVSteven

I have a large environment, if you are having query issues, it probably isn't on the SQL database unless the SQL server was built incorrectly.

Check out SWIS queries used on dashboards or in alerts. If they are complicated or too many joins, the app will have performance issues not related to SQL database.

If you are referencing databases in general, I agree with @fop that DPA would be a solution.

fop

I'm guessing you're not using HCO SaaS because database analysis is built into that. For other platforms there's DPA -

Database Performance Analyzer (DPA) | SolarWinds

AshuuDixit

identify the slow queries,analyze their execution plans, and apply specific optimization techniques such as proper indexing, query rewriting, and effective database design

Quick Links

Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-Commands
Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-CommandsExported with NCM 2023.4.2
Summary of Alerts Generated
AlertSummary.xmlHi All, I've done some work to tidy up our alert definitions (both the Alert Manager and Alert Actions) and the more important alerts have now been tailored and given a "[ *** ]" prefix so it is easy to see the alerts we have catered for versus those that might appear once in a while. I am monitoring this…
Dynamic Interface Dashboard; HTML/JS
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022