m60freeman · Senior Database Administrator · ✭✭✭✭✭

I checked all 4 boxes for June 26, because all four are mentioned in the linked article. However, my response was marked incorrect because it was expecting Memory Ballooning, which is the 4th box I checked. Why are the other three incorrect?

Since at least 9.5 (and probably earlier than that), there is an edit button for each blackout. Here's a screen capture from my 10.0.352 (cropped to just show the first of my many blackouts). Look in the lower right corner of the image below.

It seems to be fixed now!

I am surprised, humbled, and honored to have been selected. Congratulations to my fellow MVPs, new and renewed!

I am both a Development and Production DBA, which includes code reviews of all TSQL code, performance tuning, and managing performance and capacity of the Azure SQL Databases and Elastic Pools.

Excellent! That link shows "1:30pm – 2:00pm: Light box lunch served (will update with detail soon)". However, there have been no updates...

Please see related feature suggestions:

15 green checkmarks in a row for me so far!

@"kpina" Another non-working poll for Day 15. They fixed the ones for Day 5 and 10, so why doesn't the one for Day 15 not work?

Yes, Columbus today. A little snow won't stop me. See you at 1pm! Mark Freeman Database Administrator | Rogue Fitness 1080 Steelwood Road, Columbus, OH 43212 MFreeman@RogueFitness.com On Wed, Jan 20, 2016 at 10:02 AM, DanielleH <

The 30 character limitation is antiquated and needs to be increased significantly.

My opinion is that this should be a separate feature request as it is not directly related to adding baselines. I'd definitely vote for it, especially if we could configure the start and end times for "business hours". For example, I run CHECKDB, statistics updates, and index defragmentation nightly on some instances.…

The poll is not working for Day 10 either.

This is especially helpful for presenting justification for increasing the RAM or processor cores allocated to an instance, or initial evidence that there may be a performance issue in the I/O subsystem. In fact, having some built-in reports for those issues as samples either included in the product or available on Thwack…

This seems to be a duplicate of

OK. That was one I knew the answer to without needing to look at the hint so I didn't bother clicking on the link. I didn't know that any of them had videos. Now I know, so thanks!

I'm clearly missing something. This is the first Mission I've attempted. I keep seeing comments referring to videos, but all I've seen is a Hints link on the questions. Where are the videos?

I also noticed that when looking at a chart showing SQL statements, the bar will change color if you name it instead of leaving it as a hash number. I don't know if that's intentional as there is nothing that says there is a different color set used for named statements vs. unnamed.

Simply surfacing the missing index recommendations from an execution plan, or all of them from the plan cache, would be helpful to some people. What would be even better would be to add some value to them, especially in the context of an Advisor. A missing index recommendation may really indicate a need to just to add a…

Again, the poll is not working.

See related suggestions:

We have an application that uses Grails and Hibernate. It appends a semi-unique number onto aliases. For example: (@P0 int) SELECT this_.autonumber as autonumber4_0_, this_.Carrier as Carrier4_0_, this_.OrderNumber as OrderNum4_0_, this_.TrackingId as TrackingId4_0_ FROM SETrackingView this_ WHERE this_.OrderNumber=@P0 The…

Yes indeed. I had to look at it carefully as there initially appeared to be two correct answers but we could only select one.

Being able to hide an advisor for a particular hash / name would be very helpful in cases where I've analyzed the issue, documented it in the Description (in the dialog used for naming a hash), and it is simply something that cannot be resolved. Sometimes we have a business requirement for which the solution is hard on the…

This was in Brent Ozar's Office Hours this week: Why does SolarWinds say I’m waiting on memory?Brent Ozar: We got a follow-up on the memory question, and it is exactly as I suspected. There is a popular monitoring tool called SolarWinds, and this person says, “We’re using SolarWinds and memory CPU is listed as the metric.”…

Ideally, it should allow getting an Analysis or History for a sys.dm_exec_query_stats..sql_handle (for example, 0x02000000a7c7fd0d919abe9811febe229e974fd643f792150000000000000000000000000000000000000000) as well. Related: Somewhat related:

See related issue:

I actually run the free Dell Spotlight Essentials on my servers in addition to DPA just so I can get some kind of real time view of what's going on. That adds a lot of overhead and just seems silly. It would be much better to add the functionality to DPA.

For SQL Server, this could be by FILEGROUP or by logical disk (C:\, D:\, E:\, etc.). I'd prefer the latter.

There may be other ways to address this issue, but I'd like to see something implemented to resolve it. Perhaps a check box that would replace the bar for any period that exceeds the average of the displayed values by more than 3x with nothing (leaving a gap for that period).