mandevil · Product Manager · ✭✭✭✭✭

Can you run a couple queries for me against your repo? For the instance in question, run a "select id, name from cond" and provide the id. Then run "select id, name from conpr_<id from above>" and let me know how IIS is identified in our table.

I may have to go against detail after all. Let me work on this next week and I'll get back to you with something that should provide what you are wanting.

Think I may have misinterpreted your question initially. Are you talking about the drive letter associated with files that you see when you drill into I/O Storage? I may not be tracking you on this one... Can you share a screenshot of what you are talking about?

Glad you found it!! And, yes, we're always looking for good people! 

Do you know your SWID or have access to your customer portal? If so, you can submit a case under your portal under the support dropdown. If not, you can submit a case here: Submit a Ticket | SolarWinds Customer Portal

Best bet is this alert: Custom Alert - Long Running Queries Problem is the minimal interval is 1 minute from DPA. If you know the sql_handle, you could even include that in the predicate.

This was by design to show the top 15 statements for whatever time frame you have set in the product. There were a couple reasons for this (business of the chart, but also scaling). If we were to show the top 15 + "other" in many systems with something like an ad hoc workload, you'd lose the relative impact of the top 15…

Use the download from the SQL Server link then - they are all the same bits. We'll let the appropriate authorities know about the links pointing to the previous bits. 8 )

Performance is one of the toughest things to address, so here are some ideas to prove the worth: * Overall waits going down (from the 30 day trend view, click on the Waits tab and hope it's decreasing - if not you have the tool to identify things that need fixing) * Identify primary bottlenecks in your environment (where…

If you have the SQL hash value stored in DPA, you can get the user running it using the following: select st, h from const_ID_FROM_ABOVE_QUERY where upper(st) like '%STRING_YOU_WISH_TO_SEARCH%'; -- using the h for the hash from that query: select name from conu_xx, consw_xx where consw_xx.izho = <hash value from above> and…

Might need to fully qualify it. Who owns the objects in your repo? Maybe try it from the query tool inside DPA - options -> support tab -> Database Query Tool (should query against the repo by default)

Does it work if you switch it to default (an external SMTP server we have hosted) or embedded? At this point, I'd recommend opening a ticket and sending us your logs. We may get more from a complete error stack.

Should still work. Our quick poll methodology did not change.

Love it when products work like they're supposed to. 8 )

Yep, I'm with you both!

Agreed, since this is getting pretty involved, you probably want to open a support ticket.

OK, something you might try next time is go to Options -> support tab -> clear chart cache. That might help also.

Unsure. You could try configuring monitoring using a managed service account that has the correct monitoring privs in the SQL instance in question. However, the managed accounts seem like they'd be more limiting as they can't be shared across multiple hosts? I may have misinterpreted what I read on MSDN... Has anyone in…

Glad you asked! Yes there is. First of all, this is just a count of *observed* blocked sessions for any given period. Since you are looking at a long timeframe, it's a summary of the counts of observed blocked sessions for a day. If you were to zoom in to 24 hours or something like that, you may still see counts, but it…

Once you've configured AD and granted access to the AD security group, then it will work exactly like you state. DPA will NOT be doing the authentication - we'll hand that off to AD to validate authentication using the AD credentials (username/password).

Ah OK - are you using the repo owner to authenticate? Windows auth or SQL auth? Can you paste the error?

Yeah, probably a good idea at this point. The conss tables hold SQL Stats, so you can adjust an option for limited stats which could significantly reduce the size of those tables for instance 2&3. Those are likely just very active instances. conspt is sql plan text table. This can grow large if there are large plans or…

Great point!

Oh, try doing a search for the name in reports for top SQL or maybe even in the SQL text for something about the statement that would be fairly selective. You should be able to pull a report that can at least tell you what days it ran on and perhaps get a little more granular that that. Also, here's a post that may help:…

Were you using IE?

Steve, it should not. However, make sure everything gets cleaned up during the uninstall (files, service, registry). Delete the old repo database. Try spinning everything up again fresh. If this still doesn't work, I'll reach out to you directly to see what's happening on your system...

Or get more aggressive with your retention periods... Yes.

Check out this custom report (really just a query against the repo): Custom Report - Top SQL by Any Metric One of the choices is by executions. I think you can use it or even tweak it a bit to get the data you want since the UI is limited...

Mileage varies with storage consumption, but I have my personal configuration using SQL Express and monitoring 1 Oracle and 1 SQL Server instance. Haven't run out of space yet, but my instances are not running much activity (I forget to startup hammerdb sometimes). 8 ) Thus the mileage may vary. My recommendation is to run…

I think you have a ticket open with our support. Would it be alright to continue this conversation via the ticket?