Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Chris Welford

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL Server Stream Sizing

Scenario

Capturing and manipulating data does itself require disk storage. Sometimes it is useful to know how much space the system is using and how fast that usage is growing.

...

  • Create Streams to extract data from the internal CenterView tables.
  • For each table that is part of a CenterView model, query sqlserver for its data size / disk requirements. Use the built in SQL Server stored procedure : sp_spaceused.
  • As an additional exercise, determine the number of records, the number of streams and the archive details for each stream.

See Also

  • href="../../../../../../doc/training/Exercises.pdf">Patterns and Exercise Training Document
  • href="http://www.centerview-online.com:8081/patterns">Centerview Online Patterns and Training