Get the latest news about SolarWinds Database Performance Analyzer (DPA)
To assist our App Support team we would like to construct the an Ignite url that will take them to a specific time slice based on the time & date fields in the application log we are monitoring. Where a number of the parameters in the url are obvious some are not so obvious. Is there any guidance url parameters?…
I upgraded my DPA to latest version (2021.3.7388) yesterday. After upgrade, found that the list of servers is not sorted by Group Names anymore. Is it a known issue? Is it possible to achieve it?
We have an Always On Availability Group with a primary and 2 secondary SQL Servers. We routinely fail over to do maintenance. This changes which server is primary/secondary. When we set up reports to be emailed we "hard-code" which server info is first, second, etc on the report. I would like it so that we could always…
Hi is anyway I can correlate SQL HASH with query store in in SQL server? I tried collect SELECT H,SUBSTRING(ST,1,4000) FROM ignite.CONST_001 and SELECT [qsq].[query_id], [qst].query_sql_text FROM [sys].[query_store_query] [qsq] JOIN [sys].[query_store_query_text] [qst] ON [qsq].[query_text_id] = [qst].[query_text_id] group…
I've only just started working with Database Performance Analyzer (DPA) running on Linux, but I do have to say that I'm digging it. That is until I had to do my first upgrade. It wasn't a difficult task by any means. Unlike the Windows installation, it installs all the necessary files in a separate folder (by design) and…
BI Team is asking me about finding out who has ever run query or queries against a specific database on an instance we are currently monitoring using DPA. T-SQL code to be executed against DPA database will be useful. I am not really looking for a report.
Description This procedure, when executed, will return all SQL statements for the given date range and database user ordered by the metric of choice. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored…
Description This alert will monitor each drive being used by SQL Server. It first gets the free space in MB by running xp_fixeddrives and then gets total disk space from perfmon / WMI. It will return each pair of drive letter and percent free space to the alert so appropriate threhsolds can be tested. Alert Definition To…
Hi. Apologies if this has been already answered but I couldn't find any information... Is running DPA on Azure SQL Server Managed Instance and/or Azure SQL supported? I'm not talking about monitoring it but running DPA database in Azure. Cheers
Hi all, I tried to register AWS RDS SQLSERVER into DPA repository version 2019.4.1054 but what ever I tried (from Register Instance Wizard or from Mass Registration option, It didn't work! DPA Register Instance Wizard Help Step 5 of 5: Database Instance Registration StatusStep 1Step 2Step 3Step 4Step 5 2021-07-28 20:43:23…
It looks like you're new here. Sign in or register to get started.