Database capacity

Hi,

I’m working in a DWH project the source system have data from passed 30 years and the total number of records from the source system is 10 million.

I’m need to do the estimation for the data base for the up coming 10 years of data.

As I can predict that the 30 year of data is 10 million then expected data for 10 years would not be more then 3 million.

The ETL tool I’m using is SQL Server Integration services and the reporting tool is Business Objects.

Can any one guide me on the implementation plan, meanmemory taken for ETL jobs (As SSIS use large amount of memory) database and business objects.

Sheikh

A good place to start is this link http://www.dmreview.com/article_sub.cfm?articleId=1048082

In talks in general about Capacity Planning.

Some basic things I would say -- almost a must have for a Datawarehouse

1) 64 Bit Environment -- you can use more than 4 GB of Memory in here (well you can use more than 4 GB in a 32 bit -- but 64 bit is better, especially if you can afford it).

2) Min of 8 GB of RAM. (considering you do not have more than 15 Million Rows).

3) Obviously -- enough Hard DIsk space for your DW.

4) A Good Disk Subsytem.

But a lot depends on your usage pattern and what you are trying to achieve. Ultimately it will all come down to cost vs benefit.

|||Thank you for the helpfull post.

database backup compression > 2gb

I have a database backup which is 15GB. I need to put it
onto a DVD which has 4.7GB capacity. What I'd like to do
is zip it up, but this is not possibly due to the 2gb
limit of winzip. Doesw anyone know what tools there are
to do this type of thing?
TIA,
BB
BB
WINRAR ?
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
> I have a database backup which is 15GB. I need to put it
> onto a DVD which has 4.7GB capacity. What I'd like to do
> is zip it up, but this is not possibly due to the 2gb
> limit of winzip. Doesw anyone know what tools there are
> to do this type of thing?
> TIA,
> BB
|||The latest version of WinZip does not have the 2GB limit.
Also check out WinRar as Uri suggested.
Also, you might be able to use something like SQL Lite Speed or UltraBac to
create a compressed backup.
Keith
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
> I have a database backup which is 15GB. I need to put it
> onto a DVD which has 4.7GB capacity. What I'd like to do
> is zip it up, but this is not possibly due to the 2gb
> limit of winzip. Doesw anyone know what tools there are
> to do this type of thing?
> TIA,
> BB
|||You may want to use tools like SQLZIP, that compresses the
backup file while backing up.

>--Original Message--
>BB
>WINRAR ?
>"BB" <anonymous@.discussions.microsoft.com> wrote in
message
>news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
>
>.
>
|||As mentioned, the latest versions of Winzip support the new Zip64 format,
which no longer has the 2 Gig file limit. Winrar does not have that limit
either.
If this is a one-off operation, you can use our free MiniSQLBackup Lite,
which will compress the backup directly from SQL Server. There is no limit
on the file size.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"Kal" <anonymous@.discussions.microsoft.com> wrote in message
news:480901c4a173$220e4cd0$a501280a@.phx.gbl...[vbcol=seagreen]
> You may want to use tools like SQLZIP, that compresses the
> backup file while backing up.
> message

database backup compression > 2gb

I have a database backup which is 15GB. I need to put it
onto a DVD which has 4.7GB capacity. What I'd like to do
is zip it up, but this is not possibly due to the 2gb
limit of winzip. Doesw anyone know what tools there are
to do this type of thing?
TIA,
BBBB
WINRAR ?
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
> I have a database backup which is 15GB. I need to put it
> onto a DVD which has 4.7GB capacity. What I'd like to do
> is zip it up, but this is not possibly due to the 2gb
> limit of winzip. Doesw anyone know what tools there are
> to do this type of thing?
> TIA,
> BB|||The latest version of WinZip does not have the 2GB limit.
Also check out WinRar as Uri suggested.
Also, you might be able to use something like SQL Lite Speed or UltraBac to
create a compressed backup.
--
Keith
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
> I have a database backup which is 15GB. I need to put it
> onto a DVD which has 4.7GB capacity. What I'd like to do
> is zip it up, but this is not possibly due to the 2gb
> limit of winzip. Doesw anyone know what tools there are
> to do this type of thing?
> TIA,
> BB|||You may want to use tools like SQLZIP, that compresses the
backup file while backing up.
>--Original Message--
>BB
>WINRAR ?
>"BB" <anonymous@.discussions.microsoft.com> wrote in
message
>news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
>> I have a database backup which is 15GB. I need to put it
>> onto a DVD which has 4.7GB capacity. What I'd like to do
>> is zip it up, but this is not possibly due to the 2gb
>> limit of winzip. Doesw anyone know what tools there are
>> to do this type of thing?
>> TIA,
>> BB
>
>.
>|||As mentioned, the latest versions of Winzip support the new Zip64 format,
which no longer has the 2 Gig file limit. Winrar does not have that limit
either.
If this is a one-off operation, you can use our free MiniSQLBackup Lite,
which will compress the backup directly from SQL Server. There is no limit
on the file size.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"Kal" <anonymous@.discussions.microsoft.com> wrote in message
news:480901c4a173$220e4cd0$a501280a@.phx.gbl...
> You may want to use tools like SQLZIP, that compresses the
> backup file while backing up.
> >--Original Message--
> >BB
> >WINRAR ?
> >
> >"BB" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:23b401c4a16f$bc793b80$a601280a@.phx.gbl...
> >> I have a database backup which is 15GB. I need to put it
> >> onto a DVD which has 4.7GB capacity. What I'd like to do
> >> is zip it up, but this is not possibly due to the 2gb
> >> limit of winzip. Doesw anyone know what tools there are
> >> to do this type of thing?
> >> TIA,
> >> BB
> >
> >
> >.
> >