mandevil · Product Manager · ✭✭✭✭✭

awickham10, we currently do not have a report rendering engine built into the product. That would be a nice enhancement for our roadmap though! You may want to submit it on our future requests section here on Thwack so that you and others can vote on it. Product Management definitely takes the Thwack votes into…

Have you tried running a report for the user? Select your instance, use "Top Database Users" report, but then switch to user-defined and add the user of interest. You can set timeframes from there and even schedule the report to run each month and send automagically. HTH.

Yes, you should be able to drill into a specific SQL statement and use the tabs across the top to view all dimensions about it including who executed it, from what machine, OS user, etc. Now that may be tempered a bit if there's an application that's using a shared login. We view things through the lens of the database…

The easiest way to ensure continuity if it is the same instance is to do an "Update Connection" from Options -> Monitor Setup. That way, you can track the change in performance profiles before and after the upgrade to new HW. I think you left the old instance in there, but just switched the licensing to the new instance on…

Yes, those black areas/lines are baselines, so yes, historical averages. You can toggle baselines on and off in the trends view while looking at waits correlated with resources.

This is something that was introduced with the latest Orion releases (core 2016 modules like NPM 12 and SAM 6.2.4). The recommended action is to move the DPA application to anther host. Instructions: Move DPA to another server - SolarWinds Worldwide, LLC. Help and Support If you do get into a configuration where Orion and…

To the database, they are one and the same. The request is being executed by the processor which is grabbing the data from cache. That's why we use both resources in the activity name. If you think about it, any process or thread can be in any one of 3 states: running, runnable, or suspended. When we categorize it as…

We don't currently persist the sql_handle in DPA. There is a feature request to do this and it certainly is on our radar. Would you mind voting these up? (gets more attention by the product team the more votes it has)

The metrics are gathered by running queries directly against SQL Server. As long as we can query and get a response back from the database engine, then we should not be missing metric collections. Are you a customer with current maintenance? If yes, you can create a support ticket including your logs (we'll want to…

If you are trying to reduce storage requirements, here's what I'd recommend. Determine the number of detail days you want to keep history for. This will be the number of days you will have to ability to drill into the second by second activity. Navigate to options -> Administration (Tab) -> Advanced Options -> DB Instance…

Can you leverage this alert? Custom Alert - SQL Server Backup Monitoring You might have to edit for the Never condition in the select and where clauses...

We get this information from the information_schema.processlist(host column) table and the performance_schema.threads(processlist_host column) table. It gets a bit more involved, but basically, we pull that data for anything that meets these criteria: WHERE t.PROCESSLIST_ID is not null AND t.INSTRUMENTED = 'YES' AND…

Are you going to be moving over the repository in order to keep history? Our alert metadata is primarily stored in the repo...

If you are using the canned resource for blocked sessions, then, yes, we query the repo for data already collected. This offloads any overhead on your monitored instance as the data has already been collected. Having said that, the default collection for that resource is in 1 minute intervals. Setting up the alert to also…

Are you not upgrading to DPA 11.1 (latest) because 10gR2 is not officially supported per the admin guide? If that is the case, you are correct in that it is not officially supported in the latest release, but it should work just fine. The Oracle driver we ship with should be +2, -2 for major Oracle versions. In fact, in…

Here is a short description of the notification levels. The High, medium, low, and info are whatever thresholds you want to set them to. This can be subjective and specific to your environment, so we don't auto populate them as there are a LOT of variables that can come into play. Hope this helps. Alert notifications in…

You may want to create a custom alert using this SQL. Then you can tweak it and even take the witness server references out. SELECT d.name + ' - Mirroring State Desc:' + m.mirroring_state_desc COLLATE DATABASE_DEFAULT + ' Mirroring Witness State Desc:' + m.mirroring_witness_state_desc COLLATE DATABASE_DEFAULT as Name, 1 as…

We do the discovery in an automated fashion, matching up the application (client) server with the machine tab in DPA. With that many discovered clients to map, you might want to move past that part of the integration and not define any client mappings initially. Then you can go in and manually define the key relationships…

You are correct. A use case we likely didn't catch during requirements phase. Worth submitting a feature request?

I know we're looking into reporting for resources: What We Are Working On for DPA (Updated Feb 11, 2016) However, right now, I don't see anything that exactly meets your needs...

Ditto to what was mentioned. I like the resources view to see what I have at my disposal for potential correlation to the waits, but pretty much never work from that view. I work pretty much solely out of the trends view and then bring in appropriate resource metrics for correlating events with potential resource…

What flavor/version of browser are you running? We've seen this recently with latest FF. Can you attempt from another browser and see if you get the same error?

Apologies on your experience with support. Do you mind sharing your case number with me so I can follow up internally? Also, I'll notify our PMs on your request.

DPA does the heavy lifting in the repo. So your concern is exactly right, we don't want to create a performance issue by sharing the same physical resources. Now, technically it's entirely possible to run the DPA repo on the same host as your monitored instance, but could have an impact. A different host within the pod…

The instance availability alert should alert you when a monitored instance goes down. I've tested in our environment, but would suggest you test in yours. Might you have a dev instance you can use for this?

If you submit a case on this, we'd be happy to do a walk through of the possibilities with you.

11.0.378 was the GA version, but shortly after, a service release was issued so that 11.0.387 was pushed with the fix to the portal. Just chance that the SR version was just the last two digits transposed from the GA version... You are correct though in your thought.

Not too well documented, but here are the instructions. On the DPA app server, navigate to <install_dir>\iwc\tomcat\ignite_config\idc, open system.properties. Look for this section: # OVERRIDES PROTOCOL, HOST AND PORT USED WHEN BUILDING LINKS # TO THE IGNITE WEB CLIENT IN EMAIL MESSAGES # FORMAT: http[s]://host:port…

That means the integration module for some reason never got installed. You should be able to get the DPA Orion integration module from your portal as a download and install on your Orion server (where SAM is running). Then you should see a link for Database Performance Analyzer under Product Specific Settings.

Check out this article in our success center. See if it helps. I think it explains exactly what you are seeing and what you can do. SQL text is showing the incorrect database information in the SQL server - SolarWinds Worldwide, LLC. Help and Support