Analyzing Product Growth with the Management Data Warehouse

  • Sean Bowden

    Old Hand

    Points: 359

    Comments posted to this topic are about the item Analyzing Product Growth with the Management Data Warehouse

  • SQLRNNR

    SSC Guru

    Points: 281205

    Thanks for the article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • philcart

    SSC-Forever

    Points: 47792

    Good article.

    Would really like to know how to incorporate SQL 2000 and SQL 2005 into the Management Data Warehouse. Think MS slipped up not allowing that.

    Sure you can't capture everything that is available on SQL Server 2008, but diskspace on SQL 2000 is just the same as disk space on SQL 2008.

    --------------------
    Colt 45 - the original point and click interface

  • Sean Bowden

    Old Hand

    Points: 359

    Thanks for reading.

    I agree that not having access to the data collector GUI/stored procedures on SQL 2000/2005 instances makes it difficult to use the MDW as an enterprise-wide trending/profiling solution. Best solution in this case would probably be to strip out the collection set definitions and roll them into your own SSIS/DTS packages, but this really negates a big selling point of the MDW/data collection for me, that being its centralized, integrated architecture.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply