October 8, 2007 at 1:14 pm
Can you please help me in suggesting me good optimization techniques ?
I was given a task to optimize the existing Data Model/Mart and present it to the team.
Currently our architecture includes :
i) extraction of source data thru stored procedures. All the stored procedures are called thru ETL jobs that are in SQL Server agent.
ii) Once the source data is loaded to the Data Mart, we are using Microstrategy and reporting services to report against the data in Data Mart.
Note : We are using SS 2005 but we are not utilizing the SSIS and SSAS components.
I did the following ground work to understand the existing model or architecture.
i) Identified all the reports and the logic involved for Data Mart queries.
ii) Understand the relationship b/w tables and logic in Stored procedures.
iii) Analysing the source system data.
Can you please suggest me the other steps that I can take for achieving the goal of optimization of data model by utilizing the SSIS & SSAS components ?
October 10, 2007 at 6:39 am
so do you have a problem with your current set up? IF not then I'd probably suggest you leave things alone - " if it ain't broke don't fix it"
Reporting services can cache often run reports avoiding re-running the report every time a user wants the data - this is one of the most useful features if you have 100's of users repeatedly running the same report.
( your current solution may do this of course )
SSIS is pretty cool but don't change things just because someone thinks you should.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply