Zachycení typického vytížení nad SQL Serverem

Abstract

This diploma thesis deals with the capture of a typical SQL database workload. Diploma thesis in the first part contains a description of the problem, a description of the technology, a description of the possible solutions to the problem and comparison of solutions that could be used for solutions. The next part of this diploma thesis describes the selection and design of optimal solution that is implemented. After the implementation, solution is integrated into tools for working with SQL database and tested over utilization. Finally, there is a description of optimization and re-testing of load and performance comparison.