mandevil · Product Manager · ✭✭✭✭✭

I'd like to encourage all to vote this request up: If there are specific requests like being able to change wait/activity color also, please add that to this request as it's in the same vein.

Too funny - this was at the request of customers who did not want to see Memory/CPU as red due to the negative connotation. 8 ) Having said that, there is a way to change the color associated with a SQL hash, but not the waits/activity. Sorry about that! This would be a feature request to fix the feature request that was…

We're creating the hash within DPA based on output from the RDBMS. For example, we'll create the hash in SQL Server from parts of the sql_handle, and some other factors. For Oracle, we actually get the hash from Oracle itself. Thus the problem - if the RDBMS sees it as a new query, so do we. Recommendation: You can create…

Jeff, it's more than just inserts, it would be the schema creation (DDL). This isn't something we support. If you are using it as a test bed to work out scripting Oracle to MySQL migrations in general, that's great! Otherwise, we normally recommend standing up another DPA instance using MySQL for the repo, register all of…

Is it actually in your path though? echo $PATH Try that, but if that doesn't work, you may want to open a support case where they can hop on a call with you and walk through the installation.

This means the application is using a server side cursor. DPA does not use tracing to gather information but rather DMV analysis. This means it is a very lightweight tool but can only display the info it's given from the SQL Server DMVs. We are receiving the FETCH API_CURSOR statement from SQL Server. You could use our…

Wonder if it could be something to do with your file initialization configuration or perhaps autogrowth increment size? https://www.brentozar.com/archive/2014/02/preemptive_os_writefilegather-and-instant-file-initialization-ifi/ Lots of material on MSDN on how to adjust settings around this that *could* help.

You can look at what's been excluded for analysis in the following tables: select id, name from COND --- use the id from above to replace <id> below CON_PROBLEM_ANALYSIS_<id> CON_PROBLEM_SILENCE_<id> The silence table will be the ones excluded from analysis.

Hey Tony, the best way to get to this and other data would likely be a ticket with support. They will help you with the table structure and best places to pull this info (note, from your sample data, summarized might be the best and most efficient instead of detailed).

If you go to options, there should be a tab for Monitor Setup and a button for Unregister. Click on that and follow the wizard through. That should remove all traces of the instance you unregister.

See my reply on your post under that specific custom report and see if that helps. Custom Report - Top SQL by O/S User

I realize this post is a little older, but did want to update it with current information. Huawei is now supported by SRM. If you still have interest in putting it under monitoring and management, give it a go and let us know how it goes.

Due to our architecture, monitoring an instance over a WAN could be problematic. My recommendation would be to install DPA in the same location (network) as the monitored instance and access the web UI over the WAN. The reason for this is we want to make sure we're getting the performance data collections successfully and…

That is coming from MS SQL Server itself and determines what kinds of reads or operations are allowed given the isolation level set. The two is just the numeric identifying a "Read Committed" isolation level. For a complete writeup about isolation levels, check this out: Understanding Isolation Levels | Microsoft Docs

If you are on version 10+, you can click on the query from the main trend page and select to exclude it from the chart. If you really want to exclude the hash from monitoring completely, you can go to advanced options for that instance, click support options, and edit this option: QUICKPOLL_WHERE_CLAUSE Follow the info in…

Have you tried to clear your chart cache? Force DPA to render them again? If you go to options -> support tab -> clear chart cache Did something happen in mid-April in your environment? If the clearing your cache doesn't work, then I'd recommend submitting a ticket as this will require some investigating (likely a GTM).

What kind of repo do you have? Oracle, SQL, or MySQL?

Like here is an example query against a SQL repo, but again, you may want to go after rolled up data. Custom Report - Metric Values

Is this in relation to DPA or SAM? We don't usually see a driver specified in the connection string as we will use the one we ship with, but I can ask engineering if need be. I just need some clarification on where you are specifying this and in what product?

Looks like you have a great start with the query. What I'd do personally is to set up an alert for this. Put all of the details concatenated into column 1 of the select, then a case statement of success or failure based on the status (since this needs to be a numeric). You can then be notified if the case statement…

Can you try to "run as administrator"? This could potentially be a permission issue. Assuming you are not using any encrypted folders in your env? BTW - I have NOT tried to install on Windows 10 yet.

DPA currently supports SAP (Sybase ASE) as a database platform. Here is the list of supported monitored databases: Sybase ASE, Oracle, DB2, MS SQL Server, MySQL You can also reference our admin guide for this info: SolarWinds Online Help

Hoping you are evaluating DPA 12.1 as it has a key feature that may help here. The simple answer is that you want the vast majority of time spent in cpu/memory - that's an indicator of a healthy system. cpu/memory means that the queries are executing/finding data in cache - and not doing other activities like waiting for a…

We can only process 2 columns in our alerts, so the first column has to be a concatenation, then you'd have the numeric. Define the alert as a custom multiple numeric return. This will run, but you will likely run into an issue with the size of the text should you actually encounter blocking. We limit the text to 100…

We query SQL Server itself for these numbers. So even if the OS is seeing low latency across all drives, SQL is apparently realizing high service/stall times when IO requests are being made. We query from the dm_io_virtual_file_stats DMV for these metrics. If you get to a period of time where you see we're showing high…

latkinson, can you check out the logs for that instance? Lots of times if a password on the monitoring user changed, we will fail to authenticate and you could see loss of monitoring. You can check the logs from the home screen by looking for the instance in question, choosing the action dropdown, click on the log link.

Just an update on this one, SQL 2017 is now completely supported. On Windows or Linux for monitoring! (Windows for repo)

Have you checked out this custom alert? Custom Alert - Fragmentation Might be just the thing for your environment...

I've used this query for tablespace sizes previously. Thinking you could modify it since it currently works on a % basis. I'd suggest that since you are monitoring all of your tablespaces, you add a case statement to this so it will evaluate to a 0 or 1 (any TBS not exceeded threshold or exceeded threshold). Otherwise,…

Can you post the actual SQL? What user is executing it?