Get the latest news about SolarWinds Database Performance Analyzer (DPA)
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
Has someone compiled queries to run against the dpa_repository database for some insight into tuning metrics versus GUI option? e.g. I researched these DPA tables and trying to decipher data ! [dpa_repository].[ignite].[CONST_9] [dpa_repository].[ignite].[CONSPT_9] [dpa_repository].[ignite].[CONSPA_9]…
Is there a way to trigger *all* alerts setup to be sent? Maybe in some sort of test mode? I'm configuring over 30 alerts across 4 servers right now, and it's simply not efficient to test these 1 by 1. Especially since the test doesn't show actual text, just place holders.
The documentation outlines this variable consists of alert status link, the alert notification text, and the value that triggered the alert. However, if I try to format my own email with the alert message, I cannot get it. The alert.notificationText pulls the text from the alert definition, not the alert that was…
I'm trying to display either the alert.notificationText or the alert.status.message. I had assume one or the other would be blank base on the status value (BROKEN or one of the other values). So in my template I have it formatted like such: <b>Alert Message</b> [=alert.notificationText][=alert.status.message] That way…
Is there a way to monitor for databases that are either dropped or added? Using SolarWinds DPA 2019.4.1054 for SQL Server.
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:…
It looks like you're new here. Sign in or register to get started.