SQL Admin Best Practices with DMVs – William Assaf
In this practical and script-focused session, with roots in SQL 2005 but updated continuously thru SQL 2019, we’ll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV’s are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.
William Assaf:
@william_a_dba
linkedin.com/in/williamdassaf
William Assaf is a senior content developer on the SQLDocs team at Microsoft. Formerly a Data Platform MVP and a consultant for SQL Server, and before that a .NET developer, William currently works with Microsoft product groups on content related to the SQL database platform, specifically for SQL performance, Big Data Clusters, and Azure SQL DB. As a consultant for 13 years he worked with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and led a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the team lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a past lead of the annual SQLSaturday Baton Rouge Planning Committee and supports the Baton Rouge User Groups.
Slides: SQLTact.com
Labs: github.com/sparkhoundsql/sql-servre-toolbox
Resources:
https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
http://www.sqlskills.com/BLOGS/PAUL/post/Why-did-the-Windows-7-RC-failure-happen.aspx
http://technet.microsoft.com/en-us/library/cc966413.aspx
http://msdn.microsoft.com/en-us/library/ms188917.aspx
http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!1446.entry
http://sharmilasanctuary.wordpress.com/about/database-performance-dmvs-for-ms-sql-2005/
http://sqlblog.com/blogs/kevin_kline/archive/2009/04/07/looking-for-good-dmv-database-admin-queries.aspx
http://blogs.msdn.com/jimmymay/archive/2008/10/30/drum-roll-please-the-debut-of-the-sql-dmv-all-stars-dream-team.aspx
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.aspx
http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
http://www.sqlservercentral.com/articles/DMV/64425/
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-sysdm_db_index_physical_stats.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Indexes-From-Every-Angle-How-can-you-tell-if-an-index-is-being-used.aspx
http://kswain.blogspot.com/2008/04/sysdmosperformancecounters-dynamic.html
http://www.sqlpassion.at/archive/2014/11/24/deadlocks-caused-by-missing-indexes-in-sql-server
http://www.sql-server-performance.com/articles/per/bm_performance_dashboard_2005_p2.aspx
http://msdn.microsoft.com/en-us/library/aa366541%28VS.85%29.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2011/04/25/more-changes-you-might-not-have-noticed-in-the-sql-server-2008-r2-sp1-ctp.aspx
http://www.sqlskills.com/BLOGS/PAUL/category/Spinlocks.aspx
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-log-info-transact-sql?view=sql-server-2017
https://www.sqlshack.com/sql-server-2019-new-dmf-sys-dm_db_page_info/
– DBAFun.org
– DBAFuntube.org
– @SteveZCantrell – Steve Cantrell
– @SODBA – Shane O’Neill
– @Oskaruth – Kevin Wilkie
Comments are closed.