Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Hopefully this is a simple question. I need to view all the named queries on a server. Back some time ago I passed some tuning advice to a third party. It seems they took it, and the query I had originally named was modified and is now at the top of my wait list again, but slightly different. I'd like to name it the same…
Is there a way to create an alert for deadlocks in SolarWinds without the use of a DPA server?
Please let me know the way to look deletion executed queries in this tool when finding exact time from the server to solarwinds tool the statement show " SQL statement not available" kindly help me to find the delete statement in the solarwinds tool
Briefly written step by step Solarwinds Database monitoring guide.
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.
It looks like you're new here. Sign in or register to get started.