Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Quite frequently, when I reboot and have to login to DPA, the username in the login box is someone else that uses the system (not from my PC). Does anyone else get this? Surely it's a security flaw, showing me someone else login name that's allowed to use the system. How can my PC show me the login name of someone else…
Hi, Currently in my DPA I have all trace only for one month. Can I keep 3 months all trace in SolarWinds? Best regards, Radoje
I want to duplicate the performance analyzer report (from Orion) for the following metrics: * Blocked SQL Statements * The Impact of Root Blockers * Total Instance Wait Time * Wait Time by Wait Type Which tables in the DPA repository do I need to query to return the same results?
DESCRIPTION This alert will detect and show deadlocks in SQL Server instance. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below. Note: When DPA executes this alert, it will substitute…
DESCRIPTION Shows the number of blocking sessions. ALERT DEFINITION To create this alert, click on 'Alerts' > 'Manage Alerts' tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below. Alert Name: Count Blocked Sessions On Execution Interval: 10 MInutes SQL…
My requirement: I have a MySQL query that looks up the data in the performance_schema and returns the SQL statements that do not meet my performance criteria. This query returns multiple rows and columns. I want to create a SolarWinds alert that will run this query once a day and, if it returns any rows, email me the…
Trying to create an email alert when an OBJECT:ALTERED is either changed, deleted or altered. What is the best way of handling this.
Our database team is very reluctant to provide the sysadmin credentials for the database servers. Is there any way that we can monitor the database servers without the provision of sysadmin credentials. Like in SAM, a SQL server can be monitored to some extent using a limited rights user. I have tried DPA and SQL Sentry…
My DBA said that there is an error in the DPA Script.... Someone have a idea... ? Before the update....everything worked well
Is there such a thing as the ‘Comprehensive Manual for DPA for SQL Server’ ? A document, guide or manual that covers DPA For SQL Server from top to bottom leaving nothing unexplained. I’ve already inquired with DPA Support about this and the answer is to redirect me back to the same webpage at their site with the DPA Admin…
It looks like you're new here. Sign in or register to get started.