Overview:
This course has been written to cover all the main aspects of tuning the performance of SQL Server. It builds upon several sections of the programming course and the administration course, focusing in on those aspects of SQL Server that potentially cause performance bottlenecks.
Audience:
Developers and administrators, familiar with SQL Server needing to know about troubleshooting techniques and tips to improve database performance.
Pre-Requisite:
Delegates should have good background knowledge of SQL Server.
Course Curriculum
| Database Performance Whats Good and why? | |||
| Relational Database Overview Details | 00:00:00 | ||
| The Query optimiser, compilation and caching. Details | 00:00:00 | ||
| Locking and Logging and how updates happen. Details | 00:00:00 | ||
| How backups work, how DTS packages work. Details | 00:00:00 | ||
| Optimal Data Storage | |||
| Using File groups to Position Objects Details | 00:00:00 | ||
| The affect of normalisation and de-normalisation. Details | 00:00:00 | ||
| Analysis Services a reporting solution in waiting? Details | 00:00:00 | ||
| Diagnostic Tools | |||
| Task Manager & Performance Monitor General counters to look out for, tips and techniques. Details | 00:00:00 | ||
| Current Activity Window & SQL Profiler Zooming in on problem queries Details | 00:00:00 | ||
| Query Analyser Decrypting the showplan and trace output. Other set commands. Details | 00:00:00 | ||
| Transact SQL diagnostic commands. Various DBCC commands, some undocumented. Details | 00:00:00 | ||
| Index Optimisation | |||
| Index selection How the optimiser decides. Details | 00:00:00 | ||
| Statistics Auto and Manual. Details | 00:00:00 | ||
| Clustered versus Non-Clustered Pros and Cons Details | 00:00:00 | ||
| The Fillfactor factor Details | 00:00:00 | ||
| Index optimiser hints Details | 00:00:00 | ||
| Index Covering Details | 00:00:00 | ||
| Index tuning wizard, when to use it. Details | 00:00:00 | ||
| Index Maintenance. Dangers and pitfalls. Details | 00:00:00 | ||
| Table defrag with clustered indexes. When and when not to do it. Details | 00:00:00 | ||
| Indexed Views Advanced index builds. Details | 00:00:00 | ||
| Locking Optimisation | |||
| The City Analogy & Keeping the traffic flowing Details | 00:00:00 | ||
| Transaction isolation levels and locking hints Details | 00:00:00 | ||
| Deadlock resolution Details | 00:00:00 | ||
| Table restructuring & de-normalisation, replication and data warehousing solutions Details | 00:00:00 | ||
| Efficient Programming in TSQL | |||
| SARGS and the WHERE clause. Details | 00:00:00 | ||
| Covered indexes from the other side. Details | 00:00:00 | ||
| Stored procedures: Problems solved and created Details | 00:00:00 | ||
| Trigger problems and solutions Details | 00:00:00 | ||
| Cursors and Temporary tables Details | 00:00:00 | ||
| Tips and tricks. Details | 00:00:00 | ||
| Efficient Client Programming | |||
| Default recordset options. Details | 00:00:00 | ||
| Send SQL versus Stored Procedures Details | 00:00:00 | ||
| Efficient use of recordsets and connections. Details | 00:00:00 | ||
| Timeout management and giving the user the perception of better performance Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED