Push out a sample report to a table on database growth over set time frame (4335473)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Push out a sample report to a table on database growth over set time frame
Description

Is there a way to track the growth of databases over extended periods of time to push out the "Enterprise SQL Server Database Space" sample report to a table that can be queried against to gain insight on database growth over time.
Resolution

Execute the stored procedure as follows
EXEC [dbo].[spotlight_rep_growth_data_files2]
@start_date = N'jan 1 2015',
@end_date = N'dec 31 2015',
@monitored_object_name = N'host_instance_sqlserver',
@database_size = 10
The monitored_object_name format can be:
<host name>_<instance name>_sqlserver
<host name>_sqlserver

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title