Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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…
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]…
It looks like you're new here. Sign in or register to get started.