Analyzing Product Growth with the Management Data Warehouse

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Bowden » Analyzing Product Growth with the Management...

Analyzing Product Growth with the Management Data Warehouse

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Bowden

Posted Saturday, November 27, 2010 12:07 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:34 AM
Points: 91, Visits: 350

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

Post #1026994

SQLRNNR

Posted Monday, November 29, 2010 3:26 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the article.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1027656

philcart

Posted Monday, November 29, 2010 9:40 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:53 AM
Points: 2,692, Visits: 1,074

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.

Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club

Post #1027719

Sean Bowden

Posted Thursday, December 02, 2010 12:02 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:34 AM
Points: 91, Visits: 350

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.

Post #1029447

« Prev Topic | Next Topic »

Permissions