October 3, 2007 at 4:52 am
Dear guys,
I was asked if usage based optimisation can be "migrated" from AS2000 to AS2005.
What I've found out with the help of google is that for usage based opt. query logging should be enabled in both version. So I looked for the AS2000 querylog file which is an MDB. But if you compare it to the e.g. SQL Server 2005 QueryLog table the fields are different and 2005 certainly does not want to use the mdb table 🙁
Does anyone have an idea about it? Anyway: can it be done somehow? I think it would make sense...
Thanks in advance,
MartinIsti
October 3, 2007 at 6:12 am
I have never tried to migrate a log, but here is my thought process on it.
Even just using the migration wizard to go from 2000 to 2005, you are going to get a different cube structure when you are done. If in addition to this, you spent any time properly setting up your attribute relationships, you will end up with something very different from the original cube.
So, you are basically asking if you can look at the usage log from one OLAP database structure and use that to optimize another. I would have to guess that in 99.99% of the cases, looking at the usage log from the original cube will be of no use in the new one.
October 3, 2007 at 7:14 am
Thanks for the reply Michael and you're right by all odds I think.
October 10, 2007 at 10:02 pm
Have you actually applied the query log/s to the existing AS2K cubes to create aggregations? If so, you could review the aggregations created for the cube in AS2K and then apply/create similar aggregations for the new AS2k5 cube. They might at least give you a starting point for some aggregations (other than simply running the agg/storage wizard). Keep in mind that the dimension structures are really quite different between 2K and 2K5 so it may not be an easy translation. Remember to have those Attribute Relationships set up right too!
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply