spaceman ✭✭✭✭✭

Sorry, wasn't clear there.. i meant adding options like the SSRS options to 'export as' next to the email report option(s). Hope this clarifies it..

Slideshare's a blocked site here. I answered the question correctly as well, just glad it wasn't one of the trickier questions.

Nice workaround.. doesn't work for named hash values directly (just need to translate bcak from the name to the hash) , but i can live with that!

Years ago, back in my happy days of testing and faulting analogue private networks we kept getting reports of failures for one customers remote site. Apparently there were regular issues overnight and they were getting pretty annoyed with it insisting the fault was with the network. By the time it was reported to us the…

Snap, same OS and browsers. Still the same issue. Took the blind gamble 1 in 3 odds on the multi choice and got the question right!!!

Similar to ?

Wouldn't it include History too?!?

Yep, slightly misworded in the (correct) answer

You mean like Annotations (added in 9.1)? https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/DPA_9-1_release_notes

Noticed I was set to UAE as well a couple of weeks back. Do i smell the whiff of anti UK conspiracy?!

Not getting far with todays hint, stuck 'connecting to demo server'. Might be take 1 in 3 punt time..

Nooooo!! I'm out of the phaser remote draw Not sure if I misunderstood what was meant by total or if I just can't count. Bummer!

Pretty much how it feels sometimes..

Custom metric along lines of below for SQL2008+ might help? select physical_memory_in_use_kb / 1024 from master.sys.dm_os_process_memory

Well, i have signed up for a spectum vega!

Turns out the issue was only affecting a SQL2000 instance (yes, we still have one! ) No point in addressing it in DPA for such an old version so we've just added a custom metric instead and disabled the blocked sessions graph. It doesn't solve it in the Current activity view but we can live with it as we have the info from…

Thanks Brian, i've run a script checking what i consider to be blockers polling every second for a minute and refreshed DPA several times in the same window... DPA showed various numbers blocked but these weren't reflected by my script. I'll raise a case

Utility Control Point might be worth a look if you're using enterprise edition, works pretty well.. http://blogs.msdn.com/b/sravanisaluru/archive/2014/07/10/microsoft-sql-server-2008-r2-utility-control-point-multi-server-management.aspx

Hi, We're seeing a similar issue.. In our case whenever this occurs the cause appears spids blocked by themselves (parallel processing threads). It appears to be inconsistent in the GUI if this is case - and (personally) i'd rather they were ignored on the currently blocked sessions area of Current activity as it's normal…

Yep I've seen it before in IE10, same page was fine in Chrome

Thanks, I was hoping for a method through the front end - but I can work with this if no-one else comes back with anything else

Default 30 days here... 20 monitored instances, ~90GB data file for SQL Server repository

Thanks Brian, makes sense. If anyone reading this anyone wants it as a custom metric for SQL2005 we use the same query as the performance dashboard; DECLARE @ts_now BigInt SELECT @ts_now = cpu_ticks / cpu_ticks / ms_ticks FROM sys.dm_os_sys_info WITH (nolock) SELECT TOP 1 SQLProcessUtilization FROM( SELECT…

As an alternative metric the below will work with SQL2005; Metric Type: Delta Frequency: 600 (once every 10 minutes) Timeout: 20 SELECT cntr_value as count FROM sys.dm_os_performance_counters with (nolock) WHERE object_name = 'SQLServer:Locks' AND counter_name = 'Number of Deadlocks/sec' AND instance_name = '_Total' Note -…

Looks like you have the custom deadlock metric enabled (Custom Metric - Deadlocks) from the text. You could disable that or give the SQL2005 version (in the comments) a go if the dbghelp entrries in the log are an issue.

I think that screenshot is from the query Analysis screen, if so and you scroll down there will be more information on average waits per execution and execution counts. I'd guess you're having a lot executions for that query with very short duration - so you do not see it as an active session under the current activity tab.

Isn't that a redgate tool call? The TFS plugin for SSMS springs to mind.

I had same issue, see mandevils response here