Performance Tuning and optimizing SQL DataBases
Main Speaker:
Michael Zilberstein
Tracks:
DataSeminar Categories:
DataCourse ID:
50135Date:
26.04.2021Time:
Daily seminar9:00-16:30
Overview
This Seminar provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases
Who Should Attend
| SQL Server DBAs |
Course Contents
- Performance tuning methodology
- Detecting root cause of performance problem
- Troubleshooting CPU issues
- Troubleshooting IO issues
- Troubleshooting blocking locks
- Query tuning
- Understanding Execution Plans
- Do’s and don’ts in Transact-SQL query and Stored Procedure
- SQL Server monitoring tools
