SQL Server Practical Performance Troubleshooting

SQL Masters Consulting is a Brisbane based SQL Server Consultancy business focusing primarily on SQL Server which allows for an in-depth knowledge of the product stack. SQL Masters Consulting can undertake a range of activities from the Architectural Design of SQL Server High Availability solutions, Performance Tuning, Troubleshooting, Upgrades and Migrations, Data Integration, Reporting, DevOPs for the Database and Training.SQL Masters Consulting gives back to the SQL Server Community by participating as conference speakers as well as speaking at local SQL Server user groups and SQLSaturday events across Australia, New Zealand, India, Singapore, USA & Canada.

SQL Masters Consulting

<P><SPAN>Practical Performance Troubleshooting Pre-Con is designed for the working SQL Server professional 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 performance areas.</SPAN></P>
<P CLASS="MsoNormal"><SPAN> <SPAN><SPAN>An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting. Basic to Intermediate level, covering important aspects.</SPAN> <SPAN>Topics Include: </SPAN></SPAN></SPAN></P>
<P CLASS="MsoNormal"><SPAN><SPAN><SPAN><SPAN>Module 1: </SPAN></SPAN></SPAN></SPAN></P>
<UL>
<LI>
<DIV CLASS="MsoNormal"><SPAN><SPAN><SPAN><SPAN>CPU Troubleshooting (Scheduling)</SPAN></SPAN></SPAN></SPAN></DIV>
</LI>
<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"><SPAN> <SPAN>Module 2: IO Troubleshooting</SPAN></SPAN></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> <SPAN>Module 3: Memory Troubleshooting</SPAN></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"><SPAN> <SPAN>Module 4: Tempdb Troubleshooting</SPAN></SPAN></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> <SPAN>Module 5: Dealing with Deadlocks</SPAN></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"><SPAN> <SPAN>Module 6: Troubleshooting Indexes</SPAN></SPAN></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"><SPAN> </SPAN></P>
<P CLASS="MsoNormal"><SPAN>Pre-Con Takeaways:</SPAN></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 CLASS="MsoNormal"><SPAN> <SPAN> </SPAN></SPAN></P>
<P CLASS="MsoNormal"><SPAN>Additional Notes</SPAN></P>
<P>Most training programs, theoretical or practical, lac real-world examples. In this pre-con, an attendee will learn real world performance troubleshooting skills with SQL Server. I am emphasizing on real-world & practical skills.<BR></P>
<P><BR></P>
<H2>About the Speaker</H2>
<P><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. </SPAN></SPAN></SPAN></P>
<P><SPAN><SPAN><SPAN>He frequently speaks at international conferences including MS Ignite, SQLBits, SSGAS/DPS, PASS Summit. </SPAN></SPAN></SPAN></P>
<P><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. 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></P>

SQL Server Practical Performance Troubleshooting

More events from SQL Masters Consulting

Discover more events from SQL Masters Consulting, from Science & Tech to other experiences you might love.

Still looking for the right event?

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

SQL Server Practical Performance Troubleshooting

More events from SQL Masters Consulting

Discover more events from SQL Masters Consulting, from Science & Tech to other experiences you might love.

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 Brisbane City and filter by date, category, and more to find the perfect fit.