Automatická analýza vytížení SQL Serveru

Abstract

The thesis deals with the workload analysis of Microsoft SQL Server with respect to its automatization as well as user friendly handling. There are many tools for gathering and analysis of the performance data; their usage, however, does not have to be easy for an inexperienced user. The thesis focuses mainly on the development of application that enables the user to analyze the performance of SQL Server without being forced to deal with the study and configuration of these tools. The first part presents a survey of the most frequently used tools as well as it evaluates their possible utilization within the application. The second part deals with the description of the developed application, its possibilities, essential principles, architecture and implementation.