Erik Darling comments

Results 51 comments of


                                            Erik Darling

sp_QuickieStore: See if dm_db_tuning_recommendations would make a useful addition.

This is kind of lame. The OPENJSON query doesn't work on pre-2017 compatibility levels. Just playing around a little this morning, I can pull out the recommended and regressed plans...

Is it misleading that first_execution_time returns a +00:00 DATETIMEOFFSET?

@ReeceGoding if you want to figure out what's going wrong and fix the actual issue, cool, but just changing a data type doesn't do that.

Is it misleading that first_execution_time returns a +00:00 DATETIMEOFFSET?

Closed #458

(sp_IndexCleanup) Feature Suggestion: Normalize filtered index bodies

@chadbaldwin perhaps it would work better to normalize the column names and expressions first. I can't think of an awesome way to do that off the top of my head....

(sp_IndexCleanup) Feature Suggestion: Normalize filtered index bodies

@chadbaldwin I haven't heard back on this in a while, so I'm going to close it out. If you want to add in anything, ping me and I'll re-open it....

sp_QuickieStore: Add a way to check for queries that have recently changed in performance

@ReeceGoding no, sorry.

sp_QuickieStore: Add a way to check for queries that have recently changed in performance

Closed by #486

sp_QuickieStore: Add the ability to sort by total wait time and by plan count.

There is a wait filter parameter, but the waits column is not sorted by it because it's not really suited for that. I'm open to alternate solutions, but it's not...

sp_QuickieStore: Add the ability to sort by total wait time and by plan count.

@ReeceGoding Oh I see, it's in the title but not in the body. Plan count might be cool, but I don't know if I'd go with the query id/plan id...

sp_QuickieStore: Add the ability to sort by total wait time and by plan count.

@ReeceGoding sort of like the plan cache, `query_store_plan` has `query_plan_hash` and `query_store_query` has `query_hash` I haven't tested it, and I don't have good production data to do it with, but...