In the latest SQL Solution center articles, we wrote about SQL Server queries monitoring and finding poor performers. Additionally, we’ve had a number of Solution center articles translated to Italian and French languages.
In Monitor SQL Server queries – find poor performers – Activity Monitor and Data collection we described why tracking most expensive queries is important and how to use SQL Server native features – Activity Monitor, which provides information about processor time (%), waiting tasks, database I/O, and batch requests/sec in real time graphs, and lists currently running processes, resource waits, data file I/O, and recent expensive queries; and Data Collection feature which provides performance metrics monitoring and a list of expensive queries by utilizing built-in query statistics collection set.
In Monitor SQL Server queries – find poor performers – dynamic management views and functions we showed another way to find the most expensive recent queries using dynamic management views and functions.
In Monitor SQL Server queries – find poor performers – SQL Server Profiler we showed how to use SQL Server Profiler to create an SQL trace for expensive queries.
In Monitor SQL Server queries – find poor performers – creating and analyzing SQL traces we showed how to create an SQL trace using T-SQL and how to read and analyze the events and columns captured in SQL traces.
In Monitor SQL Server queries – find poor performers – the out-of-the-box solution we described how to use ApexSQL Monitor to find most expensive queries and benefit from GUI interface where you can obtain the most important query performance details without any coding knowledge, knowledge of system views and functions, or native SQL Server features available only is specific SQL Server editions.
October 17, 2014