Server Performance and Activity Monitoring

Monitor Performance of SQL Server and Databases

3.71 (7 reviews)
Udemy
platform
English
language
Operating Systems
category
Server Performance and Activity Monitoring
1,199
students
1.5 hours
content
Oct 2023
last update
$19.99
regular price

What you will learn

SQL Server Installation

Sample Database Installation

SQL Server Management Studio Installation

SQL Server Performance Monitoring

Database Activity Monitoring

Data Collection

Using Extended Events

Using Indexes

Description

The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Microsoft SQL Server and the Microsoft Windows operating system provide utilities that let you view the current condition of the database and to  track performance as conditions change.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

The core component of the SQL Server is the Database Engine. The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, pages, index, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Engine.

SQL Server has four primary editions that have different bundled services and tools. Two editions are available free of charge:

SQL Server Developer edition for use in database development and testing.

SQL Server Expression for small databases with the size up to 10 GB of disk storage capacity.

For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL server’s features.

SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.

Content

SQL Server Installation

Introduction
What is SQL Server
SQL Server Editions
Hardware and software requirements
SQL Server Download
SQL Server Installation
Install SQL Server Management Studio
SQL Server Configuration Manager
Connecting to SQL Server with SSMS
Install Adventureworks Database
Install AdventureworksDW Database
Please Note

Server Performance and Activity Monitoring

Introduction
SQL Server Performance Monitoring
Using Activity Monitor
Collecting Data
Extended Events
Indexes

Charts

Price

Server Performance and Activity Monitoring - Price chart

Rating

Server Performance and Activity Monitoring - Ratings chart

Enrollment distribution

Server Performance and Activity Monitoring - Distribution chart

Related Topics

4503260
udemy ID
1/19/2022
course created date
1/21/2022
course indexed date
Bot
course submited by