Voici un ensemble d’articles très intéressant de M.M.Al-Farooque Shubho sur les différentes façons d’optimiser une base de données en utilisant les index, les plans d’exécution, les best practices, le partitionnement,… :
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using indexing to optimize data access
– Step1 : Apply proper indexing in the table columns in the database
– Step2 : Create appropriate covering indexes
– Step3 : Defragment indexes if fragmentation occurs
Top 10 steps to optimize data access in SQL Server. Part II (Re-factor TSQLs and apply best practices)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on refactoring and applying the TSQL best practices to improve performance.
– Step4: Move TSQL codes from application into the database server
– Step5: Identify inefficient TSQLs, re-factor and apply best practices
Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using some advanced indexing techniques and using de-normalizations to optimize data access.
– Step6 : Apply some advanced indexing techniques
– Step7 : Apply de-normalizations, use history tables and pre-calculated columns
Top 10 steps to optimize data access in SQL Server. Part IV (Diagnose database performance problems)
As part of a series of articles on several data access optimization steps, this article focuses on diagnosing performance problems in SQL Server.
– Step8 : Diagnose performance problem, use SQL Profiler and Performance Monitoring tool effectively.
Top 10 steps to optimize data access in SQL Server. Part V (Optimize database files and apply partitioning)
As part of a series of articles on several data access optimization steps, this article focuses on organizing files/filegroups and applying partitioning in SQL Server database.
– Step9 : Organize the file groups and files in the database
– Step10 : Apply partitioning in the big fat tables
– Step 11 (The bonus step): Better-manage the DBMS objects, Use TSQL Templates
1 commentaire reçu(s)
Laisser une réponse