SQL SERVER PERFORMANCE TUNING AND TROUBLESHOOTING- TECHNICAL TALK- WORKSHOP - By Microsoft Awarded Azure MVP

 SQL SERVER PERFORMANCE TUNING AND TROUBLESHOOTING

TECHNICAL TALK- WORKSHOP 

Agenda:

Technologies Focused :  SQL  Server Performance Tuning and TroubleShooting

Number of Students : 250

Date of the Programme : 24-08-2017

Location of the Programme : Sri Kanyaka Parameswari Arts and Science College For Women

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 Performance Tuning-how to improve indexes-how to create highly selective indexes-What is query Optimizer and how to make use of it-what is response time and total time- :

Use Parameterized Queries-Limit Using OUTER JOIN-Query only when you must-Real World Knowledge How SQL Server Works Internally:

Significance of TroubleShooting - Information phase-Gathering Facts - Test in Different Environments and machines-Review the SQL Server error log-Review the Event log-Review the change log :

Memento: