SQL Server Performance tunning class online for 5999 INR ONLY

SQL SERVER PERFORMANCE TUNNING FOR 5999 INR ONLY
DAY 1
Basics of Performance Tuning
• Introduction
• Performance Tuning Road Map
• SQL Profiler VS Extended Events DAY 2
Blocking and Dead Lock
• Introduction to Locks
• Monitoring and Identifying
• Alerting the Blocking and DeadLocks
• How to Avoid Blocking /Deadlock

DAY 3
Disk Performance
• Benchmarking Disk with SQL IO
• Monitoring Disk performance with Perfmon
• Fixing the Disk issues

DAY 4
TempDB
• Optimizing TempDB
Performance Dashboard
• Server and DB monitoring using rdl files

DAY 5
CPU Bottleneck
• Long running queries
• Custom Reports for server Dashboard
• Automation simple hacks DAY 6
• Performance monitoring & alerting no tools required
• Powershell for automation DAY 7
• SQL DIAG
• SQL Nexus DAY 8
• RML Utilities
• Windows Performance recorder
• Windows Performance Analyzer DAY 9
Memory
• Buffer Manager
• Memory Best Practices
• Memory Leak or upgrade the memory?

DAY 10
Crash Dump analysis
How to create a Server Dump
How to analyze it

DAY 11
• Tuning Indexes
• Page splits DAY 12
• High Availability Performance tuning and monitoring
• Performance analysis using PAL DAY 13
Query Optimization
• Reading a query plan
• Query tuning best practices DAY 14
Migration
• In place Migration
• Side by side migration
• Tunning and roll backup in migration DAY 15
Cloud Basics
Hosting SQL Server on Cloud
Migration to cloud

want to join call fareed 9640847141 /8150097559