Is it good to have around 300 log swithes every day in DW environment ?
Hi,
I have following situation in my DW environment :
MONTH ARCH_DATE SWITCHES DAILY_AVG_GB
--------- ----------------------- ---------- ------------
May Saturday : 08-May-2010 298 447
May Sunday : 09-May-2010 185 277
May Monday : 10-May-2010 481 721
May Tuesday : 11-May-2010 479 718
May Wednesday :12-May-2010 474 711
May Thursday : 13-May-2010 548 821
May Friday : 14-May-2010 327 490
May Saturday : 15-May-2010 204 306
May Sunday : 16-May-2010 236 354
May Monday : 17-May-2010 394 591
May Tuesday : 18-May-2010 350 525
May Wednesday :19-May-2010 324 486
May Thursday : 20-May-2010 372 558
Facts :
1. we have mostly ETL powercenter jobs running whole day.
2. Size of our database is 10 TB
3. We do not have update/delete statements mostly INSERT statements happening in system.
4. size of log file is 1.5 GB and we have 12 files.
Question : Does 500GB redo( or 300 switches) every day in the DW system like us, is more or normal or extreme ?
I have following situation in my DW environment :
MONTH ARCH_DATE SWITCHES DAILY_AVG_GB
--------- ----------------------- ---------- ------------
May Saturday : 08-May-2010 298 447
May Sunday : 09-May-2010 185 277
May Monday : 10-May-2010 481 721
May Tuesday : 11-May-2010 479 718
May Wednesday :12-May-2010 474 711
May Thursday : 13-May-2010 548 821
May Friday : 14-May-2010 327 490
May Saturday : 15-May-2010 204 306
May Sunday : 16-May-2010 236 354
May Monday : 17-May-2010 394 591
May Tuesday : 18-May-2010 350 525
May Wednesday :19-May-2010 324 486
May Thursday : 20-May-2010 372 558
Facts :
1. we have mostly ETL powercenter jobs running whole day.
2. Size of our database is 10 TB
3. We do not have update/delete statements mostly INSERT statements happening in system.
4. size of log file is 1.5 GB and we have 12 files.
Question : Does 500GB redo( or 300 switches) every day in the DW system like us, is more or normal or extreme ?
0