You install the SQL Size Agent service and SQL Size GUI using the SQL Size installer. During the installation process, you will be prompted to enter the path where you want to install the SQL Size files.


Next, you will need to select the type of installation. If you want to install the SQL Size Agent service and also the SQL Size GUI, select the Full installation option.


If you want to install only the SQL Size GUI, select the Compact installation option.


If you want to install only the SQL Size Agent service, select the Custom installation option, and select the SQL Size Agent service and configuration tool item.


When you choose to install the SQL Size Agent service, you will need to perform additional configuration steps. A setup wizard will start and provide an overview of the various SQL Size components.


You will then need to choose how you want to store the SQL Size data. You can store the data in a SQL Server Compact Edition (SQL CE) database, or in a SQL Server database. More details are provided here.

The SQL Size Agent service needs to be started using an account, and that account needs to be able to access the SQL Size database, and also the SQL Server instances it needs to collect data from. You set up this account in the next step.


The SQL Size Agent service will periodically connect to the SQL Server instances to collect the size data. You will define the times at which the Agent will collect the data in the next step. Click on a cell to select or unselect the associated timeslot. Active timeslots are displayed in green.


Next, you will provide details of the SQL Server instances you want to collect size data from. SQL Size supports SQL Server 2005 instances and all subsequent SQL Server versions. SQL Size does not support SQL Server 7 or SQL Server 2000 instances. For each instance you want to collect data from, you need to provide the connection details.


If the account used to start the SQL Size Agent service does not have rights to access a SQL Server instance, you can impersonate a different account to connect to that instance on the Log-on user page.


You can also choose to collect size data from specific databases. You can include or exclude database using names and regular expressions. This can be done on the Databases page.


Once you have defined the instances to collect size data from, they will be listed in the wizard.


SQL Size can send growth trend reports to you via email. You can set up the recipients and the period in which to report on. You also define to whom SQL Size should send error logs to. You also have the choice of using our email server to send reports and/or logs, or you can use your own email server.

Once you have set up the above settings, the Setup Wizard will apply your settings and the installation will complete.


You can change the settings after the installation process by using the SQL Size Configuration application.