SQL Server Performance Tuning for DBAs/Developers

SQLSaturday Wellington #809

<P CLASS="MsoNormal"><STRONG>Amit Bansal presents "SQL Server Performance Tuning for DBAs" Pre-Con</STRONG></P>
<P CLASS="MsoNormal"><SPAN>‘SQL Server Performance Tuning for DBAs’ Pre-Con is designed for the working SQL Server DBA who has the relevant experience with SQL Server and only needs practical examples of troubleshooting SQL Server performance that can be applied in production right away. In this full-day training, participants will see relevant, crisp, real-world examples of common areas related to performance tuning. An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting. Basic to Intermediate level, covering important aspects.</SPAN></P>
<P CLASS="MsoNormal"><STRONG>Module 1: CPU Troubleshooting (Scheduling)</STRONG></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Query Lifecycle</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Common Scheduler Wait Types in SQL Server, identification & diagnosis</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>CPU Performance Troubleshooting</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Identifying workload patterns that cause excessive CPU</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Important DMVs & Performance Counters</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><STRONG>Module 2: IO Troubleshooting</STRONG></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Understanding SQL Server IO patterns</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Troubleshooting IO bottlenecks using DMVs</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Troubleshooting IO bottlenecks using Performance Counters</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Troubleshooting IO bottlenecks using Wait Types</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Identifying workloads that cause excessive IO</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><SPAN><STRONG>Module 3: Memory Troubleshooting</STRONG></SPAN></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>SQL Server Memory Architecture – Welcome To The Dungeon</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Internal vs External Memory Pressure</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Understanding Memory Errors</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Troubleshooting Memory Issues</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Identifying workloads that cause excessive memory usage</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Memory Wait Types</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Understanding Query Workspace Memory</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><STRONG>Module 4: Tempdb Troubleshooting</STRONG></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Common issues with Tempdb and resolutions</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Identifying workloads that cause maximum Tempdb usage</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Tips/Tricks with Tempdb to improve performance</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><SPAN><STRONG>Module 5: Dealing with Deadlocks</STRONG></SPAN></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Common Deadlock Types</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Deadlock Best Practices</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Practical Deadlock Troubleshooting & Diagnosis</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><STRONG>Module 6: Troubleshooting Indexes</STRONG></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Demystifying Common Myths with Indexes</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Indexing Strategies</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Real-World Index Tuning Examples</SPAN></DIV>
</LI>
</UL>
<P CLASS="MsoNormal"><STRONG>Pre-Con Takeaways:</STRONG></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Practical, Real-World Examples</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>All Demo Scripts</SPAN></DIV>
</LI>
<LI>
<DIV CLASS="MsoNormal"><SPAN>Loads of learning that can be applied into production right-away</SPAN></DIV>
</LI>
</UL>
<P><SPAN><STRONG>Note:</STRONG><SPAN> These will be paid events and note also that as we are a small not-for-profit association we are not GST registered and therefore do not issue Tax Receipts for these registrations.</SPAN></SPAN></P>
<P><SPAN><STRONG>About Amit Bansal</STRONG></SPAN></P>
<P><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN>Amit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit (India), MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P>
<P><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN>Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on <A HREF="http://www.youtube.com/SQLMaestros" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">www.youtube.com/SQLMaestros</A>. </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P>
<P><SPAN><SPAN><SPAN><SPAN><SPAN><SPAN>To learn more about Amit, visit <A HREF="http://sqlmaestros.com/amit-bansal/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">http://sqlmaestros.com/amit-bansal/</A></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P>
<P> </P>

SQL Server Performance Tuning for DBAs/Developers

More events from SQLSaturday Wellington #809

Follow organizers to get events picked for you

Still looking for the right event?

Explore all events in Porirua and filter by date, category, and more to find the perfect fit.

SQL Server Performance Tuning for DBAs/Developers

More events from SQLSaturday Wellington #809

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Porirua and filter by date, category, and more to find the perfect fit.