On this page, you define which SQL Server instances you want to collect size statistics from. SQL Size can collected size data from SQL Server 2005 and newer versions. SQL Server 7 and SQL Server 2000 are not supported.



To add an instance, click on the Add instance to monitor button.

To edit an existing instance, click on the Edit selected instance button.

To stop monitoring an instance, click on the Remove selected instance button,

or deselect the Enabled option for that instance.


For each SQL Server instance, you can specify additional options:

·

Connection settings

Enter the instance's server name and authentication method on this page. The Provider option indicates the connectivity library to use to connect to the instance. The (auto) option uses the latest connectivity library available on the machine where the SQL Size Agent service is running to connect to the instance. The SQL Native Client option uses the SQL Server Native Client library, while the MDAC option uses the older MDAC library.

In most cases, the (auto) option works fine.

·

Log-on user

If you are connecting to the SQL Server instance using Windows authentication, the SQL Size Agent service will connect to the instance using the account of the SQL Size Agent service. If this account does not have access to that instance, you will need to specify a different Windows account to impersonate, which has access to that instance. You can provide the details of that account on this page.

·

Databases

On this page, you can specify which databases to collect size statistics for. You can choose to include or exclude databases by names or regular expressions. By default, SQL Size will exclude the system databases.

If for example you want to collect size statistics only for databases starting with the prefix PROD_ and DEV_ , you can select the Include all databases matching the names or regular expressions below option and use the following settings: