How to optimize query if database become bottleneck
Maybe attend this class?
https://thwack.solarwinds.com/discussion/151779/tired-of-the-sql-tuning-race-let-s-talk-query-optimization-on-march-10
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.
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
identify the slow queries,analyze their execution plans, and apply specific optimization techniques such as proper indexing, query rewriting, and effective database design
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices.pollerCisco ASR Devices
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
