I'm seeing high wait times on my SQL queries; what are some common causes and fixes?
Another tool to look at is DPA - you can run it on a trial basis to get information on that SQL instance. This is a bit of a heavy hitter, but if you are unable to find answers elsewhere, this one can often help.
If you have SAM as part of your environment, it has several templates that can assist with finding information about your SQL server and its performance.
Database Performance Analyzer (DPA) | SolarWinds
Server & Application Monitor – Observability Self-Hosted | SolarWinds and Microsoft SQL Server monitoring.
The Microsoft forums are full of tips. But here are some additional ones from thwack and other sql sites. The usefulness will vary depending on your access to the system and comfort level running some of the queries.
15 SQL Server Performance Counters to Monitor in 2022 - Newsroom - SQL Sentry - THWACK
How Query Execution Plans Work - Data Driven Blog - Data Driven - THWACK
How to Reduce Latency and Boost SQL Server Performance - Newsroom - SQL Sentry - THWACK
Get Detailed Wait Stats with SQL Server Execution Plan
Troubleshooting using Wait Stats in SQL Server
SQL Server, Wait Statistics object - SQL Server | Microsoft Learn
Submit Orion Insights review. solarwindscore.my.site.com/.../Orion-Insights-for-environmental-review
Hi there,
We have had issues and it turned out to be high index fragmentation. We have a huge inventory so this was very impactful. This may not apply to you however, if you are running on a new DB. This can be resolved by defragging the indexes. Depending on the SQL server version you can do that without even bringing the table out of action.
Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-CommandsExported with NCM 2023.4.2
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…
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.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
