|
Introduction |
|
User Guide |
|
Alert functions |
|
Mathematical functions |
|
String formatting functions |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
|
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.
|