PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

Great session by the way! One question, I didn't catch the command you were using to monitor the allocated memory for a process. i.e. In your 01_WorkspaceMemoryBasics.sql you would run a query and then monitor it. hmmm after some googling was it perhaps

select * from sys.dm_exec_query_memory_grants

Thanks,

me

Fantastic handling of the rough start, btw--- only the slightest of pauses as you handled the crash, and you were off to the races as if nothing had happened. Thanks very much for sharing the demos!

Thanks for sharing your knowledge with the community Adam!

Loved the workspace memory session at PASS, Adam...thanks for sharing the demos with us! A lot of good information and ideas to put to work this week now that PASS is over. Hope to hear you speak again.

Adam, it was a pleasure to sit in both this class as well as your pre-conference class: "No More Guessing! An Enlightened Approach to Performance Troubleshooting".

I've downloaded your queries and started pulling in baseline information on our system.  I wonder if you could answer one question regarding your baseline_queries.sql script.

In the script you are returning the AVE of r.MetricValue:

SELECT TOP(2147483647)

m.MetricId,

m.MetricName,

AVG(r.MetricValue) AS AvgMetricValue,

r.MetricValue appears to be the SUM of all samples over a 15 minute period (from the FifteenMinuteGroup view).  Shouldn't this be divided by r.CountOfRows? Something like:

SELECT TOP(2147483647)

m.MetricId,

m.MetricName,

AVG(r.MetricValue / r.CountOfRows) AS AvgMetricValue,

The results I'm getting back are averages of the sum of the 15 minute blocks. Did you leave the results this way on purpose or am I miss interpreting something?

Thanks Adam

I was so impressed by the fact that the content of the talk you gave was evidently 500 level and not something a person could come across everyday or in a standard class.

Our server is under utilized memory-wise and now I know how to adjust it.

I have been able to come back to my job and apply what you've said to the real world spikes we deal with at least once a week.

My boss thanks you.

It was a great session! i just wish i didn't have to go out early. :(

Great session. I attended both of your sessions and, as always, I'm impressed.

I'm disappointed that you decided to not share the slide deck with the attendees. I understand that you don't want to give away the deck to those who did not attend.  I'm required by my organization to write up a trip report.  If you could at least  password protect it using the same password as the PreCon materials that would be great.

Greatly enjoyed your session Adam. I have attended 7 PASS Summits now and never fail to discover some very useful information that I would have never discovered.

I wonder how you will be able to top the presentation next year?

Thanks

Chris

Adam, your session was amazing.  Definitely a 500 to 700 level dive into keeping query memory predictable.  Your presentation quality was excellent, and it's obvious that you understand what you're presenting.  However, there's one disappointment I will share:

I was hoping to see your slides after the fact, in some form, so that I could refer to the information to help explain "why" something works a certain way.  In fact, I had assumed they would be available, so I didn't take detailed notes.  Personally, I can't keep up with the speed of a high level presentation enough to take notes with detail.  I can only hope that the slide content is present on the DVDs when they're released in a few months.  Without the slides, my personal retention of the content will be under 10% - just enough to remember keywords to Google/Bing/#sqlhelp, and not enough to ask you to fill gaps by email.

Maybe my expectations are unrealistic; this was my first PASS Summit and first time seeing most of the speakers in person, so I don't have a baseline established yet.

Adam:

    Do you have any recommendations/suggestions on autocreate statistics ON. We recently had a huge performance issue in our data transfer routine with a bad autocreate stats.Currently couple of our tables are with over 30 autocreated stats (table with 40 columns).

Thanks for sharing the scripts! This was the most amazing session at PASS 2011. It was above level 400. :)

For the second year in a row, I was asked to deliver a 500-level "Query Tuning Mastery" talk in room