The most recent content from our members.
DPA 24.X & 25.x does not list MS SQL 2016 as supported databases. My question is can we still monitor SQL 2016, not expecting any support. We are upgrading from DPA 2023.4
The stored procedure having (Inserts is part of stored proc) is waiting for long time and Plan Hash showing Insert operation Clustered Index cost is 100%, Wondering how to resolve the issue ? The insert table has primary index and multiple non clustered indexes, wondering if excessive indexes will have any impact while…
Is there a standard alert that informs the administrator when a DPA monitor is OFF or unresponsive? Or is it possible to create an alert that will effectively monitor the monitors?
I want to list all MSSQL Indexes which are unused from the last system restart and compile them for a cleanup. Could you please suggest if we could query DPA database to get the details.
As subjected need help in creating a custom alert for few SQL database instances where in if we can know if a particular query is using more than N percentage of memory resources. Not sure if this is correct way to check against a SQL statement, as in i see most of the parameters its against is only Waittime
My requirement is to list all newly introduced statements on my DB or Instance level, It will help to work on new query-wise review cost, plan, and execution count.
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…
Is it possible to setup an alert on a Availability Group's estimated data loss, so, when the estimated data loss is greater than x seconds or minutes, an alert is sent?
Hi, I'm starting to experience DPA Database Instance Monitor Errors when the monitored SQL Server is under a high load and users are experiencing timeouts. I'm getting the message: Monitor for database [WG-SQL] failed in job [QuickPollJob] due to [The query has timed out.]. Will attempt to retry every [60] seconds... Is…
How can I force DPA to use SQL Server Native Client 2012 or above for it's performance monitoring threads used to connect to SQL Server database servers? It appears in our environment SQL server native client 2000 is being used and we'd like to use a more current client in our environment.
It looks like you're new here. Sign in or register to get started.