Overview
SSMS has built-in performance-related reports that help you trace and track performance-related issues with SQL Server to assist with improving performance by giving insight at various levels.
Explanation
The built-in reports can be accessed as follows:
- Right-click on the desired database.
- Click Reports.
- Click Standard Reports.
- Then, a list of available reports is shown. Click on the desired report to open the report.
Additional Information
- Built in Performance Reports in SQL Server Management Studio (SSMS)
- SQL Server Management Studio Standard Reports – Overview
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
