Post reply

SQL Server 2008 Management Data Warehouse

  • December 14, 2012 at 8:17 am

    #268107

    Folks,

    I am trying to build a SQL Server jobs historical warehouse. This is to run reports to see how SQL Server jobs are peperforming over few months on a number of instances.

    For that, I would like to use MDW. Everything is on SQL Server 2008 R2.

    How would I go about it?

    Any output is trully appreciated.

    thanks!

    Bee

    if one wants it.. one will justify it.

  • December 14, 2012 at 8:44 am

    #1568745

    I would first suggest reading up on Data warehouses and Star Schemas.

    then write down what you want to measure and how you want to analyse it.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • December 14, 2012 at 9:00 am

    #1568755

    Farely doing so. However, I am not new to either data-warehousing, marts, etc.. specially star-schemas.

    I setup the new MDW. It created a whole bunch of collecting jobs. There is very little info about MDW technology. Unless I am not looking at the right place. So far: http://msdn.microsoft.com/en-us/library/dd939169(d=printer,v=sql.100).aspx

    is the only white paper I found.

    Is there a step by step usage of the MDW white papers? Obviously, we already monitoring CPUs, disks, perfomance, etc. What we need is MDW to collect SQL Server jobs data from msdb daily so that we can have a better statistics on our SQL Server jobs.

    if one wants it.. one will justify it.

  • December 14, 2012 at 9:04 am

    #1568757

    To collect: job execution time, job name, success/failure.. very basic stuff.

    if one wants it.. one will justify it.

  • December 14, 2012 at 9:19 am

    #1568763

    Sorry I got end of the wrong end of the stick. I thought you were new to DW's.

    I'll have to read up on MDW as it looks pretty interesting.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • December 14, 2012 at 9:20 am

    #1568765

    i just found this fella on the net

    maybe it would help you

    http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

  • December 14, 2012 at 9:25 am

    #1568770

    The beauty of the MDW in SQL Server 2008 is that it creates the containers, database, collecting jobs for you. Problem is: very little to none doucmentaion that I can find.. accept for some private blogs.

    So

    I craete: database via the Wizzard. -> the sql gather jobs are installed -> star schem is already there in the MDW database. now what? How can I stop recording what it is recording and actually have it start gathering data that I want.

    if one wants it.. one will justify it.

Viewing 7 posts - 1 through 6 (of 6 total)

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