Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Collecting Source System information

Answered Collecting Source System information

  • Sunday, January 29, 2012 12:56 PM
     
     
    Sign In to Vote
    0

    Hello All,

    We are starting a new Datawarehouse Project,

    Intigrating several   sql servers ,I'm looking for important sys views  ,dmv's  or any information which will help  to get the important information  about the sources  before the extraction  and the factors to consider based on the collected metrics for extraction .

     

    Many Thanks

    Kumar


     

All Replies

  • Monday, January 30, 2012 9:48 PM
     
     Answered
    Sign In to Vote
    0

    Please give us an example of the information you would be hunting for, DMV's are widespread and they contain different metrics collected overtime. Some may deem important to you environment and some may not.

    • Marked As Answer by Vision2040 Tuesday, January 31, 2012 4:00 PM
    •  
     
  • Tuesday, January 31, 2012 3:13 PM
     
     Answered
    Sign In to Vote
    0

    if you are looking for Source data distrebution that will help you in your Data cleansing then you do not need DMV's all you need is SSIS profiler task to profile the source data

    http://msdn.microsoft.com/en-us/library/cc952923(v=sql.100).aspx

    but if you want to gather data abut the source SQL Server, idecies and machine then YES dmv's is your choice. you need to be more specific about what do you need from dmv's

    Wagdy Ishac www.sqldair.com
    • Marked As Answer by Vision2040 Tuesday, January 31, 2012 4:00 PM
    •