The SQL Size Agent service

The SQL Size service needs to be installed before you can use the SQL Size GUI to analyse size statistics. The service can be installed on any computer which meets the following requirements:

·

has access to the database used to store the size statistics

·

has access to the SQL Server instances that you want to collect size statistics for

Installation

To install the SQL Size service, select the Full installation or Custom installation options when running the installer.



Permissions

The SQL Size Agent service needs to be able to store the data it collects from your SQL Server instances in a database. If you are using a SQL Server Compact Edition (SQL CE) database, ensure that the SQL Size Agent service startup account has full rights to the SQL CE database.

The SQL Size Agent service also needs to be able to connect to each SQL Server instance that you want to collect size data from. However, if this is not possible to set up, the SQL Size Agent can also impersonate another account, before attempting to connect to the instance. You can set up the impersonated account using the SQL Size Configuration application.