In the last month and a half, SQL Shack articles focused on performance reports from SQL Server Management Studio, performance dashboard reports in SQL Server 2014, reviewing failed SQL Server logins, and SQL Server commands – Dynamic SQL.
Various methods for auditing failed logins in SQL Server are available. In Using Extended Events to review SQL Server failed logins, we explained how to audit failed logins in SQL Server Management Studio using SQL Server Audit, or SQL Server Extended Events.
In Performance dashboard Reports in SQL Server 2014, we explained how to install and start using the Performance dashboard Reports. These reports contain multiple dashboards, and we shortly described User requests, User sessions, Buffer Io Waits, Waits, IO statistics, Expensive queries, and Miscellaneous information reports.
In SQL Server Management Studio performance reports, we explained various methods to get the performance reports in SQL Server Management Studio. One of the features that provide the most common metric values is Activity Monitor, and it is described in this article. Besides this, we mentioned Data collection sets, and described SQL Server instance standard reports, Server dashboard, and memory consumption report.
In SQL Server Commands – Dynamic SQL, we have introduced and briefly described the using of the SQL Server commands, along with problems and suggestions when and how to use these commands safely.
August 15, 2014