RSS Reporter for SQL Server

Database Info Feeds

 

Database Info feeds contain information about the database size and space usage. To create this type of feed you simply select the database from the drop-down list and click on the button "Create Feed".

The database info feed contains the following items:

• A feed item for each database data file. If your database has, for example, three filegroups and each filegroup has two files, the feed contains six items.
• A feed item for each database log file.
• A summary feed item for the database itself.

The feed item for data files and log files reports the following information:

Autogrowth:	The file autogrowth option. The growth factor is reported as well if the autogrowth is on.
Maximum File Size:	The maximum file size or "Unrestricted Growth" if the file has been configured to grow until there is disk space.
File Size:	The actual size of the data or log file.
Space Used:	Space used by SQL Server.
Space Available:	Space available in the data or log file.

The database feed item reports the following information:

Database Size:	The total size of all data files and log files.
Data File Size:	The size of all data files.
Log Size:	The size of all log files.
Data Space Allocated:	The total space allocated in the data files.
Data Space Available:	The total space available in the data files.
Space used for data:	The space allocated for data only.
Space used for indexes:	The space allocated for indexes.
Unused space:	The portion of the allocated space not being used for data or indexes.

Notes: -->

• The space used vs. space available is displayed in the feed graphically. If the RSS reader you are using does not render the feed properly, you can change it to a simple text feed. To do this, open the Web.Config and change the parameter ChartedDatabaseInfoFeed to false.
  
• In SQL Server 2005 you should have VIEW SERVER STATE permission to view the size and space usage of the database log. You can execute the following statement in the master database to grant this permission:
  
  GRANT VIEW SERVER STATE TO principal
  where principal is the SQL Server principal to which the permission is being granted. SQL Server 2000 does not require any special permission.