Post reply

Analyzing Product Growth with the Management Data Warehouse

  • November 27, 2010 at 12:07 pm

    #231606

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

  • November 29, 2010 at 3:26 pm

    #1256530

    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

  • November 29, 2010 at 9:40 pm

    #1256579

    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

  • December 2, 2010 at 12:02 pm

    #1258041

    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 3 (of 3 total)

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