Issue
Is it possible to connect a number of Vista servers to the same SQL server instance?
Environment
TAC Vista 5.1.X in a multi server environment.
Cause
Customers with larger sites may wish to collect the log data from TAC Vista on one SQL server for ease of maintenance and security reasons.
Resolution
There are a couple of conditions to observe when doing this:
- Each Vista server must have it's own database (ie. taclogdata1, taclogdata2, taclogdata3 etc).
- The SQL server machine must be able to handle the increased load.
- There must be sufficient space for all the databases.
- A maintenance plan must be put in place - regular defragmentations and rebuilds (See White Paper - SQL Server Best Practices).