Search results matching tags 'SQL Saturday' and 'Performance'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+Saturday,Performance&orTags=0Search results matching tags 'SQL Saturday' and 'Performance'en-USCommunityServer 2.1 SP2 (Build: 61129.1)SQL Saturday Chicago (#291) - Clash of the Row Goals - Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2014/04/26/sql-saturday-chicago-291-clash-of-the-row-goals-demos.aspxSat, 26 Apr 2014 19:37:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:53755Adam Machanic<p>Thank you to everyone who joined me today at SQL Saturday Chicago for my "Clash of the Row Goals" session. I'm honored that so many people would attend a talk with such an incredibly arcane title -- and always glad to find a curious, interested, and intelligent audience.</p><p>The demos I showed during the session are attached to this post. If you have any followup questions, feel free to leave a comment below.</p><p>Enjoy! <br></p>SQL Saturday Chicago...and the Gentle Art of Planscaping!http://sqlblog.com/blogs/adam_machanic/archive/2014/04/02/sql-saturday-chicago-and-the-gentle-art-of-planscaping.aspxWed, 02 Apr 2014 21:31:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:53449Adam Machanic<p>Three weeks from now I'll be visiting Chicago to participate in SQL Saturday. I'll offer two different learning opportunities:<br></p><p>On Friday, April 25, <a href="http://www.eventbrite.com/e/sql-saturday-291-pre-seminar-better-performance-through-parallelism-with-adam-machanic-tickets-10363538623" mce_href="http://www.eventbrite.com/e/sql-saturday-291-pre-seminar-better-performance-through-parallelism-with-adam-machanic-tickets-10363538623"><b>you can join me for a full day seminar on parallelism and performance in SQL Server</b></a>. This class covers in-depth background on the hows and whys behind SQL Server's parallel processing, followed by an investigation of advanced techniques that you can use to improve performance of some queries by an order of magnitude or more. <b>The class is filling up, so make sure to register soon!</b></p><p>On Saturday, April 26, I'll deliver my newest talk, "<a href="http://sqlsaturday.com/viewsession.aspx?sat=291&amp;sessionid=20874" mce_href="http://sqlsaturday.com/viewsession.aspx?sat=291&amp;sessionid=20874">Clash of the Row Goals</a>." I unveiled it the first time this past weekend at SQL Saturday Boston, and <a href="http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/bushy-joins.aspx" mce_href="http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/bushy-joins.aspx">Joe Chang happened to blog about it a few hours ago</a>. In this talk you'll learn how to shape and modify query plans by leveraging an understanding of query optimizer internals -- without using query hints. I've decided to call this technique <b>planscaping</b>. The idea is to create beautiful query plans that perform well and don't break at unexpected times. That's a good thing, right?</p><p>Hope to see you in Chicago!</p><p><br></p>Demos: SQL Saturday Boston (#262) - Clash of the Row Goals!http://sqlblog.com/blogs/adam_machanic/archive/2014/03/30/demos-sql-saturday-boston-262-clash-of-the-row-goals.aspxMon, 31 Mar 2014 01:14:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:53394Adam Machanic<p>Thanks to everyone who joined me yesterday afternoon in Cambridge for my Clash of the Row Goals talk. It was great to receive such a welcome reception for a rather out there topic.</p><p>Three things I should clarify for those who attended:</p><ul><li>The Many() function appeared to create an invalid estimate in one case; but that was due to auto-parameterization (which one of the attendees in the front row correctly called out at the time; but I'm not sure everyone heard her)</li><li>Regarding the demo that failed at the end: As it turns out -- it didn't! I was a bit under-caffeinated and misunderstood my own notes. I've updated the scripts to make things clearer.</li><li>I blamed the demo failure, jokingly, on Azure. Turns out at least one attendee took me seriously; it showed up on a feedback card. Fact is, I was running the entire show from my laptop. My head might have been in the clouds, but my demos were strictly on terra firma.</li></ul><p>The demo scripts are attached. Enjoy, and let me know if you have any questions or comments. I'd especially love to hear how it goes if you decide to try any of these techniques on one of your problem queries.<br></p>Query Performance and Parallelism Seminars in Boston and Chicagohttp://sqlblog.com/blogs/adam_machanic/archive/2014/01/30/query-performance-and-parallelism-seminars-in-boston-and-chicago.aspxThu, 30 Jan 2014 17:03:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:52711Adam Machanic<p>You're a DBA or database developer working on a big (or even big-ish -- doesn't have to be huge) database. Your end-users are doing all sorts of data analysis, and even though you have a pretty beefy server, <b>your queries just don't seem to run as fast as they should</b>.</p><p>The reason (I bet)? <b>Your queries aren't taking full advantage of the CPU power available in today's servers</b>. SQL Server has powerful parallel processing capabilities, but left to its own devices (and defaults) you're never going to see the full potential. Luckily, this can be fixed. You can make your queries much faster. (Often an order of magnitude or more!) And I can show you how.</p><p>Join me in Boston or in Chicago, the Friday before the upcoming SQL Saturday events in those cities, and we'll go deep into parallel processing. You'll learn about Windows server and how it deals with processes and threads, about SQLOS and its thread scheduling internals, how the SQL Server query processor works, and how you can use all of this knowledge to make your queries run faster and your server behave more consistently, even under load.</p><p>These full-day seminars cost only $150 and include lunch, coffee, and a printed course book -- plus a full day of intense content.</p><p>Full information, including an outline and registration details, is available at the links below:<br></p><ul><li><b>Boston</b> - Friday, March 28, 2014 - <a href="http://parallelboston.eventbrite.com/" mce_href="http://parallelboston.eventbrite.com/">http://parallelboston.eventbrite.com</a> - Prior to <a href="http://sqlsaturday.com/262/" mce_href="http://sqlsaturday.com/262/">SQL Saturday #262</a><a href="http://parallelboston.eventbrite.com/" mce_href="http://parallelboston.eventbrite.com/"><br></a></li><li><b>Chicago</b> - Friday, April 25, 2014 - <a href="http://parallelchicago.eventbrite.com" mce_href="http://parallelchicago.eventbrite.com">http://parallelchicago.eventbrite.com</a> - Prior to <a href="http://sqlsaturday.com/291/" mce_href="http://sqlsaturday.com/291/">SQL Saturday #291</a></li></ul><p>Hope to see you there!<br></p>SQL Saturday #220 (Atlanta): Demoshttp://sqlblog.com/blogs/adam_machanic/archive/2013/05/18/sql-saturday-220-atlanta-demos.aspxSat, 18 May 2013 18:33:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:49114Adam Machanic<p><b>Today at SQL Saturday #220 in Atlanta I presented a new brand new session</b>, "SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches." </p><p>This session is designed to help people quickly analyze query plans and find likely culprits without being query tuning experts; I find that in a huge number of cases the root cause of problems is one of just a few potential situations.<br></p><p>Thanks to everyone who joined me today for the deliveries! In addition to it being a new session this was also the first time that I've ever been asked to present the same session twice in a single day. So it was quite an experience.</p><p><b>The demo script is attached</b>. As always, let me know if you have any questions or comments.</p><p>Enjoy! <br></p>SQL Saturday 89 - Atlanta GA - Materialshttp://sqlblog.com/blogs/adam_machanic/archive/2011/09/24/sql-saturday-89-atlanta-ga-materials.aspxSat, 24 Sep 2011 16:57:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:38712Adam Machanic<p>Last Saturday, September 17, I was lucky to be able to present two sessions at an <a href="http://sqlsaturday.com/89/eventhome.aspx">excellent SQL Saturday</a> in the Atlanta area. The day drew a large crowd and had a great speaker lineup. All in all, a huge success, and a very well-managed event. Congratulations to the organizers!</p><p>One of the highlights for me, aside from speaking, was helping out with logistics the night before and <b>creating a cocktail</b> for the event. <a href="http://datachix.com/2011/09/19/the-89-official-cocktail-of-sql-saturday-89/">Check out Audrey Hammonds's blog</a> for details. <br></p><p>My two sessions were:</p><blockquote><p>"SQL Server Parallelism and Performance"</p><p><span id="ContentPlaceHolder1_lblDescription">Over the past five years,
multi-core processors have made the jump from semi-obscure to
commonplace in the data center. Today we regularly expect to see 16, 32,
or 64 cores in even our lower-end servers. Are you getting everything
you can out of the wealth of processing power at your disposal? Attend
this session to take a detailed look at how and why SQL Server processes
queries in parallel, as well as methods for controlling parallel
processing via configuration options, the Resource Governor, and
query-level hints. This session will enable you to immediately evaluate,
understand, and improve the state of parallel processing on your
servers.</span></p></blockquote><p>and</p><blockquote><p>&nbsp;"15 Powerful SQL Server Dynamic Management Objects"</p><p><span id="ContentPlaceHolder1_lblDescription">The Dynamic Management
Objects--a set of views and functions that first shipped with SQL Server
2005--are a window into the inner workings of your SQL Server instance.
Locked within is the data you need to help solve virtually any
performance problem, quickly debug issues, and gain insight into what's
actually happening on your server, right now. This session is a
fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of
the most important views and functions--information gleaned from heavy
use of the objects in a number of environments. You will learn how to
understand transaction behavior, locking, wait statistics, sessions,
requests, and much more. Attend this session and you will be the master
of your SQL Server instance.</span></p></blockquote><p><span style="font-weight:bold;">I promised to share the slides and demos from the second session</span>, and those are attached to this post.</p><p>&nbsp;</p><p><b>Many thanks to everyone who attended my sessions</b> and for all of the positive feedback I received! (I would also thank anyone who gave me negative feedback, but in this case the worst I received was that I had a typo on one of my slides.) I had a great time, and hope to return to Atlanta again sometime soon.<br></p>Where Can You Find Me the Rest of This Year?http://sqlblog.com/blogs/adam_machanic/archive/2011/08/21/where-can-you-find-me-the-rest-of-this-year.aspxMon, 22 Aug 2011 00:28:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37983Adam Machanic<p>Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year:</p><p>&nbsp;</p><p><b>September 8, 17:00 GMT (online)</b> - <a href="http://www.sqlpass.org/24hours/fall2011/SessionsbySchedule/BaselineBasicsorWhoBroketheDatabase.aspx">24 Hours of PASS webcast: "Baseline Basics or: Who Broke the Database?"</a></p><blockquote><p>In this session, excerpted from my PASS Summit precon, I'll explain the whys and hows of using baselines to assist with performance tuning. <b>If you find yourself more often than not tuning <i>reactively </i>rather than <i>proactively</i></b>, this session is for you. This is a free webcast, so why not join in?<br></p></blockquote><p>&nbsp;</p><p><b>September 8, 18:30 EDT (Waltham, MA)</b> - <a href="http://nesql.org/">New England SQL Server Users Group: "Windowing Functions in SQL Server 2008, Denali, and Beyond"</a></p><blockquote><p>Two in one day! This session will kick off the 2011/2012 New England SQL Server season, and will cover what are (in my ever-so-humble opinion) <b>the most important T-SQL enhancements in the past three versions of SQL Server</b>: windowing function enhancements. I'll discuss what's there in today's shipping versions, and the new and incredibly powerful functionality that Denali brings to the table. If you're in the Boston area, don't miss it!</p><p>&nbsp;</p></blockquote><p><b>September 17 (Atlanta, GA)</b> - <a href="http://sqlsaturday.com/89/schedule.aspx">SQL Saturday #89: (Two Talks) </a></p><blockquote><p>After the great time I had at this year's TechEd show in Atlanta I could hardly wait to get back. Luckily,<b> the fantastic SQL Server community in the Atlanta area</b> scheduled this event, which gave me the perfect excuse to pack my bags for a return trip. The speaker lineup for this event is rock-solid, and I'll be contributing with two talks: my introductory dive into SQL Server parallelism, and an overview of my 15 favorite activity monitoring dynamic management objects. This should be a great event by anyone's standards, and it's <i>free</i>, so if you live nearby you have literally no excuse not to attend.<br></p></blockquote><blockquote><p>&nbsp;</p></blockquote><p><b>October 11,&nbsp; 08:30 PDT (Seattle, WA) -</b> <a href="http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1627">PASS Community Summit Pre-Conference Seminar: No More Guessing! An Enlightened Approach to Performance Troubleshooting</a></p><blockquote><p><b>No more guessing! It's not just a catchphrase; it's a way of life</b>. When faced with performance problems we have a choice: we can either run around panicking, wasting everyone's time (including our own), or we can use the huge amount of information at our disposal to figure out what's <i>actually</i> wrong and fix it. As the calm and collected type, I prefer the second option, and so should you. If you'll be attending the PASS conference, join me on Tuesday to learn how you, too, can quickly and accurately pinpoint the root cause of your performance issues.</p></blockquote><p>&nbsp;</p><p><b>October 12-14 (Seattle, WA)</b> - <a href="http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1256">PASS Community Summit Spotlight Session: Query Tuning Mastery: Zen and the Art of Workspace Memory</a></p><blockquote><p>Your query is running, and it needs to sort some data. Or to hash some data. Or to perform a parallel operation. These things take memory, and as any SQL Server professional knows, <b>in the world of SQL Server memory is worth much, much more than its weight in gold</b> (even given today's hugely-inflated prices). Attend this session to learn the ins and outs of workspace memory: what it is, why it's needed, where the memory comes from, and most importantly, how to control it to make certain queries faster and other queries not have to wait as long. Workspace memory tuning is a mostly untapped performance opportunity that many DBAs can heavily benefit from learning how to leverage. <br></p><p>&nbsp;</p></blockquote><p>&nbsp;<b>November 1-3 (Las Vegas, NV)</b> - <a href="http://www.devconnections.com/shows/fall2011/sessions.aspx?s=179">SQL Server Connections: (Three Talks)</a></p><blockquote><p>My final speaking engagement of the year will be <b>at the always-fun SQL Server Connections show in Vegas</b>. (It's in Vegas! How could it not be fun?!) I'll be doing three talks during the course of the show: An introductory talk on my favorite topic the past couple of years, parallelism in SQL Server; a much more advanced parallelism talk to build on that one; and a talk on the various dynamic management objects that can be used in the quest for ultimate SQL Server performance. Save a spot for me at the poker table!</p></blockquote><p>&nbsp;</p><p><b>I'm really looking forward to these events.</b> If you're going to be there let me know in the comments, and/or feel free to find me at any of the shows and say hi. (Buying me a drink or two wouldn't hurt either.) See you there! <br></p>