m60freeman · Senior Database Administrator · ✭✭✭✭✭

So what does mapping the drive letter in DPA accomplish in terms of what is visible in DPA? Mark Freeman Database Administrator | Rogue Fitness 1080 Steelwood Road, Columbus, OH 43212 MFreeman@RogueFitness.com On Tue, Jun 7, 2016 at 11:26 AM, mandevil <

This is really interesting, and something I hadn't before considered. Assume I have the option set to the default of displaying the top 15 and I am looking at the chart for a day. Also assume that from 4am to 5am none of those top 15 were executing, but 16 - 25 (for the day) were executing. Based on what siggy​ is…

The "My Ideas" link goes to https://thwack.solarwinds.com/people/#{username}/content?filterID=contentstatus%5Bpublished%5D~objecttype~objecttype%5Bidea%5D, which even though I am logged in, is showing me the page containing profiles, not my ideas:

Yes, this is a major pain point for shops using LINQ / Entity Framework. I just created . Please vote for it.

Please vote for this feature request: ​ It has 29 votes at the moment, so there's hope...

On the SQL tab, where you see a list of hashes and named queries, click on one. In the upper right corner of the resulting dialog, you should see a checkbox labeled "Exclude this SQL from Performance-side Trend charts". Check that, click OK, and it should vanish from most of your screens. This feature was added as part of…

Please upvote

1) What if I'd like to receive an email for each deadlock that includes the XML for the deadlock in the body of the alert email (or as an attachment)? 2) How can I create a chart from a custom metric like the one for deadlocks?

I just re-checked this and the "view all recent ideas" link now seems to work, but "my ideas" still takes me to that same incorrect page.

Danielle, Neither "view all recent ideas" nor "my ideas" work properly for me. Thanks, Mark Freeman Database Administrator | Rogue Fitness 1080 Steelwood Road, Columbus, OH 43212 MFreeman@RogueFitness.com On Fri, May 15, 2015 at 12:44 PM, DanielleH <

Is this a problem resulting from upgrading to 10.2? I just tried to send an email from the Deadlocks page for the first time and got this: Send Email An error occurred trying to send the message.This could be caused by an SMTP configuration problem. Open {Install…

FYI, I see blanks when looking at either a one hour interval or a one day interval and click on the hash (or name for ones with names) in the SQL tab. It's only when I pick a hash to Analyze that the data is actually present and not just the labels.

I have no issue with the 9.2 release being totally dedicated to this integration. I just didn't want to make my operations folks download and install it if it wouldn't benefit us as we don't have Orion. It sounds like we'll wait for 9.3. Thanks!

The issue isn't one of parameters or bind variables. Grails/Hibernate seems to randomly generate SQL with different column aliases for the same query. For example: (@P0 bigint) SELECT setracking0_.OrderNum as OrderNum9_1_, setracking0_.AutoNumber as AutoNumber1_, setracking0_.AutoNumber as AutoNumber2_0_,…

I support this idea, so I entered it: https://thwack.solarwinds.com/ideas/4831

While I completely agree (I authored both of those feature requests ), if there is a way to convert from the SQL hash value that DPA stores to the sql_handle value, that would be very useful information. Of course, if the SQL hash is unrelated to the sql_handle, then there is no way to convert between them. But knowing…

Kathy, When I go to our developers and say something like "you had an idle blocker that held up a half dozen sessions that were trying to access table foo for 20 minutes" and I explain yet again what an idle blocker is, they always come back with "Can you provide any other information that would help me track this down?"…

Jamiin, Thanks for the detailed response. 1) So this is apparently an artifact of not having baseline support for the VM/Host metrics. When baselines are being displayed, why not change the chart types for all the charts whether they actually display a baseline or not? It would keep the charts consistent with each other.…

If we're only getting a single number, then we are likely just getting that harmonic mean that Paul Randall mentioned. This might be worth digging into. SQL Sentry apparently monitors the individual buffer nodes <http://sqlperformance.com/2014/10/sql-performance/knee-jerk-page-life-expectancy> . It isn't a matter of…

jaminsql​: Any news on this?

I was looking for a number of characters, not a number of seconds. I'm interested in maximizing the amount of information I can stuff in there. In the project I'm currently working on, that would be msdb.dbo.sysjobhistory.message, which is defined as NVARCHAR(4000). I have to truncate it to 425 in the alert, but that loses…

I don't know of a way to do what @awickham10 is asking for with the current version of DPA. I want a feature that will enable me to group hashes. So if a statement is non-parameterized or a statement in a procedure changes, I could link the old and new versions together so I could see the performance change in the chart by…

Rob, Thanks for the response. I do appreciate all the detail. This blocking session is for a Grails/GORM/Hibernate app that doesn't do any external calls (that I know of). All the SQL Text for that SPID during the 10 minutes before the blocking were all just SELECT statements. But as you said, there is no guarantee that…

Note that there is a major difference from excluding from a chart or report and excluding from collection!

If I plug the resulting hash value into this and run it in the instance triggering the alert, I get nothing: SELECT st.text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st WHERE qs.query_hash = CONVERT(VARBINARY(8), <HashFromAlert>); Any ideas?

mandevil: Any news on this? Is it being handled as a bug or do I need to submit it as a feature request?

The query load on this 2012 SP1 instance is a mix of stored procedures (very few use OPTION(RECOMPILE) in queries and none have WITH RECOMPILE on the entire proc), Entity Framework (LINQ) apps, Grails/Hibernate apps, an Access app, and even a few Excel users. It is a hybrid of OLTP and "reporting" (no SSRS, but many pages…

Having the ability to click on a button or link to retrieve the query_plan_hash for the displayed SQL Hash without having to manually hunt for it in the repository would be a great enhancement to the UI.

I have a related issue. My Operations group has configured the drive name to drive letter mapping for the one drive used for database files out of the three drives on one of my servers. But when I look at Resources | Disk Device, the Disk drop-down lists the three drive names and provides no indication of the drive letter…

I created as a Feature Request. remo.mills‌, please vote for it.