Management Studio Reports – Part 2 – Disk Usage Report

re: Management Studio Reports – Part 2 – Disk Usage Report

Shankar — Tue, 16 Oct 2012 17:41:17 GMT

Is there a way to schedule these report so that in a particular time every day the reports get generated and exported to PDF/xls and saved in a given folder.

re: Management Studio Reports – Part 2 – Disk Usage Report

Christopher Conner — Fri, 20 Oct 2006 19:36:08 GMT

How about a report that returns the same data from the DBCC command in SQL2000 "dbcc memusage(names)" ?? Is this data available from the DMF already?

re: Management Studio Reports – Part 2 – Disk Usage Report

Christoph Muthmann — Fri, 15 Sep 2006 16:03:38 GMT

Here you can download my additional reports. It includes as a benefit the corrected version of 'Backup and Restore Events'.

http://www.insidesql.de/component/option,com_remository/Itemid,0/func,fileinfo/id,62/

The whole (german) article is available here:
http://www.insidesql.de/beitraege/reporting/cm_reports_im_management_studio.html

Please leave a comment there if you are satisfied.

Kind regards,
Christoph

re: Management Studio Reports – Part 2 – Disk Usage Report

Christoph Muthmann — Tue, 12 Sep 2006 11:33:16 GMT

This blog is a great input for my daily work. Thanks!
For managing servers I've designed two additional reports to get an overview.

First there is the top ten of the databases (used/unused space data + log) compared with the information provided by xp_fixeddrives. So I can see the disk space and the biggest databases at first glance.

My second one is based on all the jobs scheduled on regular daily basis. So I can see which is the best time for a planned downtime or when are to many jobs in the night concurring for cpu.

I will upload the reports on a german mvp-site and come back to tell you the url.

Kind regards,
Christoph

re: Management Studio Reports – Part 2 – Disk Usage Report

Kevin Lloyd — Mon, 28 Aug 2006 19:00:48 GMT

I do like the reports in SSMS and I do find them useful. Also, please keep releasing RDL files so that we can run them outside the studio for DBA support. However, it would be great to be able to integrate our own custom reports in SSMS.

I can't think of any specific examples, but maybe index usage history for specific procedures so that as data grows or the model changes and we are modifying the procedure, we can see, historically, how that plan might have changed.

re: Management Studio Reports – Part 2 – Disk Usage Report

Rudi_Wiesmayr — Wed, 23 Aug 2006 15:17:02 GMT

We are new to SQL2005 and are very used to the taskpad display in SQL2005.
Running SAP on SQLServer, we have very large databases with very many tables and indexes.
One of the first things is the bad performance of the Disk Usage Report in SQL2005 Management Studio.
So I'm happy to have found this BLOG.
Looking forward to try out the attached report...

re: Management Studio Reports – Part 2 – Disk Usage Report

KurtM — Fri, 21 Jul 2006 22:15:27 GMT

Paul,

I'd like to see the whole Management Studio Report set released as a package. There are report packs for Integration Services, Sharepoint, Great Plains, IIS. Why not SQL?

Also, the Backup and Restore Events report doesn't seem to work. What up with that?

Go Bucks!!!

re: Management Studio Reports – Part 2 – Disk Usage Report

paulgauvreau — Wed, 19 Jul 2006 23:32:55 GMT

Hey Paul,

This is very useful not only from a dba administrative perspective, but also from an instructional / sample POV. I would like to see as many of these as possible so they can be integrated into our report web server. I believe there is real value in creating some data driven or time driven subscriptions.

Answers:
1) Yes, absolutely
2) Hell Yeah!!! Keep 'em coming!
3) So many things come to mind:
a) Audits - logins (successful and failures), auth. type, application used to connect, host connected from, etc...
b) Security - members of server roles, databases, database roles, explicit table access, mapping a user to all their access or mapping an object to all who can access it
c) Security History - changes to permissions
d) Maintenance Plans / SQL Agent Jobs - when and what, history successfule
e) Alerts History and Notification

thats enough isn't it???

re: Management Studio Reports – Part 2 – Disk Usage Report

Cristian Lefter — Wed, 12 Jul 2006 22:18:25 GMT

To answer Paul's questions:
1. Yes but I would go deeper to DMVs
2. Yes (all if possible)
3. Since DMVs are one of the source for reports, having DMVs support I would add more reports for components (Service Boker, Replication, Database Mirroring, CLR etc).

re: Management Studio Reports – Part 2 – Disk Usage Report

shiming927 — Wed, 12 Jul 2006 07:26:24 GMT

Hi, I didn't step deep into 2005, but I'd like to make some comments.
1) It's useful, at least the thing I tried to have from 2000.
2) Of course, they also shed light on .rdl making, thanks!!!
3) Is it possible to have index usage statistics report (without using profiler)?