Post reply

Comprehensive Baseline Collector Solution

  • October 20, 2014 at 10:23 pm

    #312317

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

  • October 20, 2014 at 10:57 pm

    #1753657

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

  • October 21, 2014 at 5:39 am

    #1753699

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

  • October 21, 2014 at 9:03 am

    #1753783

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

  • October 21, 2014 at 9:06 am

    #1753785

    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/

  • October 22, 2014 at 6:00 pm

    #1754224

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

  • October 24, 2014 at 6:32 am

    #1754618

    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!

  • April 28, 2015 at 3:31 am

    #1793881

    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!

  • April 28, 2015 at 7:39 am

    #1793932

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

  • April 28, 2015 at 7:43 am

    #1793935

    What a fascinating script. Thanks.

  • May 2, 2015 at 1:31 pm

    #1795198

    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.

  • September 2, 2016 at 5:06 am

    #1898961

    Helpful additional scripts:

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

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

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