{"id":5475,"date":"2018-06-16T13:27:44","date_gmt":"2018-06-16T12:27:44","guid":{"rendered":"http:\/\/andreas-wolter.com\/?p=5475"},"modified":"2018-06-21T19:28:03","modified_gmt":"2018-06-21T18:28:03","slug":"1806_precon_performance_analysis_asia_australia_2018","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/1806_precon_performance_analysis_asia_australia_2018\/","title":{"rendered":"Full day PreCon Practical Performance Analysis in Melbourne at Asia &#038; Australia Tour 2018"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-c07ec1a9d3a1f8975fbc152fb4fe2256\">\n#top .av-special-heading.av-av_heading-c07ec1a9d3a1f8975fbc152fb4fe2256{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-c07ec1a9d3a1f8975fbc152fb4fe2256 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-c07ec1a9d3a1f8975fbc152fb4fe2256 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-c07ec1a9d3a1f8975fbc152fb4fe2256 av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Full day PreCon Practical Performance Analysis in Melbourne at Asia <span class='special_amp'>&amp;<\/span> Australia Tour 2018<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>As it has almost become a habit by now for me, I will be touring Asia this summer. This year not only Asia, but for the first time also Australia. (There, however, is winter, which sometimes leads to funny confusion in agreements until you get used to this.)<\/p>\n<p><strong>1<sup>st<\/sup> stop: Singapore \u2013 Azure SQL Database Managed Instance<\/strong><!--more--><\/p>\n<p>As so often my first stop is Singapore. One of the most amazing cities &#038; countries on the planet. It\u2019s the elected <a href=\"https:\/\/www.channelnewsasia.com\/news\/singapore\/singapore-best-performing-smart-city-globally-study-10038722\" target=\"_blank\" rel=\"noopener\">\u201cmost performing smart city\u201d of the world 2017<\/a>. If you are in AI, Analytics, IoT or Big Data in general, this is the place to be and really get things done.<\/p>\n<p>The <a href=\"https:\/\/www.meetup.com\/AzureSG\/\" target=\"_blank\" rel=\"noopener\">Azure Community Singapore<\/a> (ACS) was so kind as to organize a special meeting on<br \/>\n<strong>Monday June 25<sup>th<\/sup><\/strong> <strong>at Microsoft Singapore<\/strong> (One Marina Boulevard, A22CF12, Level 22)<br \/>\nand I will be presenting on the new SQL Database Managed Instance: <strong>Azure SQL Database Managed Instance \u2013 The Better Alternative to Azure SQL Database or SQL Server in a VM?<\/strong><\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-46f9f491fdae8309388638f6b17c06b3\">\n.avia-image-container.av-av_image-46f9f491fdae8309388638f6b17c06b3 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-46f9f491fdae8309388638f6b17c06b3 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-46f9f491fdae8309388638f6b17c06b3 av-styling- avia-align-center  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-5476 avia-img-lazy-loading-not-5476 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore.png\" alt='' title='1806_Azure_SQL_Database_Managed_Instance_Singapore'  height=\"430\" width=\"757\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore.png 757w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore-600x341.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore-300x170.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore-705x400.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_Azure_SQL_Database_Managed_Instance_Singapore-450x256.png 450w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Please <strong>register here<\/strong>: <a href=\"https:\/\/www.meetup.com\/AzureSG\/events\/251643641\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.meetup.com\/AzureSG\/events\/251643641\/<\/a><\/p>\n<p><strong>2<sup>nd<\/sup> stop: Melbourne \u2013 Performance Analysis and Availability Group Performance<\/strong><\/p>\n<p>My first ever conference in Australia, and I am honored to be asked to deliver my 1-day workshop on Performance Analysis as a PreCon for the <strong><a href=\"http:\/\/www.sqlsaturday.com\/769\/EventHome.aspx\" target=\"_blank\" rel=\"noopener\">SQLSaturday Melbourne<\/a><\/strong><strong> on June 29th<\/strong>:<\/p>\n<p><strong>Practical SQL Server Performance Analysis<\/strong><\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-101cb3db542e1303ac5311b839438ac6\">\n.avia-image-container.av-av_image-101cb3db542e1303ac5311b839438ac6 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-101cb3db542e1303ac5311b839438ac6 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-101cb3db542e1303ac5311b839438ac6 av-styling- avia-align-center  avia-builder-el-4  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-5477 avia-img-lazy-loading-not-5477 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis.jpg\" alt='' title='1806_SQLSat_PreCon_Performance_Analysis'  height=\"396\" width=\"756\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis.jpg 756w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis-600x314.jpg 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis-300x157.jpg 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis-705x369.jpg 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat_PreCon_Performance_Analysis-450x236.jpg 450w\" sizes=\"(max-width: 756px) 100vw, 756px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>This full-day Precon will teach you techniques for general troubleshooting and performance analysis from\u00a0basic to advanced techniques. A highlight is the possibility to <strong>connect live to the Demo Server hosted on Azure<\/strong> via your local SSMS to analyze prepared scenarios on your own. This is probably the first ever PreCon with a continuously running workload for analysis by all attendees! We analyze a choice from the following scenarios:<\/p>\n<ul>\n<li>Investigating Memory Problems<\/li>\n<li>Identifying Plan Regression<\/li>\n<li>Analysis of Indexes &#038; Statistics<\/li>\n<li>Detecting I\/O Latency problems<\/li>\n<li>Investigating Tempdb Performance<\/li>\n<li>Locking &#038; Blocking Analysis, Concurrency problems<\/li>\n<\/ul>\n<p>Techniques &#038; Tools taught:<\/p>\n<ul>\n<li>SQL Server Architecture &#038; Internals<\/li>\n<li>Monitoring Methodology, Tools &#038; Techniques:<\/li>\n<li>Dynamic Management Views (DMVs)<\/li>\n<li>Wait Statistics<\/li>\n<li>Extended Events for Workload &#038; Query-Analysis<\/li>\n<li>Query Store<\/li>\n<li>By request: Overview on Third-Party tools<\/li>\n<\/ul>\n<p>Expect lots of demos and a deep dive into core concepts of SQL Server.<\/p>\n<p>You can <strong>register for it here<\/strong>: <a href=\"https:\/\/www.trybooking.com\/book\/event?embed&#038;eid=387459\" target=\"_blank\" rel=\"noopener\">https:\/\/www.trybooking.com\/book\/event?embed&#038;eid=387459<\/a><\/p>\n<p>The session has only been recently announced but is already filling up quickly. About 50% of the seats are booked already, just after the end of the early bird (June 15<sup>th<\/sup>)!<\/p>\n<p>At the SQLSaturday main conference day on June 30<sup>th<\/sup> I will also demonstrate the important performance indicators for Availability Groups in this session:<\/p>\n<p><strong><a href=\"http:\/\/www.sqlsaturday.com\/769\/Sessions\/Details.aspx?sid=80442\" target=\"_blank\" rel=\"noopener\">Troubleshooting Always On Availability Groups Performance<\/a><\/strong><\/p>\n<p><strong>3<sup>rd<\/sup> stop: Sydney \u2013 Availability Group Performance and Locking &#038; Blocking<\/strong><\/p>\n<p>The weekend after I will be in Sydney for the SQLSaturday conference and a User Group Meeting.<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-abbb38e5e07a7f672f6c845e6ef70e47\">\n.avia-image-container.av-av_image-abbb38e5e07a7f672f6c845e6ef70e47 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-abbb38e5e07a7f672f6c845e6ef70e47 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-abbb38e5e07a7f672f6c845e6ef70e47 av-styling- avia-align-center  avia-builder-el-6  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-5478 avia-img-lazy-loading-not-5478 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat771_Sydney.png\" alt='' title='1806_SQLSat771_Sydney'  height=\"41\" width=\"262\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat771_Sydney.png 262w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2018\/06\/1806_SQLSat771_Sydney-260x41.png 260w\" sizes=\"(max-width: 262px) 100vw, 262px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>On <strong>July 7<sup>th<\/sup><\/strong> at <strong><a href=\"http:\/\/www.sqlsaturday.com\/771\/eventhome.aspx\" target=\"_blank\" rel=\"noopener\">SQLSaturday Sydney<\/a><\/strong> I will again present on Availability Groups:<\/p>\n<p><strong><a href=\"http:\/\/www.sqlsaturday.com\/771\/Sessions\/Details.aspx?sid=80336\" target=\"_blank\" rel=\"noopener\">Troubleshooting Always On Availability Groups Performance<\/a><\/strong><\/p>\n<p>On <strong>July 10<sup>th<\/sup><\/strong> I will present at the<strong><a href=\"https:\/\/www.meetup.com\/Sydney-SQL-Server-User-Group\/\" target=\"_blank\" rel=\"noopener\"> Sydney SQL Server User Group<\/a><\/strong> on another very technical topic: Locking &#038; Blocking.<\/p>\n<p>You can register here: <strong><a href=\"https:\/\/www.meetup.com\/Sydney-SQL-Server-User-Group\/events\/251642083\/\" target=\"_blank\" rel=\"noopener\">From Locks to No Locks \u2013 Concurrency in SQL Server<\/a><\/strong><br \/>\n<br class=\"\u201cclear\u201c\" \/><\/p>\n<p><strong>4<sup>th<\/sup> stop: Hong Kong \u2013 Security<\/strong><\/p>\n<p>And for the final stopover in Hong Kong, I will be presenting for the HK Microsoft MVP Reconnect and MVP Community on <strong>July 13<sup>th<\/sup><\/strong>. Topic: <strong>SQL Server Security<\/strong><\/p>\n<p>You can register here: <a href=\"https:\/\/www.facebook.com\/events\/659587234386024\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.facebook.com\/events\/659587234386024\/<\/a><\/p>\n<p>With 16.473 km or 10.236 miles from Frankfurt to Sydney this is the longest trip for me so far.<\/p>\n<p>Special thanks to all the organizers of the various user groups or conference committees for inviting me to present. In no particular order I would like to mention:<\/p>\n<p>Goh Chun Lin from Singapore, Martin Cairney and Martin Catherall from Melbourne, Grant Paisley and Victor Isakov from Sydney, Dominic Lee, Ken Lin and Jacky Yau from Hong Kong.<\/p>\n<p>Thank you for you very unbureaucratic and sometimes super spontaneous organization for Event Locations and more. Some of them made it happen within a matter of less than a week. Great spirit.<\/p>\n<p>In that sense: I hope to meet many enthusiasts like you at these events. When you see me, come and say Hello.<\/p>\n<p>One week until takeoff..<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-8  el_after_av_textblock  el_before_av_one_full '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-97c650ae075063b375f558a776c570f8\">\n#top .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n.flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n.responsive #top #wrap_all .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-97c650ae075063b375f558a776c570f8 av_one_full  avia-builder-el-9  el_after_av_hr  el_before_av_social_share  first flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><div><\/div>\n<div><\/div>\n<\/div><\/section><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-11  el_after_av_one_full  el_before_av_hr  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/1806_precon_performance_analysis_asia_australia_2018\/&#038;t=Full%20day%20PreCon%20Practical%20Performance%20Analysis%20in%20Melbourne%20at%20Asia%20%26%20Australia%20Tour%202018\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=Full%20day%20PreCon%20Practical%20Performance%20Analysis%20in%20Melbourne%20at%20Asia%20%26%20Australia%20Tour%202018&#038;url=https:\/\/andreas-wolter.com\/en\/?p=5475\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Full%20day%20PreCon%20Practical%20Performance%20Analysis%20in%20Melbourne%20at%20Asia%20%26%20Australia%20Tour%202018&#038;url=https:\/\/andreas-wolter.com\/en\/1806_precon_performance_analysis_asia_australia_2018\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-4474f20d2389e2e5ecf918a02da5132e\">\n#top .hr.hr-invisible.av-av_hr-4474f20d2389e2e5ecf918a02da5132e{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-av_hr-4474f20d2389e2e5ecf918a02da5132e hr-invisible  avia-builder-el-12  el_after_av_social_share  el_before_av_comments_list '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"As it has almost become a habit by now for me, I will be touring Asia this summer. This year not only Asia, but for the first time also Australia. (There, however, is winter, which sometimes leads to funny confusion in agreements until you get used to this.) 1st stop: Singapore \u2013 Azure SQL Database [&hellip;]","protected":false},"author":4,"featured_media":5477,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[124,97,98,42,43,57],"tags":[170,24,324,19,27,232],"class_list":["post-5475","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-conferences-en","category-hadr-alwayson-en","category-locking-blocking","category-performance","category-security-en","tag-alwayson-en","tag-conference-en","tag-locking-blocking","tag-performance-analysis-en","tag-security-en","tag-sicherheit-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/5475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=5475"}],"version-history":[{"count":6,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/5475\/revisions"}],"predecessor-version":[{"id":5481,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/5475\/revisions\/5481"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/5477"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=5475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=5475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=5475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}