SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it to the full potential.
Connect to SQL Server Node >> Right Click on it >> Go to Reports >> Click on Standard Reports >> Pick Any Report.
[youtube=http://www.youtube.com/watch?v=ORtv29rxXJI]
Please note that some of the reports can be IO intensive and not suggested to run during business hours!
More on Standard Reports:
SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
SQL SERVER – Generate Report for Index Physical Statistics – SSMS
SQL SERVER – Configure Management Data Collection in Quick Steps
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.
If we like your idea we promise to share with you educational material.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
5 Comments. Leave new
Hi Pinal,
Can you please specify 1 line use of each of these standard reports?
We know we can generate report using standard reports option on sql server
but it would be good if you could eloborate on each and every report in detail
Thanks
how does one edit the standard reports? I am wanting to look at “Shema Changes History” for more than 3 months