How to optimize query if database become bottleneck
identify the slow queries,analyze their execution plans, and apply specific optimization techniques such as proper indexing, query rewriting, and effective database design
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
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.
Maybe attend this class?
https://thwack.solarwinds.com/discussion/151779/tired-of-the-sql-tuning-race-let-s-talk-query-optimization-on-march-10
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)…
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches
