Get the latest news about SolarWinds Database Performance Analyzer (DPA)
To me, it seems like creating alerts with no database instances selected and assigning the servers via Alert Groups would be the best option. But are there any alerts that this will not work on? For example, lets say one alert is supported on 2012 and later, but one of my servers is 2008. Or take the Windows Service Not…
With the way the SQL Server error log alert is designed, I have to create 1 alert for every "clause" I want to search for. For example "Error" would be 1 alert, "Fail" would be another alert, and "whatever other string" is yet another alert... and so on. Well, if I were to model what SCOM does, there are several hundred…
Is there any documentation that goes through each alert type and describes how to leverage them (for SQL Server in my case). For example, what values should I use for the calculation, percentage, etc.? I realize some metrics with high values are bad, others (i.e. PLE) with low numbers can be bad.
DESCRIPTION This custom metric will track the fragmentation of an index METRIC DEFINITION To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this: Database Versions: <no limitations> Display Name: Index Fragmentation Description: <add your own description> Category:…
Hi All, I'm having below alert from DPA for all of our monitored servers. But i'm not able to figure it out what it is? The job [SummaryPollJob] has not been run in [1202] seconds, and its tolerance is set for [1200]. Why we are getting this alert and how to resolve this? Thanks in advance!
How can I successfully renew free licence for DPA ? Due to message "Your DPA Free installation has expired. Download the latest version of DPA Free" I downloaded last DPA install and did upgrade of existing installation. It didnt work. Then I unistalled / installed again DPA. I didnt change anything.
I am new to Solarwind tools and have alert configured to fire on failed SQL server job (in a picture) I though that it must execute only for selected database instance, but it does execute for each of the environments (text below for PROD-SVR-DB-03, but only PROD-SVR-DB-01 selected). How can I configure this alert to…
Hi, Does anybody know how to extend the DPA - Total blocking time alert to include the spid, query text, users etc. as part of the email alert notification?
Hello, This question is about monitoring a free space in data files. Right now we have alert configure to monitor the free space inside a individual database file and we would like to change this to monitor a free space for a file group. It would be helpful if someone can share the query to monitor the free space for a…
We use this report often to produce a report on what we need to fix next. And then track these fixes over their life, and celebrate when they drop off the report. I would like to run the query behind this report, on the ignite database myself. I searched here on thwack first, but couldnt locate exactly what I was looking…
It looks like you're new here. Sign in or register to get started.