Home Forums Article Discussions Article Discussions by Author Discuss content posted by Marios Philippopoulos Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

  • March 2, 2011 at 11:21 am

    #1293648

    ok, so it sounds like I need to go into SQL management Studio, create a new database called "Analysis" and then run the blocking tables.sql against that new database. Does that sound right?

    And then when I need to customize it it will be...

    ...

    sAnalysisInstance = "scomserver\scomsql"

    sAnalysisDB = "analysis"

    ...

    ...

    sConnString = "Server=" & sAnalysisInstance & ";Database=" & sAnalysisDB & ";UID=xxx;PWD=xxx"

    ...