Hi,
I have to implement data warehousing on SQL Server 2005 database (6 GB). I never worked on it before. I have no idea from where to start. I am searching for some tips and tools to use. Please guide me.
We are using SQL Server 2005. We have web based application, with daily user hits of 50K.
we are keeping site tracking and user activity in database and providing educational material on web. Our reporting is usually users site tracking activity and their credit based on users activity on specific page visitings.
Please help me how to start and develop warehousing on this database. we want to keep our production data of 1 week and move all data in ware hourse so that users who like to see site tracking activity of older than 1 week from warehouse it would result in fast and based on their tracking admin users will give credit to employees quickly. Actually the bottleneck is database, when we run reporting for last six months or 1 year it slow down the site and result it bad perforamnce. so we decided to make some kind of warehouse, keep small data in production database and weekly shift our data to warehouse where users will be able to get aggregated results more efficiently. We have almost 450k unique users right now.
We have an admin site whose most most part consists of reporting, which hurts perforamnce. so we wanted to separate them on different Server with all data since begining (6 years records). is this a right way we are planning ?
All i want to know how to start working on data warehousing (Keep all old data in once plance and apply cubes and provide results to clients) ? Please suggest me the right path.
Thanks.
Shamshad Ali.