Hi Guys,
i am managing an OLTP system using sql 2000 and these
system is running for last 4 years and now having 25
million records for main transaction table.

is it advisable to go for OLAP Systems to get fast summary
report.

if so pls advice me how i should start.

Thanks
Biju

SQL2K AS is not cluster-aware, so you'd need to take this into consideration if you wish to add OLAP functionality. 25million records isn't a lot of records for SQL2K (table size is usually more an indicator) so this shouldn't be something that determines if you need an OLAP solution. If you need better performance rather than OLAP functionality you're far better tuning your queries or modifying your db schema, or you can scale up the hardware on the SQL2K cluster (ie more memory, faster disk subsystem, more CPUs etc).