locked
SCOM 2012 SQL Monitoring RRS feed

  • Question

  • We have implemneted SCOm 2012 RC and imported SQL MP . After installing the MP  , We are unable to see the space details for Log and Data files in discovered inventory. No alerts ahave been raised neither there are script failures. The permission of the account is set as per the guide . What should i check .

     

    Thursday, December 29, 2011 5:10 AM

Answers

  •  

    Hi,

     

    Firstly, I think we need to check the privileges settings:

     

    Configuring Run As Accounts and Profiles in R2–A SQL Management Pack Example

    http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx

     

    Regarding the error “Cannot login to database”, please check the issue with the method below:

     

    OpsMgr 2007 Alert: Cannot login to database

    http://blogs.technet.com/b/operationsmgr/archive/2011/07/20/opsmgr-2007-alert-cannot-login-to-database.aspx

     

    Hope this helps.

     

    Thanks.

    Nicholas Li

    TechNet Community Support

    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 2:49 AM
  • Hi

    It is bad practice to discover properties of a class that change between each discovery as this causes config churn. As a database size is likely to change between each discovery, it is likely that this has been deprecated to disable the discovery of this information for the state view. Monitoring of database size will still take place as the monitoring will retrieve the value and compare it to the threshold. It just won't store the value as discovery information.

    http://blogs.technet.com/b/kevinholman/archive/2009/10/05/what-is-config-churn.aspx

    The error you are getting about "Run As Account" is seperate to this and as Nicholas has stated - you need to configure the Run As Accounts exactly as you would in SCOM 2007 R2. His link to another Kevin Holman blog article is the one to follow.

    The error you get - "ment Group: ABC. Script: GetSQL2008DBFreeSpace.vbs : Cannot login to database [DEV18.domain.com][MSSQLSERVER:master]" states Master database which is why I say that it is a Run As Account issue. If you see this error but the database specified is not master then it is equally likely to be because the database is set to auto close (and hence is closed when SCOM tries to log in to it).

    Cheers

    Graham


    New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 9:00 AM
  • I see Graham has already said what I wanted to say. :-)
    Ignore those columns, they should not be part of discoveredd inventory, but should be performance stats.
    Make sure you have the runas account setup correctly and also make sure that runas account has rights on that sql instance.
    If that is the case everything will be alright.
    Bob Cornelissen - BICTT (My Blog about SCOM) - Microsoft Community Contributor 2011 Recipient
    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 9:46 AM

All replies

  • You are looking at the columns for deprecated items. Means they are turned off and not running and are considered obsolete. They are probably still listed because of backwards compatibility. Just ignore those columns marked with (Deprecated).
    Bob Cornelissen - BICTT (My Blog about SCOM) - Microsoft Community Contributor 2011 Recipient
    Thursday, December 29, 2011 1:52 PM
  • Thanks Bob

    I somehow dont see the Database Size (MB) (string) and other ize related columns .

    This a new SCOM 2012 environmnet i have build and the DB , DW (SQL DB) is hosted on the RMS itself. 

     The reason i had asked the query about  database size was because im getting the following alert:

    Run As Account does not exist on the target system or does not have enough permissions

    Management Group: ABC. Script: GetSQL2008DBFreeSpace.vbs : Cannot login to database [DEV18.domain.com][MSSQLSERVER:master]

     

    Knowledge:  
        View additional knowledge...
     

    Summary

    A monitoring or discovery script doesn’t have permissions to connect to the database. For detailed information about the script name and database name, please see the alert description.

    Causes

    Discovery and monitoring scripts work under the “SQL Server Discovery Account” and “SQL Server Monitoring Account” profiles. Accounts which are used in these profiles must be configured correctly.

    Resolutions

    To configure discovery and monitoring accounts properly, please see “Security Considerations” section in the Management Pack Guide.

     


    • Edited by Kitaab Monday, January 2, 2012 11:48 AM
    Monday, January 2, 2012 11:47 AM
  •  

    Hi,

     

    Firstly, I think we need to check the privileges settings:

     

    Configuring Run As Accounts and Profiles in R2–A SQL Management Pack Example

    http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx

     

    Regarding the error “Cannot login to database”, please check the issue with the method below:

     

    OpsMgr 2007 Alert: Cannot login to database

    http://blogs.technet.com/b/operationsmgr/archive/2011/07/20/opsmgr-2007-alert-cannot-login-to-database.aspx

     

    Hope this helps.

     

    Thanks.

    Nicholas Li

    TechNet Community Support

    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 2:49 AM
  • Hi

    It is bad practice to discover properties of a class that change between each discovery as this causes config churn. As a database size is likely to change between each discovery, it is likely that this has been deprecated to disable the discovery of this information for the state view. Monitoring of database size will still take place as the monitoring will retrieve the value and compare it to the threshold. It just won't store the value as discovery information.

    http://blogs.technet.com/b/kevinholman/archive/2009/10/05/what-is-config-churn.aspx

    The error you are getting about "Run As Account" is seperate to this and as Nicholas has stated - you need to configure the Run As Accounts exactly as you would in SCOM 2007 R2. His link to another Kevin Holman blog article is the one to follow.

    The error you get - "ment Group: ABC. Script: GetSQL2008DBFreeSpace.vbs : Cannot login to database [DEV18.domain.com][MSSQLSERVER:master]" states Master database which is why I say that it is a Run As Account issue. If you see this error but the database specified is not master then it is equally likely to be because the database is set to auto close (and hence is closed when SCOM tries to log in to it).

    Cheers

    Graham


    New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 9:00 AM
  • I see Graham has already said what I wanted to say. :-)
    Ignore those columns, they should not be part of discoveredd inventory, but should be performance stats.
    Make sure you have the runas account setup correctly and also make sure that runas account has rights on that sql instance.
    If that is the case everything will be alright.
    Bob Cornelissen - BICTT (My Blog about SCOM) - Microsoft Community Contributor 2011 Recipient
    • Proposed as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    • Marked as answer by Nicholas Li Thursday, January 5, 2012 2:21 AM
    Tuesday, January 3, 2012 9:46 AM