Comments
-
And this article documentation.solarwinds.com/.../dpa-identify-locks-blocks.htm should help you identify the last known activity associated with the "Idle Blocker".
-
You also asked about the replication status and I'm sure had other notable metrics in mind as well. In the comment above a custom alert was referenced that shows how DPAs open architecture can be used to extend it's monitoring capabilities to let you know when a failover occurred. This same open architecture can be used to…
-
Cleaned up the formatting and added the SQL Text to the return value.
-
Here is an example that alerts on any blocked session greater than 60 seconds for a given day between 6am and 8pm and then alerts on any blocked session above 300 seconds from 8pm to 6am. If the return value is true the alert will return a 1 so you'll need to make sure your Min high value is set to 1. Just another example…
-
Adding MySQL too: SELECT CONCAT('SQLHash: ', COALESCE(n.name, CONVERT(recent.sqlhash, CHAR)) , 'SQLText: ', SUBSTRING(SUBSTRING(st.st, st.ss, ABS(st.se-st.ss)), 1, 50) , 'Execs: ', CONVERT(recent.execs, CHAR) , 'Seconds: ', CONVERT(recent.timesecs, CHAR) , 'Recent Avg: ', CONVERT(recent.avg_exec_secs, CHAR) , 'History Avg:…
-
Here is the Oracle syntax excluding the variables. WITH plan_changes (sqlhash, planhash) AS ( SELECT sqlhash, COUNT(1) as count FROM ( SELECT DISTINCT sqlhash, planhash FROM CON_PLAN_SUM_#DBID# ps WHERE DATEHOUR >= CURRENT_TIMESTAMP - 20) a GROUP BY sqlhash HAVING COUNT(1) > 1 ) SELECT 'SQLHash: '||…
-
DPA offers a couple methods to monitor your AlwaysOn clustered servers. * You can register your AlwaysOn Instance using the availability group listener. DPA will monitor the cluster as a normal instance and can be configured to notify you when you have any failovers from primary to secondary by setting up a custom failover…
