Difference between revisions of "Ad Manager Data Warehouse: Setup and configuration"
From Dot2DotCommunications
(→Prerequisites) |
(→A machine to run the data pump on with network access to both the source Ad Manager database server(s) and the data warehouse server) |
||
| Line 5: | Line 5: | ||
The disk space requirements depend on the size of the snapshots and the number of snapshots that will be retained. The size of the snapshots in turn depends on the number and size of the source Ad Manager databases and the cut-off date of the snapshot. Since it's hard to know the disk space requirements in advance it would be best to use dynamic disks that can be expanded as required. Ideally the SQL server machine will have a dedicated partition for data and a dedicated partition for transaction logs. | The disk space requirements depend on the size of the snapshots and the number of snapshots that will be retained. The size of the snapshots in turn depends on the number and size of the source Ad Manager databases and the cut-off date of the snapshot. Since it's hard to know the disk space requirements in advance it would be best to use dynamic disks that can be expanded as required. Ideally the SQL server machine will have a dedicated partition for data and a dedicated partition for transaction logs. | ||
| − | ==== A machine to run the data pump on | + | ==== A machine to run the data pump on ==== |
| + | |||
| + | The data pump requires network access to both the source Ad Manager database server(s) and the data warehouse server. | ||
This could be the data warehouse server itself. | This could be the data warehouse server itself. | ||
Revision as of 14:11, 3 August 2018
Contents |
Prerequisites
A SQL Server instance with adequate disk space for data and transaction logs
The disk space requirements depend on the size of the snapshots and the number of snapshots that will be retained. The size of the snapshots in turn depends on the number and size of the source Ad Manager databases and the cut-off date of the snapshot. Since it's hard to know the disk space requirements in advance it would be best to use dynamic disks that can be expanded as required. Ideally the SQL server machine will have a dedicated partition for data and a dedicated partition for transaction logs.
A machine to run the data pump on
The data pump requires network access to both the source Ad Manager database server(s) and the data warehouse server.
This could be the data warehouse server itself.
