• fannonland2 (3/2/2011)


    Hmm, then I guess I am misreading your instructions. It says I need to run scripts scom blocking.sql. I do that on the scom server? And then I need to edit the rules to reflect settings in my environment. I am looking at my SCOM SQL database and I don't see a database that says "Analysis".

    Yes, sorry the instructions on ReadMe.txt file are not very clear.

    The Analysis db could be any centralized database in your environment that is collecting historical blocking information.

    It is not the SCOM database, but a database created by you to collect the custom info generated by the rules here.

    If you already have such a db in your environment for collecting other such info, you can use the same db for this implementation.

    You may need to edit the name of the database from "Analysis" to whatever the name of your db is in a few places though.

    Does that make sense?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]