mandevil · Product Manager · ✭✭✭✭✭

Just a way to limit results so that we're not parsing through every active session. Think of it as a filter, not a determination of when you get notified.. You will set the threshold when you define the customer alert in the UI to be what threshold you want to get notified about.

That was done with keeping practical page real estate in consideration. 8 ) So, since the analysis for the query is being done over the entire day, go to the day you are looking at in Trends view. Select the interval drop down in the upper left. Select 1 day to get all of the data rolled up into a single vertical bar.…

You should not have to. Can you describe the instance/environment you are monitoring? Oracle/SQL Server/MySQL/Sybase/DB2? What version? If Oracle, is it RAC?

If you register it by the virtual hostname, that's actually tied to a VIP. The virtual hostname and VIP are both included as cluster resources, so when a fail over occurs, monitoring will follow the virtual hostname which will still resolve to the VIP which will now be bound to the new node.

Unfortunately at this time, there's no way to customize the dashboard to add another column... Great feature request though!

One thing I always asked my developers when I'd see idle blockers was is there a dependency within the transaction that's external to the database query? If yes, is there another way to achieve the same transaction unit level (like do that external dependency first, then open transaction in the DB) without adding that…

Taking offline for now - I'll direct message you.

If I understand correctly, the monitor was stopped (likely due to instance being down and unresponsive). When the instance came back up, the monitor remained in the stopped state. Are you wanting a monitor the monitor? One thing I've done is schedule out a job that periodically runs a query against the DPA repository to…

I see - DPA (Database Performance Analyzer) is the product you posted this under. I think you meant to post it under NPM. I'd recommend you copy/paste the original question under the NPM product.

Custom alerts and metrics are my favorite. I can integrate any scripts I use personally into the product. Have you checked out the Thwack content also? Database Performance Analyzer

Awesome! Welcome to the family. 8 ) For more detailed assistance, feel free to reach out to support via your customer portal also.

OK, so we're calculating the amount of CPU used by the Sybase engines. The tricky part is with LPARs and processor entitlement, if capped or uncapped, virtual processors, etc. With the LPAR, not sure you're getting a good picture of cpu usage at all since you can potentially be working with a fraction of a processor.…

How are things running after removing the index? That index could have actually been at the heart of the blocking issue. I don't trust any tuning advise. 8 ) I'd test it out in pre-production, look with DPA - make sure it's not introducing the long waits again. Then promote to production if it looks safe. Have you gone and…

That is odd behavior though if the instance is still unreachable. You may have found an undocumented feature (AKA bug). I'd recommend opening a support ticket to see if we can replicate this behavior.

Keep in mind that 90% of the storage consumption results from the detail data. The 5 year data is at a daily summary level so much less storage requirements. Depends on why you want to purge data though...

And she's still using Office 2003! With the SA account! Kind of spooky. Check the basement and for missing staplers (Office Space).

I think you have a couple threads going for issues in your env. Can you open a support ticket and let us know when you have availability to hop on a GTM. Probably be easier to walk through things that way. Thanks!

OK, you confirmed a known issue with FF. Sorry for the inconvenience! We're looking into this.

Yep, I get the mathematical significance. 8 ) Feature request?

Mind sharing the script? Would love to see it. I can use it to compare results from our query (see below). Remember PLE is one of the contrarian indicators (low = bad, high = good)... select cntr_value from sys.dm_os_performance_counters where lower(counter_name) = 'page life expectancy' and object_name like '%Buffer…

Per normal, you're way ahead of the game! 8 )

You are correct in that DPA only "watches" active users, so will not show idle connections. You could create a multi-numeric custom alert and pull metadata about the sessions at say 10 minute intervals and then check in the morning what data was gathered. Something like (assuming Oracle??): select username, count(username)…

We run that every 60 seconds, so basically, we have to catch it in the act at the moment of polling. Our quick poll runs once a second and will pick up much better the impacts of blocking in your environment. I'm not going to say don't pay too much attention to that metric, but the blocking correlation tab and blocking…

Correct - great explanation (better than mine!) 8 )

A buddy drop is a patch/hotfix candidate. We test internally as much as possible, but like at least a couple of known successes before releasing it to a broader customer base as a patch/hotfix officially. During buddy drops, the customers will work closely with support and development to ensure success.

Hope you're feeling better - I had it once and it was BAD.

The total wait time represents the aggregate wait time of the SQL displayed (by default the top 15 statements). When you hover over a specific SQL hash, the wait time represents the waits just for that statement. Both of those numbers are specific to that time period, so 1 hour. These are not cumulative across hours (they…

Same isolation level. Good article here explaining it: https://blog.sqlauthority.com/2015/07/03/sql-server-difference-between-read-committed-snapshot-and-snapshot-isolation-le…

I looked those up and came up with the permission issue and an encrypted drive (assuming you aren't installing on an encrypted drive?). Windows 10 is not officially supported yet as a platform - however, I'm not aware of any reasons it wouldn't work. Has anyone else tried to install on Windows 10? Any success? I'll ping…

Here is a post on changing the color used for custom named SQL hashes: Change the display color of a database instance - SolarWinds Worldwide, LLC. Help and Support I haven't tested it yet, but thought I'd throw it out there.