Search results matching tags 'PASS' and 'Query Tuning'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=PASS,Query+Tuning&orTags=0Search results matching tags 'PASS' and 'Query Tuning'en-USCommunityServer 2.1 SP2 (Build: 61129.1)PASS Summit 2014: Manhandling Parallelism - Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2014/11/06/pass-summit-2014-manhandling-parallelism-demos.aspxFri, 07 Nov 2014 00:32:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:56311Adam Machanic<p>Just a quick post to say thank you to everyone who attended today's Manhandling Parallelism talk! I hope you had even half as much fun as I did. For those of you who didn't attend, the talk was recorded and broadcast on "PASS TV," and I'm sure it will be available somewhere soon for on-demand viewing.</p><p>The demos are attached.</p><p>Let me know in the comments area if you have any questions!</p><p>&nbsp;</p>SQLRally Nordic and SQLRally Amsterdam: Wrap Up and Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2013/11/11/sqlrally-nordic-and-sqlrally-amsterdam-wrap-up-and-demos.aspxTue, 12 Nov 2013 00:56:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:51688Adam Machanic<p><b>First and foremost</b>: Huge thanks, and huge apologies, to everyone who attended my sessions at these events. I promised to post materials last week, and there is no good excuse for tardiness. My dog did not eat my computer. I don't have a dog. And if I did, she would far prefer a nice rib eye to a hard chunk of plastic.</p><p>Now, on to the purpose of this post...</p><p><b>Last week I was lucky enough</b> to have a first visit to each of two amazing cities, Stockholm and Amsterdam. Both cities, <a href="http://sqlblog.com/blogs/adam_machanic/archive/2013/10/04/query-performance-sessions-in-stockholm-and-amsterdam.aspx" mce_href="http://sqlblog.com/blogs/adam_machanic/archive/2013/10/04/query-performance-sessions-in-stockholm-and-amsterdam.aspx">as mentioned previously on my blog</a>, hosted SQLRally events, and I did a precon plus two talks at each event.</p><p>The events in both cities were well done and the audiences seemed quite sharp. Very nice events at which to be a speaker! <b>I hope to return to both areas very, very soon. </b>(Hint, hint, event organizers!)<br></p><p>Precon attendees: You should already know where to get your slides and demos.</p><p><b>Breakout session attendees</b>: Find the demos for both of my talks attached here.</p><p>Thanks again to everyone who I met and/or taught. It was really a fantastic week. Skål and/or proost -- depending on your disposition!<br></p>Query Tuning Mastery at PASS Summit 2012: The Videohttp://sqlblog.com/blogs/adam_machanic/archive/2012/11/13/query-tuning-mastery-at-pass-summit-2012-the-video.aspxTue, 13 Nov 2012 14:49:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46135Adam Machanic<p>An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a <b>direct link to the PASS TV video stream</b> for my <a href="http://sqlblog.com/blogs/adam_machanic/archive/2012/11/12/query-tuning-mastery-at-pass-summit-2012-the-demos.aspx">Query Tuning Mastery: The Art and Science of Manhandling Parallelism</a> talk, delivered at the PASS Summit last Thursday. I'm <b>not sure how long this link will work</b>, but I'd like to share it for my readers who were unable to see it in person or live on the stream.<br></p><p><b><a href="http://pass.bethereglobal.com/demand/day2p1.mp4">Start here.</a></b></p><p><b>Skip past the keynote, to the 149 minute mark.</b><br></p><p>Enjoy!<br></p>Query Tuning Mastery at PASS Summit 2012: The Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2012/11/11/query-tuning-mastery-at-pass-summit-2012-the-demos.aspxMon, 12 Nov 2012 04:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46095Adam Machanic<p>For the second year in a row, I was asked to deliver a <b>500-level "Query Tuning Mastery"</b> talk in room 6E of the Washington State Convention Center, for the PASS Summit. (<a href="http://sqlblog.com/blogs/adam_machanic/archive/2011/10/16/pass-summit-2011-zen-and-the-art-of-workspace-memory-demos.aspx">Here's some information about last year's talk, on workspace memory.</a>) And for the second year in a row, I had to deliver said talk at 10:15 in the morning, in a room used as overflow for the keynote, following a keynote speaker that didn't stop speaking on time. Frustrating!</p><p>Last Thursday, after very, very quickly setting up and getting sound and video checks, the rest of the talk went surprisingly smoothly. My deck--a brand new version created specifically for PASS--helped me get across the message I wanted to communicate, my demos ran without any failure, and my jokes didn't drive too many people out of the room before the end of the talk. <b>I even received a round of applause when I managed to take a 26 minute query plan and, using a few query rewrites, deliver the same exact data in 9 seconds</b>. That, I have to say, was pretty cool.</p><p>Here's the abstract for the session:</p><blockquote><p><b>Query Tuning Mastery: The Art and Science of Manhandling Parallelism</b> <br></p><p><span>As a database developer, your job boils down to one word:
performance. In today's multi-core-driven world, query performance is
very much determined by how well you're taking advantage of the
processing power at your disposal. Are your big queries using every
clock tick, or are they lagging behind? And if your queries are already
parallel, can they be rewritten for even greater speed?
<br>
<br>In this session, you'll learn to take full advantage of SQL Server
query parallelism. After a terminology review and technology refresher,
the session will go deep, covering T-SQL patterns that allow certain
queries to scale almost linearly across your multi-core CPUs. You'll see
when and why the optimizer makes a parallel plan choice and how to
impact the decision. Along the way, you’ll manipulate costs and row
goals, challenge generally accepted tuning practices, and take complete
control of your parallel queries.</span> <br></p></blockquote><p>Since the talk was being broadcast live on "PASS TV," I had <a href="http://sqlblog.com/blogs/paul_white/">Paul White</a> join me at the front of the room to moderate questions delivered via Twitter. This worked out reasonably well and I hope to do something similar in the future. <b>Huge thanks to Paul for helping out -- and for giving me a really ugly scowl when one of my jokes fell totally flat</b>.<br></p><p><b>Demos for the talk are attached.</b> Let me know if you have any questions.</p><p><b>Thanks again to everyone who watched, either in person or at home. I had a blast. Hope you enjoyed it even half as much as I did!</b> <br></p>PASS Summit 2011 - Zen and the Art of Workspace Memory - Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2011/10/16/pass-summit-2011-zen-and-the-art-of-workspace-memory-demos.aspxMon, 17 Oct 2011 00:23:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39085Adam Machanic<p><b>What a rush</b>. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes went by in a flash. I wish I'd been able to take 90 more!</p><p>The scene? <span style="font-weight:bold;">PASS Summit 2011</span>. Friday, October 14, 10:15 a.m. (Room 6E, to be exact.) The last day of one of the best PASS Summits I've had the pleasure of attending.</p><p>The topic? A fairly obscure area of SQL Server, called <b>workspace memory</b>. Here's the abstract for the talk:</p><blockquote><p><b>Query Tuning Mastery: Zen and the Art of Workspace Memory</b></p><p>As SQL Server professionals, we often think of memory in vague, instance-level terms: buffer pool, procedure cache, Virtual Address Space, and so on. But certain tasks require a more in-depth focus, and query tuning is one of them. Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes. This session will teach you how to guide the query processor to grant enough memory for top performance, while also keeping things balanced for the sake of concurrency. You will learn advanced monitoring techniques, expert-level application of specialized query hints, and the memory internals needed to put it all together. If you work with large queries and are serious about achieving scalability and consistently great performance, you owe it to yourself to attend this session. </p></blockquote><p>If you were in the audience,<b> I thank you for choosing my session </b>over the many others that were running concurrently. I had a great time, and I hope you did too.</p><p>The <b>demos </b>for the talk are attached to this post. Apologies, but I am not sharing the deck at this time as I'm going to be integrating it into a larger course that I hope to start delivering next year. (Through <a href="http://dataeducation.com/">Data Education</a>, naturally!)<br></p><p><b>Enjoy!</b> And as always, let me know in the comments if you have any questions.<br></p>