Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Three Sample reports for the Automated DBA: Space Usage SnapShotter Expand / Collapse
Author
Message
Posted Tuesday, July 7, 2009 2:27 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
Comments posted to this topic are about the item Three Sample reports for the Automated DBA: Space Usage SnapShotter


Post #748365
Posted Tuesday, July 14, 2009 6:02 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 5:56 AM
Points: 34, Visits: 187
Jess - This would be much more helpful with the schema for the Admin database attached. Otherwise, we have to back into your schema design. Not much time available for doing that. Can you post the schema DDL please.

Thanks.

... Jerry
Post #752602
Posted Tuesday, July 14, 2009 9:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
The schema are in the main snapshotter scripts. This is only some sample reporting procs. The snapshotter procs (Util_BuildSpaceLog) have the DDL and data gathering DML. Look in the Related content section under the Releated Tags section on the right sidebar.

One or the other, depending on whether you have sysadmin or just have dbo rights:
(The schema is the same for both for portability/upgradability but the DML won't populate the buffer cache columns in the dbo version because that data requires sysadmin)

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Put a call to the snapshotter (Util_BuildSpaceLog) in a job. get some data for a few days, then run these reports and make up more reports of your own.

Oh if you use SSRS you can make SSRS do the running aggregates and differences/growth, making the T-SQL simpler and improving performance (T-SQL won't do well with running aggregates until SQL 2011; or whatever is after SQL 2008 R2), but of course the end user won't be able to copy-and-paste unless he were to export to excel (extra step, especially if RDPing for some reason to get the report)



Post #752796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse