mandevil · Product Manager · ✭✭✭✭✭

Yes! 8 ) Go with ALL you see in the dashboard.

Try going directly to it: IT Blame Game - YouTube

The response to this has been simply fantastic!! Thank you all for the reviews of DPA on G2 Crowd! In case you missed it, you can share your review on LinkedIn (I see some already have). Thanks again and if you ever have community type questions about DPA, I monitor Thwack pretty closely, so definitely feel free to post…

Here is a direct link: IT Blame Game - YouTube

For today's question, from a database performance monitoring aspect, this is a bit of a paradigm shift for some. When we hear systems are slow, we've been trained and conditioned to jump on and look at resources. However, this can lead you down the wrong road. Example, you hop on and look at CPU and memory. CPU is at 95%,…

Great feedback from several of you about the inability to watch video at work. I'll certainly keep that in mind for the next DPA mission and I'm sure Danielle will also provide feedback to others on our team. Thanks!

df112, mind if I reach out to you offline?

Monitoring SQL 2016 should still work just fine. We tend to follow the vendor lead for supported versions and hesitate to state we support a version that the vendor no longer supports (could leave us exposed)... We have quite a few customers still monitoring SQL 2016 with DPA 24x and 25x without issue.

If you go to Options -> User Administration, do you see all DPA users? Is AD/LDAP integration setup and mapped to security groups? If you have access, look for what role you have been assigned as well as what the repo owner is.

Understood - if you ever want to test out the functionality, work with your SolarWinds rep and hoping they can get you a temp key which will unlock the PC (Platform Connect) capabilities. Just FYI - more value is being added via that connectivity in the near future..

Confirmed - a subscription license is required to utilize Platform Connect (and CNS integration to ServiceNow).

I meant don't use strings for setting the value, so for the first line in the CASE statement, use =0 THEN 0 so that we can evaluate that numeric (DPA can't evaluate 'HIGH' or 'NORMAL' as a value - those you will set for the notification criticality for the 0 or 1 or 2 results from the THEN clauses. Hope that makes sense.

Permissions may be the same, but user mapping may have changed for the schema. See if this article helps and if you still need assistance, would recommend opening a support case.. support.solarwinds.com/.../Move-a-DPA-repository-on-SQL-Server

The test is running the query, but pretty sure we can only evaluate numerics for when to trigger the action. As a quick test, can you set count(*) = 0 then 0 and count(*) > 0 then 1, then use those as your min AND max for the alert criticality. See if that works. I can test next week also if you don't get a chance before I…

Here is a query that you could use to create a custom alert (single numeric custom alert): select ( select (sum(bgets) + sum(dreads)) from con_stats_sum_2 where datehour between dateadd(hour, -24, getdate()) and getdate() and period = 'H' and sqlhash = 3520226983) / ( select (sum(bgets) + sum(dreads)) from con_stats_sum_2…

Would suggest looking at it a little differently. Perhaps create a custom metric that starts to plot out logical reads in aggregate for the instance and then you can start to get a better sense using query stats within DPA to do some simple math on which queries are doing the most logical reads and as a percentage of the…

If you open a support case, they should be able to share the repo ERD with you as well as a brief description for CONSW and CONSS. CONSW especially can be a bit cryptic.

What kind of replication are you doing? AGs, mirroring, other?

Hi Froana, are you thinking to use this for some kind of auditing capability or change data capture capability? We employ a sampling algorithm (once per second) and can miss some less frequent, quick running DML (think like a statement that runs in 20ms between our polls). Just want to call out that DPA is not an auditing…

Hi Vailbhav, welcome to the DPA community! So this should be possible with a custom alert that goes after summarized query stats (executions) at the hourly interval. Check out the post I just created here on Thwack content and let me know if it makes sense and you can successfully create the new alert or if I need to alter…

DPA supports DB2 LUW at this time. DB2 for i is significantly different enough that it is not supported.

Hi James, thank you for pointing this out! We're going to check it out on our end.

See if this query gets you close to what you are looking for: -- select id, name from cond - use the ID from this query to substitute for <id> below select cm.name as "Machine Name", sum(sw.qp)/60 as minutes from cond c, conm_<id> cm, consw_<id> sw where c.id = <id> and cm.id = sw.pwmy group by cm.name order by sum(sw.qp)…

If you check out this post, it will provide top SQL by dimension by instance. It's a good base starting point to look at any top dimension. Top SQL by Any Dimension You could change up the select from getting top SQLHashOrName to MachineName and remove the SQLtext -- IZHO is SQL Hash and PWMY is machine name. What kind of…

Hi Arnab, I'd recommend you post your question under the SAM content as this space is intended to help extract data directly from DPA. Unfortunately, this would potentially need to come from the Orion repository. Sorry for the inconvenience!

I'd love to hop on a call with you and walk through the things you are bringing up here - they are great questions and points. Let me know if it's OK to reach out to you directly to schedule something. I should be able to get your contact information internally if you approve.

Actually, DPA is providing all the information you would need as a DBA to determine if the MS advise is good or not. We are parsing the query plan and looking at the producing steps to make sure the data fetch is optimized - if not, we surface it in DPA as part of the plan predicate info. The great part of this is that DPA…

Are you specifying to clean up DPA monitoring user and artifacs? (I forget exact wording) If yes, then if DPA can't connect to that instance any longer for any reason, it will fail. If you don't select to do those activities, it should be able to remove the instance from DPA. If all else fails, consider opening a support…

Are you getting any errors in the UI? Anything you can share here?

Did you install the postgres-odbc driver also on the linux host? Think it was step 3 of the instructions (in addition to the unixODBC driver)... Not sure if you are leveraging DPA as a SWI solution, but if you are, it supports monitoring PostgreSQL and does ship with needed drivers (so shouldn't run into this type of…