SQL

Which port does STREAM use for its Client-Server connection?

The STREAM Client uses the default SQL port, which is 1433.

How large is a typical STREAM database?

We can only provide accurate estimates with known scope (assets) and setup.

However, a blank profile (i.e. containing control standards and threat setup but no business assets ) is typically less than 10Mb, and even with a considerable scope is still less than 100Mb.

The automatic Savepoints (created for historic reporting) usually add no more than a few Mbs per month.

Even very large setups are well under 1Gb, even after a few years of database growth.

How do I backup a STREAM database, and where is the backup file stored?

You take a database backup as follows:

1.       Launch SQL Server Management Studio

2.       Connect to the relevant SQL instance:

How do I configure SQL Server 2005 Express on a STREAM Enterprise system

SQL Server 2005 Express CAN by used on a small STREAM Enterprise system.  However, 'out of the box', SQL Server Express editions are not configured to support remote connections or network connectivity.

These are the steps to enable remote connections on SQL Server Express Editions.

Which SQL Server editions are supported?

STREAM can be installed on any edition of SQL Server 2005 or later, including the Express editions.

We would normally not recommend running a STREAM Enterprise system on SQL Server Express editions, however it can be successful with a small number of users.

You could of course start with SQL Server Express, and then upgrade to the Standard, Workgroup or Enterprise Edition when you are ready.

Can STREAM interface with other applications for automated importing of performance metrics?

Yes, STREAM can pull metrics directly and automatically from the outputs of a range of monitoring tools or products.  On a configured schedule (e.g. every minute, every hour, every day...), STREAM can pull data from a variety of such products, which are configured as SQL Linked Server data sources.