PERFORMANCE TUNING - LEVEL 1
- Big Data - Performance Considerations
- Table Partitions and Tuning Options
- Partition Functions - Range Selectivity
- Partition Schemes and Reusability
- Deciding Partition Ranges & Functions
- Partitioned Data For Complex Queries
- Partitioning Un-partitioned Structures
- Aligned Partitions and Performance
- Fill Factor Options and Index Tuning
- Partitions for Query Tuning Operations
PERFORMANCE TUNING - LEVEL 2
- Index Internals and Execution Plans
- Index Fragmentation - Issues, Solutions
- SAMPLED & DETAILED Query Scans
- Filtered Indexes and Sizing Options
- Analyzing Work Load Tables and Scans
- Statistics Updates and Query Tuning
- Index Management Options & Statistics
- Statistics - AUTO CREATE, AUTO UPDATE
- Stats Updates (Manual) - Table Issues
- SQL Profiler Tuning and Lock Templates
DAY 26: PERFORMANCE TUNING - LEVEL 3
- Memory Optimized Tables & Usage
- LIVE QUERY STATS Analysis in SQL 2016
- Database Tuning Advisor (DTA) - Usage
- DTA for Long Running Queries, DB Caching
- DTA for Parallel/Concurrent Queries, Traces
- DTA Tool with Profiler, Trace Tables, Logs
- DTA Tool with Procedure (Plan) Cache
- Real-world Considerations for DTA Tool
- Resource Governor and Query Tuning
- Resource Pools Configuration, MODES
- Workload Groups & Resource Allocation
- Classifier Functions - Query Load Plans
- Query Priority, CPU/Memory Limits
- Query Memory, Index Memory Settings
- Thread Level Architecture - CPU Nodes
- Windows Fibres, Priority Boost Options
- MSDB Space Issues - Agent Performance
- DOP - Degree Of Parallelism & Options
- PDS Options with Indexes For Tuning
- Choosing PDS for Efficient Tuning
PERFORMANCE TUNING - LEVEL 4
- Distributed Replay Controller, SCOM
- System Monitor Tool & Activity Monitor
- PERFMON Counters and PSSDIAG Tools
- Counters for Query Stats, Agent Stats
- SQL Browser Service and Dump Files
- Log Space Issues & Query Performance
- Tempdb Issues & Query Performance
- Memory Issues & Query Performance
- Index Management Options @ SQL 2016
DB MAINTENANCE PLANS, REPAIRS
- Database Maintenance Plans (SSIS)
- DB Maintenance Strategies & Schedules
- MSDB History Management Options
- Backup Files and Space Management
- Reorganizing Indexes with Maint. Plans
- Stats Updates (Automatic) and Jobs
- Modifying SSIS DB Maintenance Plans
DAY 29: DATABASE MIGRATIONS, DMA TOOL
- Database Migration Options with SSIS
- DB Design Audits @ File System Store
- Database Detach Options and Downtime
- Database Attach Options and Scripting
- Scripting: Schemas, Object, Keys, Data
- Scripting Security Logins, Permissions
- Copy Database Wizard (SSIS) Tool Usage
- File System, SQL Server Package Store
- Migration Schedules, Jobs, Alerts, Logs
- Corrupted Logs, FORATTACH, REBUILDS
- Linked Server Security, Management
- Memory Dashboard and Buffer Cache
- Establishing Downtime For Maintenance
- Precautions for Maintenance Activities
- Service Packs and Patch/hotfix Activities
- Instance Selectivity for Updates, Cautions
- Pre & Post Patch Operations. Process
- Verifications, SmokeTest and Rollbacks
- Upgrade Advisor Tool - Analysis Reports
- Upgrade Advisor Issues and Warnings
- Server Upgrades and Precautions
- Planning for Maintenance Activities
- Rebuilding System Databases & Objects
- Pre Database Maintenance Activities
- Post Database Maintenance Activities
- Real-world Management Considerations
SQL CLUSTERS, ALWAYS-ON
- Need for Always - On Availability
- Always-On Prerequisites, Node Config
- SQL Server Cluster Installation
- Cluster Configurations - Active/Active
- Cluster Configurations - Active/Passive
- SQL Group & AD Syncup Operations
- SAN System for Shared Data Storage
- Network Security Issues with Solutions
- RAID, Storage Issues with Solutions
- Installing Updates - SQL Server Clusters
- Add Nodes to SQL Cluster - Active/Active
- SQL Server Cluster Utilities & Quorum
SQL School (SequelGate (I) Technologies Pvt. Ltd.)
OFFICE 1:
OFFICE 2:Sai Anu Avenue, Street Number 3, Patrika Nagar,
Patrika Nagar, HITEC City, Hyderabad - 81 (India). MapIndia: 0091 (0)9666440801 USA: 001 (510) 400-4845
No comments:
Post a Comment