none
Collecting Source System information

    Question

  • 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


    Sunday, January 29, 2012 12:56 PM

Answers

  • 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
    Monday, January 30, 2012 9:48 PM
  • 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
    Tuesday, January 31, 2012 3:13 PM

All replies

  • 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
    Monday, January 30, 2012 9:48 PM
  • 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
    Tuesday, January 31, 2012 3:13 PM