We may earn an affiliate commission when you visit our partners.
SQL Server 2017
Diagnosing Configuration Issues with DMVs
Glenn Berry
Glenn Berry
Learn how to easily query SQL Server 2017 for configuration information to help identify misconfigurations that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.
Read more
Learn how to easily query SQL Server 2017 for configuration information to help identify misconfigurations that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.
Read more
Learn how to easily query SQL Server 2017 for configuration information to help identify misconfigurations that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.
It is very common for SQL Server instances to be configured incorrectly in one or more ways, and this often has a detrimental effect on workload performance and stability. In this course, SQL Server 2017: Diagnosing Configuration Issues with DMVs, you will see more than 30 DMV queries you can use to easily examine SQL Server instance and database configuration information. First, you will learn how to detect and correct many common configuration issues with your hardware, storage, operating system, SQL Server instance, and your database properties. Then, you will be given the best practices for properly checking an instance of SQL Server for configuration issues, both at the instance-level and at a database level. Finally, you will see the configuration settings that you can use to have a more reliable and better performing SQL Server environment. By the end of this course, you will be able to find and correct the most common SQL Server configuration issues. This course is perfect for anyone who is responsible for a SQL Server 2017 instance, with most topics also applicable to SQL Server 2016 and earlier versions.
Register for this course and see more details by visiting:
OpenCourser.com/course/b5j474/sql
What's inside
Syllabus
Course Overview
Introduction
Diagnosing Hardware and Storage Configuration Issues
Diagnosing Operating System Configuration Issues
Read more
Syllabus
Course Overview
Introduction
Diagnosing Hardware and Storage Configuration Issues
Diagnosing Operating System Configuration Issues
Read more
Diagnosing SQL Server Instance-level Configuration Issues
Diagnosing SQL Server Database-level Configuration Issues
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Teaches a broad range of skills relevant to the work of a professional database administrator
Thoroughly examines configuration issues with SQL Server 2017 and earlier versions
Taught by Glenn Berry, a recognized expert on SQL Server performance and stability
Suitable for beginners and experienced SQL Server administrators alike
Provides a comprehensive overview of SQL Server configuration management
May require prior knowledge of SQL Server administration for some learners
Save this course
Save SQL Server 2017: Diagnosing Configuration Issues with DMVs to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server 2017: Diagnosing Configuration Issues with DMVs with these
activities:
Review Hardware and Network Considerations
Show steps
Ensure a solid foundation in hardware and network concepts
Browse courses on
Hardware
Show steps
-
Revisit basic principles of computer hardware and networking
-
Review best practices for SQL Server hardware and network configuration
Review SQL Server terminology
Show steps
Review SQL Server terminology to remind yourself of the key jargon that will be used throughout this course.
Browse courses on
Relational Database Management Systems
Show steps
-
Visit Microsoft Learn: SQL Server terminology
-
Read through the introduction and concepts pages
-
Complete the online quiz: SQL Server terminology
Review SQL Concepts
Show steps
Refresh basic understanding of SQL Server through reviewing previous knowledge
Browse courses on
SQL
Show steps
-
Review SQL Basics
-
Create a sample database in SQL Server
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Review database principles
Show steps
Review database principles to refresh your understanding of the fundamental concepts that underpin SQL Server.
Browse courses on
Database Normalization
Show steps
-
Visit SQL Server training: Database fundamentals
-
Review the following modules:
-
Database design basics
-
Database normalization
-
Database integrity
-
Take the assessment quiz
Join a SQL Server Study Group
Show steps
Enhance understanding and learn from others through peer discussions
Show steps
-
Find a study group or create one
-
Attend the study sessions and engage in discussions
-
Collaborate on projects or assignments
Understand SQL Server Diagnostic Information Management (DIM)
Show steps
You can explore guided tutorials to understand how to use SQL Server Diagnostic Information Management (DIM) to collect and analyze diagnostic information for troubleshooting SQL Server issues.
Show steps
-
Find tutorials on SQL Server DIM
-
Follow the tutorials
Join a SQL Server user group
Show steps
Join a SQL Server user group to connect with other professionals, learn from their experiences, and stay up-to-date on the latest trends.
Browse courses on
Networking
Show steps
-
Search for SQL Server user groups in your area
-
Attend a user group meeting
-
Introduce yourself and share your interests
-
Participate in discussions and ask questions
-
Connect with other members on LinkedIn
Volunteer at a SQL Server conference
Show steps
Volunteer at a SQL Server conference to gain practical experience, network with professionals, and contribute to the community.
Browse courses on
Volunteering
Show steps
-
Search for SQL Server conferences in your area
-
Contact the conference organizers
-
Express your interest in volunteering
-
Attend the conference and fulfill your volunteer responsibilities
-
Network with attendees and speakers
Run queries against DMV tables
Show steps
You can practice running queries against commonly used DMV tables to identify performance issues.
Show steps
-
Install a SQL Server Management Studio (SSMS) tool
-
Connect to an instance of SQL Server
-
Run queries against DMV tables
Complete Pluralsight SQL Server Tutorials
Show steps
Gain a deeper understanding of SQL Server through guided tutorials
Show steps
-
Find suitable Pluralsight SQL Server tutorials
-
Follow the tutorials and complete the exercises provided
Configure a SQL Server instance
Show steps
You can practice configuring a SQL Server instance to troubleshoot configuration issues and improve SQL Server performance.
Show steps
-
Install SQL Server
-
Configure SQL Server instance
-
Troubleshoot configuration issues
Practice querying system DMVs
Show steps
Practice querying system DMVs to gain hands-on experience in identifying potential configuration issues.
Browse courses on
SQL Server Performance
Show steps
-
Install SQL Server Management Studio (SSMS)
-
Connect to a SQL Server instance
-
Query the sys.dm_os_performance_counters DMV
-
Query the sys.dm_os_wait_stats DMV
-
Query the sys.dm_exec_sessions DMV
Write a blog post or article about SQL Server configuration best practices
Show steps
You can write a blog post or article about SQL Server configuration best practices to share your knowledge and insights with others and reinforce your understanding of the topic.
Show steps
-
Research SQL Server configuration best practices
-
Write a blog post or article
-
Publish your content
Practice Querying SQL Server
Show steps
Build proficiency in querying SQL Server through repetitive exercises
Show steps
-
Create practice databases
-
Craft queries to retrieve data and generate reports
-
Test the accuracy and efficiency of the queries
Write a Technical Blog on SQL Server Configuration
Show steps
Reinforce understanding and share knowledge by creating a technical blog
Show steps
-
Choose a specific topic related to SQL Server configuration
-
Research and gather information from reliable sources
-
Write a well-structured and informative blog post
Write a blog post on SQL Server configuration best practices
Show steps
Write a blog post on SQL Server configuration best practices to solidify your understanding of the topic and share your knowledge with others.
Browse courses on
SQL Server Performance
Show steps
-
Research SQL Server configuration best practices
-
Create an outline for your blog post
-
Write the content for your blog post
-
Edit and proofread your blog post
-
Publish your blog post
Contribute to SQL Server Open Source Projects
Show steps
Gain practical experience and contribute to the SQL Server community
Show steps
-
Find suitable open source projects
-
Review the codebase and identify areas for contribution
-
Create and submit pull requests
Mentor Junior SQL Server Professionals
Show steps
Enhance your knowledge by sharing it and supporting others
Show steps
-
Find opportunities to mentor junior professionals
-
Provide guidance and support on SQL Server configuration and related topics
-
Share real-world experiences and lessons learned
Review Hardware and Network Considerations
Show steps
Ensure a solid foundation in hardware and network concepts
Browse courses on
Hardware
Show steps
Show steps
Show steps
- Revisit basic principles of computer hardware and networking
- Review best practices for SQL Server hardware and network configuration
Review SQL Server terminology
Show steps
Review SQL Server terminology to remind yourself of the key jargon that will be used throughout this course.
Browse courses on
Relational Database Management Systems
Show steps
Show steps
Show steps
- Visit Microsoft Learn: SQL Server terminology
- Read through the introduction and concepts pages
- Complete the online quiz: SQL Server terminology
Review SQL Concepts
Show steps
Refresh basic understanding of SQL Server through reviewing previous knowledge
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review SQL Basics
- Create a sample database in SQL Server
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Review database principles
Show steps
Review database principles to refresh your understanding of the fundamental concepts that underpin SQL Server.
Browse courses on
Database Normalization
Show steps
Show steps
Show steps
- Visit SQL Server training: Database fundamentals
- Review the following modules:
- Database design basics
- Database normalization
- Database integrity
- Take the assessment quiz
Join a SQL Server Study Group
Show steps
Enhance understanding and learn from others through peer discussions
Show steps
Show steps
Show steps
- Find a study group or create one
- Attend the study sessions and engage in discussions
- Collaborate on projects or assignments
Understand SQL Server Diagnostic Information Management (DIM)
Show steps
You can explore guided tutorials to understand how to use SQL Server Diagnostic Information Management (DIM) to collect and analyze diagnostic information for troubleshooting SQL Server issues.
Show steps
Show steps
Show steps
- Find tutorials on SQL Server DIM
- Follow the tutorials
Join a SQL Server user group
Show steps
Join a SQL Server user group to connect with other professionals, learn from their experiences, and stay up-to-date on the latest trends.
Browse courses on
Networking
Show steps
Show steps
Show steps
- Search for SQL Server user groups in your area
- Attend a user group meeting
- Introduce yourself and share your interests
- Participate in discussions and ask questions
- Connect with other members on LinkedIn
Volunteer at a SQL Server conference
Show steps
Volunteer at a SQL Server conference to gain practical experience, network with professionals, and contribute to the community.
Browse courses on
Volunteering
Show steps
Show steps
Show steps
- Search for SQL Server conferences in your area
- Contact the conference organizers
- Express your interest in volunteering
- Attend the conference and fulfill your volunteer responsibilities
- Network with attendees and speakers
Run queries against DMV tables
Show steps
You can practice running queries against commonly used DMV tables to identify performance issues.
Show steps
Show steps
Show steps
- Install a SQL Server Management Studio (SSMS) tool
- Connect to an instance of SQL Server
- Run queries against DMV tables
Complete Pluralsight SQL Server Tutorials
Show steps
Gain a deeper understanding of SQL Server through guided tutorials
Show steps
Show steps
Show steps
- Find suitable Pluralsight SQL Server tutorials
- Follow the tutorials and complete the exercises provided
Configure a SQL Server instance
Show steps
You can practice configuring a SQL Server instance to troubleshoot configuration issues and improve SQL Server performance.
Show steps
Show steps
Show steps
- Install SQL Server
- Configure SQL Server instance
- Troubleshoot configuration issues
Practice querying system DMVs
Show steps
Practice querying system DMVs to gain hands-on experience in identifying potential configuration issues.
Browse courses on
SQL Server Performance
Show steps
Show steps
Show steps
- Install SQL Server Management Studio (SSMS)
- Connect to a SQL Server instance
- Query the sys.dm_os_performance_counters DMV
- Query the sys.dm_os_wait_stats DMV
- Query the sys.dm_exec_sessions DMV
Write a blog post or article about SQL Server configuration best practices
Show steps
You can write a blog post or article about SQL Server configuration best practices to share your knowledge and insights with others and reinforce your understanding of the topic.
Show steps
Show steps
Show steps
- Research SQL Server configuration best practices
- Write a blog post or article
- Publish your content
Practice Querying SQL Server
Show steps
Build proficiency in querying SQL Server through repetitive exercises
Show steps
Show steps
Show steps
- Create practice databases
- Craft queries to retrieve data and generate reports
- Test the accuracy and efficiency of the queries
Write a Technical Blog on SQL Server Configuration
Show steps
Reinforce understanding and share knowledge by creating a technical blog
Show steps
Show steps
Show steps
- Choose a specific topic related to SQL Server configuration
- Research and gather information from reliable sources
- Write a well-structured and informative blog post
Write a blog post on SQL Server configuration best practices
Show steps
Write a blog post on SQL Server configuration best practices to solidify your understanding of the topic and share your knowledge with others.
Browse courses on
SQL Server Performance
Show steps
Show steps
Show steps
- Research SQL Server configuration best practices
- Create an outline for your blog post
- Write the content for your blog post
- Edit and proofread your blog post
- Publish your blog post
Contribute to SQL Server Open Source Projects
Show steps
Gain practical experience and contribute to the SQL Server community
Show steps
Show steps
Show steps
- Find suitable open source projects
- Review the codebase and identify areas for contribution
- Create and submit pull requests
Mentor Junior SQL Server Professionals
Show steps
Enhance your knowledge by sharing it and supporting others
Show steps
Show steps
Show steps
- Find opportunities to mentor junior professionals
- Provide guidance and support on SQL Server configuration and related topics
- Share real-world experiences and lessons learned
Career center
Learners who complete SQL Server 2017: Diagnosing Configuration Issues with DMVs will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator (DBA) is responsible for the day-to-day operations of a database system, including maintenance, performance tuning, and security. This course can help a DBA ensure that their SQL Server instances are configured correctly, which can improve performance and stability, and reduce the risk of data loss or corruption. Additionally, understanding the concepts covered in this course will be foundational to success in this role.
Data Analyst
Data Analyst
A Data Analyst helps businesses make data-driven decisions by collecting, cleaning, and analyzing data, and then presenting their findings to key stakeholders. By learning how to query SQL Server for configuration information, this course can help a Data Analyst identify misconfigurations that can affect performance and stability, thereby maximizing the reliability and performance of the database systems they manage.
Database Developer
Database Developer
A Database Developer designs and develops database systems, including the creation of tables, indexes, and stored procedures. This course can help a Database Developer understand how SQL Server is configured, which can be helpful when designing and developing database systems.
Systems Administrator
Systems Administrator
A Systems Administrator is responsible for the day-to-day operations of a computer system, including hardware, software, and networking. This course can help a Systems Administrator ensure that the SQL Server instances on their system are configured correctly, which can improve performance and stability, and reduce the risk of downtime or data loss.
Data Warehouse Engineer
Data Warehouse Engineer
A Data Warehouse Engineer designs and builds data warehouses, which are large repositories of data that are used for business intelligence and reporting. This course can help a Data Warehouse Engineer understand how SQL Server is configured, which can be helpful when designing and building data warehouses.
Technical Support Engineer
Technical Support Engineer
A Technical Support Engineer provides technical support to users of computer hardware and software. This course can help a Technical Support Engineer troubleshoot problems with SQL Server instances, which can help them to resolve issues and improve customer satisfaction.
Network Administrator
Network Administrator
A Network Administrator is responsible for the day-to-day operations of a computer network, including hardware, software, and security. This course can help a Network Administrator ensure that the SQL Server instances on their network are configured correctly, which can improve performance and stability, and reduce the risk of downtime or data loss.
DevOps Engineer
DevOps Engineer
A DevOps Engineer works to bridge the gap between development and operations teams, and is responsible for the deployment and management of software applications and systems. This course can help a DevOps Engineer understand how SQL Server is configured, which can be helpful when deploying and managing SQL Server instances.
Cloud Engineer
Cloud Engineer
A Cloud Engineer designs and builds cloud-based solutions, including the deployment and management of SQL Server instances. This course can help a Cloud Engineer understand how SQL Server is configured, which can be helpful when deploying and managing SQL Server instances in the cloud.
IT Manager
IT Manager
An IT Manager is responsible for the planning, implementation, and management of an organization's IT systems. This course can help an IT Manager understand how SQL Server is configured, which can be helpful when making decisions about the deployment and management of SQL Server instances.
Software Engineer
Software Engineer
A Software Engineer has a broad skillset, including the ability to design, develop, and maintain software applications and systems. This course can help a Software Engineer who works with SQL Server databases ensure that their applications are configured correctly, which can improve performance and stability.
Security Analyst
Security Analyst
A Security Analyst is responsible for protecting an organization's information and systems from unauthorized access, use, disclosure, disruption, modification, or destruction. This course can help a Security Analyst understand how SQL Server is configured, which can be helpful when assessing the security of SQL Server systems.
Data Scientist
Data Scientist
A Data Scientist uses scientific methods and techniques to extract knowledge and insights from data. This course can help a Data Scientist understand how SQL Server is configured, which can be helpful when working with data from SQL Server databases.
Project Manager
Project Manager
A Project Manager is responsible for the planning, execution, and closure of projects. This course can help a Project Manager understand how SQL Server is configured, which can be helpful when managing projects that involve the deployment or management of SQL Server instances.
Business Analyst
Business Analyst
A Business Analyst analyzes business processes and systems to identify areas for improvement. This course can help a Business Analyst understand how SQL Server is configured, which can be helpful when analyzing data from SQL Server databases.
For more career information including salaries, visit:
OpenCourser.com/course/b5j474/sql
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server 2017: Diagnosing Configuration Issues with DMVs.
Provides a practical guide to performance tuning SQL Server, including a number of configuration-related considerations that can affect performance.
Provides a comprehensive guide to performance tuning SQL Server, including a number of configuration-related tips and tricks.
Save
Provides guidance on designing and implementing data-intensive applications, including a chapter on performance tuning that covers configuration-related considerations.
Provides a practical guide to troubleshooting SQL Server, including a number of configuration-related issues that can affect performance and stability.
Provides a comprehensive guide to SQL Server 2017 business intelligence, including a chapter on how to configure SQL Server for business intelligence.
Provides a comprehensive guide to SQL Server 2017 application development, including a chapter on how to configure SQL Server for application development.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/b5j474/sql
Share
Similar courses
Here are nine courses similar to
SQL Server 2017: Diagnosing Configuration Issues with DMVs.
SQL Server 2017: Diagnosing Performance Issues with DMVs
OpenCourser.com/course/8mkyhb/sql
SQL Server 2017: Diagnosing Performance Issues with DMVs
Most relevant
Getting Started with Your First SQL Server Instance
OpenCourser.com/course/i8cmc1/getting
Getting Started with Your First SQL Server Instance
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Azure SQL Database: Diagnosing Performance Issues with DMVs
OpenCourser.com/course/qdy137/azure
Azure SQL Database: Diagnosing Performance Issues with...
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
OpenCourser.com/course/wdw9pu/troubleshooting
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
SQL Server Performance Tuning Part 1
OpenCourser.com/course/splh3q/sql
SQL Server Performance Tuning Part 1
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
OpenCourser.com/course/bfrjcd/sql
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Auditing SQL Server With Policy-Based Management
OpenCourser.com/course/fogit7/auditing
Auditing SQL Server With Policy-Based Management
Most relevant
Designing and Implementing SQL Server Database Indexes
OpenCourser.com/course/k9rkqz/designing
Designing and Implementing SQL Server Database Indexes
Most relevant
Time
106 hours
Level
Intermediate
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Good to know
Teaches a broad range of skills relevant to the work of a professional database administrator
Thoroughly examines configuration issues with SQL Server 2017 and earlier versions
Taught by Glenn Berry, a recognized expert on SQL Server performance and stability
Suitable for beginners and experienced SQL Server administrators alike
Provides a comprehensive overview of SQL Server configuration management
May require prior knowledge of SQL Server administration for some learners
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser