October 13, 2010 at 12:49 pm
Hello
We have a 600 Gb Siebel 7.7 database that runs on SQL-Server 2000, of which one table uses 320 Gb for 140 millions rows. We are in the process of upgrading to Siebel 8.1 on SQL-Server 2008 and I am wondering if partitionning this table would be a good idea.
Siebel uses a column called 'ROW_ID' as the primary key for each table, and performance drops if the key is not the clustered index; those keys are in a format like '1-0066DI8', and seem to be generated in sequence (same sequence for all the tables in the database)
Has anyone ever tried to partition a table in a Siebel database? I haven't found any guidelines on the partitioning columns on a Siebel database
October 13, 2010 at 3:08 pm
André Lozeau (10/13/2010)
We have a 600 Gb Siebel 7.7 database that runs on SQL-Server 2000, of which one table uses 320 Gb for 140 millions rows. We are in the process of upgrading to Siebel 8.1 on SQL-Server 2008 and I am wondering if partitionning this table would be a good idea.Siebel uses a column called 'ROW_ID' as the primary key for each table, and performance drops if the key is not the clustered index; those keys are in a format like '1-0066DI8', and seem to be generated in sequence (same sequence for all the tables in the database)
Has anyone ever tried to partition a table in a Siebel database? I haven't found any guidelines on the partitioning columns on a Siebel database
More than often vendor's don't like the idea of customers messing around with the architecture of an application. I would contact Siebel's vendor, Oracle, you know.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply