MONITORING SQL DATABASE PERFORMANCE- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP


MONITORING SQL  DATABASE  PERFORMANCE

TECHNICAL TALK- WORKSHOP 



Agenda:


Technologies Focused : Monitoring  SQL  Data Base Performance

Number of Students : 70

Date of the Programme : 28-02-2018

Location of the Programme :Chennai KaaShiv InfoTech

Programme Mission :

1. Social activities in spreading Microsoft Technologies to the students.
2. Awareness on Microsoft SQL Servers  and security.
3. Practical demos on Microsoft SQL Servers
4.Micosoft Today: Advanced SQL Server Applications in Azure.
5.Talk on SQL Applications and Its features.
Overview of SQL Database  Performance:

Monitor databases using the Azure portal-CPU Percentage-DTU Percentage-Data IO Percentage-Database size Percentage:



Monitor resource use-Impact of Data base performance-Transact SQL Stored Procedures-SQL Server system stored procedures:


How to Monitoring the  resource utilization:


Role of monitoring-Built in functions-Graphic interface:


Advantages of Monitoring:


 Various sources utilization:


Concurrent Access:



How to monitor database Query Performance:



 Monitor various Performance level:


Comments

Post a Comment

Popular posts from this blog

SQL SERVER ON AZURE VIRTUAL MACHINE- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER ON AZURE VIRTUAL MACHINE TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server on Azure Virtual Machine Number of Students : 50 Date of the Programme : 01-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL Server Azure Virtual Machine: Why Virtual Machine: How SQL server runs on Virtual Machine:  Automated Storage Configuration: Advantages of using  Azure Virtual Machine: Enhance Security and compliance through Azure Virtual Machine:  Virtual Machine types: Applications of Azure Virtual Machine: Addit...
Read more

SQL SERVER HOSTING - TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL HOSTING TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Hosting Number of Students : 50 Date of the Programme : 14-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. What is SQL hosting:  SQL hosting suitable for various SQL databases: Why SQL hosting: SQL Server hosting: Database Management System: What is the potential Use Cases of SQL Server Hosting:  Advantages of  SQL Server hosting:
Read more

SQL SERVER MANAGEMENT ISSUES- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER MANAGEMENT ISSUES TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Management Issues Number of Students : 50 Date of the Programme : 13-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL  Server Management Issues: Troubleshoot the problem using query analyser: What is in the SQL Server Error log and  Various types of tuning:  E xceptions in  SQL Server Management Objects: What is SQL Server Crash-What  is response time: Focus on Response time and  Solutions for the Issues: Review for performance Count...
Read more