Video Training →Azure SQL and SQL Server Database Monitoring
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English | Duration: 16 Lectures (1h) | Size: 1.6 GB
Information is at the heart of most software systems and the lifeblood of many organizations, so you want the database that stores this information to be efficient and reliable. But as we know, things happen; sometimes bad things. One of the ways that we can prevent bad things from happening is to know about them in advance like the old saying says, "To be forewarned is to be forearmed."
Azure SQL in its many forms has an abundance of features that help you to monitor the state of your databases and database server. Ranging from prebuilt automated monitoring that is augmented with artificial intelligence through to dynamic management views, SQL Server monitors and logs all aspects of the database engine's operation and configuration. Intelligent Insights and Azure SQL analytics enable you to easily access the wealth of diagnostic and performance data in an easily digestible format.
Understand the key elements of database monitoring
Learn about the features of Intelligent Insights, Azure's AI-based database monitoring service
Create graphical reports using SQL Server Management Studio
Understand how wait statistics can show you where threads have to wait and how this can be used to monitor performance
View and fix index fragmentation
Monitor database storage
Implement notification alerts on various database platforms
This course is aimed at database administrators or anyone who wants to learn how to implement systems that can find potential issues that may disrupt the delivery of their database services.
To get the most out of this course, you should have experience with SQL Server Management Studio, be familiar with reading and writing SQL, and have an understanding of basic database architecture and administration tasks, like indexes and backups.
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
- Azure SQL and SQL Server Database Task Automation
- Azure SQL and SQL Server Query Performance Tuning
- DP-900 Azure Data Fundamentals Exam Prep In One Day
- Migrate Windows service to Azure
- Using Microsoft Azure Database Services
Users of Guests are not allowed to comment this publication.