Comprehensive Baseline Collector Solution

  • Robert_sqlapprenticeDOTnet

    SSC-Addicted

    Points: 433

    Comments posted to this topic are about the item Comprehensive Baseline Collector Solution

  • Robert Sterbal-482516

    SSCrazy

    Points: 2785

    Thanks for providing a clear license in the downloaded code. I wish I could find it clearly discussed in the article as well.

  • sql_er

    SSCarpal Tunnel

    Points: 4135

    How does it compare to MDW (master data warehouse)?

  • Robert_sqlapprenticeDOTnet

    SSC-Addicted

    Points: 433

    Unfortunately I don't know. I did not try it.

  • Robert_sqlapprenticeDOTnet

    SSC-Addicted

    Points: 433

    Robert Sterbal-482516 (10/20/2014)


    Thanks for providing a clear license in the downloaded code. I wish I could find it clearly discussed in the article as well.

    I intentionally did not write the license into the article. You can find the license info here as well: http://www.sqlapprentice.net/license/

  • Misha_SQL

    SSCertifiable

    Points: 5385

    This is an incredibly useful solution! Thank you for sharing all your hard work with the community!

  • mauriciorpp

    Default port

    Points: 1472

    thanks for sharing!

    I am tweeting and blogging your post. Sometimes a simple solution that can be customized with the least possible effort is the best way to get things done.

    I love complete monitoring tools like SQLMonitor, but when I need to colect some data on a remote server that I can't install a lot of stuff on, only base sql scripts will do the work.

    I'm spreading the word about your article on Tweeter and WordPress too.

    thanks!

  • Clive Strong

    SSChampion

    Points: 11127

    I'm yet to read the article in full, but in principal, the concept is great. All too often, people ignore a baseline and then wonder what is the "norm" when the things go south.

    Looking forward to reading it in fall a little later!

  • jonesboy21

    Right there with Babe

    Points: 720

    This is some good stuff, nice work. Good alternative if you can't purchase a 3rd party tool.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    What a fascinating script. Thanks.

  • Cezar Mulotto-300477

    Grasshopper

    Points: 19

    Hi Robert !

    I liked your post !!! Congratulations !!!

    I did something from this way, but after collected, imported in SQL Server using Relog.

    I needed to create combination between some counters, to have informations that i could compare with some metrics.

    Other counter, i used only to baseline.

    Because i wanted to generate an application, i needed to create some formulas with the counters used with metrics, formulas that were interpreted by a stored procedure. Some metrics have intervals (disk has good, bad,etc..), and others only limits.

    I had samples by minute, so in a month, around of 42.000 samples.

    Then wanted to generate some graphics to see the infomation better, but 42.000 samples are alot!!!

    I put some filters to use in population, to get the job interval and, in some cases, didnt get weekdays.

    Then, finally, i needed to do a store procedure to get less samples, but, without lose the major (or minor, depending the counter) values to put in graphics. I did a stored procedure that have two parameters, how many major (or minor) values and how many samples between two major (or minor) samples.

    I think that you will talk about in next time.

  • Robert Sterbal-482516

    SSCrazy

    Points: 2785

    Helpful additional scripts:

    http://www.sqlskills.com/blogs/glenn/category/dmv-queries/

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

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