Уровень 0 · материалов: 4
В кластер входят документы, посвященные методам и инструментам количественного анализа и устранения проблем с производительностью MS SQL Server.
Общие признаки: поиск узких мест производительности, анализ ресурсов MS SQL Server, инструменты диагностики, мониторинг состояния базы данных
Группа выше: Диагностика деградации производительности
Смысл: The main idea is to provide a foundational toolkit for identifying performance bottlenecks in MS SQL Server by moving from qualitative complaints ('the server is slow') to quantitative evidence using built-in tools and system views.
A comprehensive guide on using SSMS tools, SQL Profiler, and Dynamic Management Views to quantitatively analyze and optimize MS SQL Server performance.
Смысл: The main idea is to provide a practical, entry-level framework for IT generalists to diagnose and resolve MS SQL Server performance issues by focusing on basic maintenance and hardware resource bottlenecks.
A beginner-friendly guide to diagnosing MS SQL Server performance issues, focusing on index maintenance and disk I/O optimization.
Смысл: The main idea is to empower SQL Server professionals with a set of programmatic tools (T-SQL scripts) to quickly understand the architecture, health, and performance bottlenecks of an undocumented database without relying on GUI tools.
A technical guide providing a comprehensive library of T-SQL scripts for auditing SQL Server instances and reverse-engineering database schemas.
Смысл: The main idea is that SQL Server internally tracks why execution threads are delayed, and by analyzing these 'wait statistics,' administrators can scientifically identify whether performance bottlenecks are caused by CPU, disk I/O, network, or locking issues.
A technical guide on diagnosing SQL Server performance bottlenecks by analyzing wait statistics via DMVs and interpreting common wait types.