Question Re: Maintain DB storage parameter in Technology Q&A https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470698#M2683510 <HTML><HEAD></HEAD><BODY><P>HI, </P><P></P><P>The main reason for separating the table spaces is easy monitoring as u know which data is lying where moreover there are several other benefits also like u can take backup at individual table space level. This helps in trouble shooting also. </P><P></P><P>The separation of table spaces is database depended. </P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Wed, 17 Nov 2010 04:29:00 GMT Former Member 2010-11-17T04:29:00Z Maintain DB storage parameter https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaq-p/7470695 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>is anyone familiar with the option for DSOs, Cubes etc. to maintain DB storage parameters?</P><P></P><P>I would be interested in the impact oof adjusting this option? What is technically happening, when changing these settings?</P><P></P><P>Thank You!</P><P>Goliad</P></BODY></HTML> Tue, 16 Nov 2010 11:11:53 GMT https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaq-p/7470695 Former Member 2010-11-16T11:11:53Z Re: Maintain DB storage parameter https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470696#M2683508 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Please check the below link</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="1089342"></A></P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Tue, 16 Nov 2010 11:32:04 GMT https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470696#M2683508 Former Member 2010-11-16T11:32:04Z Re: Maintain DB storage parameter https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470697#M2683509 <HTML><HEAD></HEAD><BODY><P>Hello Ravish,</P><P></P><P>thank you for your answer. </P><P>This link does not completely answer my question. SAP Help only recommends to seperate tablespaces for large tables. But what is the purpose of separating these tablespaces?</P><P>Are there performance reasons, reduced risk of database errors and why is is only possible for oracle and informix databases?</P><P></P><P>Thank You!</P><P>Markus</P></BODY></HTML> Tue, 16 Nov 2010 12:29:36 GMT https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470697#M2683509 Former Member 2010-11-16T12:29:36Z Re: Maintain DB storage parameter https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470698#M2683510 <HTML><HEAD></HEAD><BODY><P>HI, </P><P></P><P>The main reason for separating the table spaces is easy monitoring as u know which data is lying where moreover there are several other benefits also like u can take backup at individual table space level. This helps in trouble shooting also. </P><P></P><P>The separation of table spaces is database depended. </P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Wed, 17 Nov 2010 04:29:00 GMT https://community.sap.com/t5/technology-q-a/maintain-db-storage-parameter/qaa-p/7470698#M2683510 Former Member 2010-11-17T04:29:00Z