Performance Tuning is a key activity at the heart of DBA and devops activities. Sometimes it can be incredibly challenging, turning slow T-SQL and inefficient schema and index design into a well optimized database server that will keep applications running quickly long into the future. MiniDBA is designed to make the process quick and simple, saving you potentially huge amounts of time.
Successful performance tuning requires a lot of information to be made available to you such as your slowest T-SQL operators, what files share disks, how many cpu cores are being used by each query, requested memory by session to name a few. Individual T-SQL queries run from management studio will get you most of these, Perfmon or WMI counters will get the rest. Once you have those details you have a mostly static picture of what is happening in your SQL Server. MiniDBA keeps constantly refreshing this picture allowing you to see changes to performance you make in real time at the highest time resolution on the market (2 seconds).
The following sections detail the functionality offered by miniDBA to help you effectively performance tune not just single queries but entire SQL Server estates.