locked
SQL Database count in discovery is not currect. RRS feed

  • Question

  • Hi,

    I have a standalone SQL server having 60 databases.

    but out of 60 databases, i am able to see only 54.

    6 Databases is not discovered.

    What can be the issues? help me ....

     


    Mahesh Kumar-MCTS Microsoft Management services
    Thursday, November 11, 2010 8:11 AM

Answers

  • I do have an open enhancement request on this on http://connect.microsoft.com  - it is ID 577012, title = Easy way to remove objects from SCOM when an application is uninstalled

    My specific request there was about removing SQL but the same principal applies for SQL databases by the look of things.

    Have you tried overriding the discovery and running remove-disabledmonitoringobject?

    Cheers

    Graham

     


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    • Marked as answer by Yog Li Tuesday, November 23, 2010 9:57 AM
    Tuesday, November 16, 2010 12:12 PM

All replies

  • Hi Mahesh.

    Do the RunAs Account for your SQL monitoring have the same permissions on those 6 databases as the one discoverd.


    mats.w | www.opsmode.com
    Friday, November 12, 2010 10:12 AM
  • Hi

    Do you see any 10801 or 33333 events in the OperationsManager event log on the RMS? This indicates invalid discovery data being submitted from the agent .. and might cover these 6 databases:

    http://social.technet.microsoft.com/Forums/en/operationsmanagermgmtpacks/thread/21e9de85-5cbc-4217-8d9b-921e13dc88dc

    Are there any errors in the OperationsManager event log to do with the SQL discovery failing? Which version of SQL does this relate to? The above url has an example by Kevin Holman on how to troubleshoot the discovery for SQL which should help as does his blog below:

    http://blogs.technet.com/b/kevinholman/archive/2010/03/09/basic-troubleshooting-of-discovery-scripts.aspx

    Cheers

    Graham


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    Friday, November 12, 2010 10:34 AM
  • Thanks Gharam,

    I am getting the same Event in my RMS.

    Thanks a lot for providing me the Troubleshooting steps.

     


    Mahesh Kumar-MCTS Microsoft Management services
    Saturday, November 13, 2010 6:23 AM
  • No problem - let us know how you get on.

    Cheers

    Graham


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    Saturday, November 13, 2010 1:28 PM
  •  

    hi Graham,

    I have deleted one of the SQL Database from one scom SQL agent server. but it is still showing the green stat in scom console under monitoring > Microsoft SQL server> Database > Databases state.

    I have check the check Database(DBCC) task and is result is

    ""Msg 2520, Level 16, State 5, Server XXXXXXXXXX, Line 1
    Could not find database 'TestDB_11'. The database either does not exist, or
    was dropped before a statement tried to use it. Verify if the database exists
    by querying the sys.databases catalog view.""

    if my database is not on SQL server,  and query states that it is not exist then why it is showing in console?

    how can i remove it? Is there any time period after which is will remove automatically?

    please help me.

     

     

     


    Mahesh Kumar-MCTS Microsoft Management services
    Tuesday, November 16, 2010 5:35 AM
  • Hi

    Discovery for SQL db runs every 6 hours and should remove it automatically.

    If you want to forcibily remove it sooner then you need to set an override against the appropriate discovery - there are seperate discoveries for SQL Server 2005 DB and SQL 2008 DB (it would be nice if MSFT could standardise their naming convention). But if we look at SQL 2008 DB object discovery - set override for specific DB Engine and then on the Override properties, you have an Exclude list parameter. You can type in the databases to exclude from discovery here.

    The run the remove-disabledmonitoringobject cmdlet from powershell.

    That should remove it.

    Cheers

    Graham


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    Tuesday, November 16, 2010 11:08 AM
  • I have deleted database. Till now 2 days have been passed, but it is still showing in Database state view.

    I don't want to deleted manually. 

    why it is not remove from my database?

    At least it should be look like in gray state. but it is in Green state.

     


    Mahesh Kumar-MCTS Microsoft Management services
    Tuesday, November 16, 2010 11:48 AM
  • I do have an open enhancement request on this on http://connect.microsoft.com  - it is ID 577012, title = Easy way to remove objects from SCOM when an application is uninstalled

    My specific request there was about removing SQL but the same principal applies for SQL databases by the look of things.

    Have you tried overriding the discovery and running remove-disabledmonitoringobject?

    Cheers

    Graham

     


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    • Marked as answer by Yog Li Tuesday, November 23, 2010 9:57 AM
    Tuesday, November 16, 2010 12:12 PM
  • Hi,

    I have Changed the default time out value by 300 to 400 only. Is there any impact by changing this? 


    Mahesh Kumar-MCTS Microsoft Management services
    Wednesday, November 17, 2010 10:29 AM
  • Hi

    Not sure what you mean by "Changed the default time out value" - is that for the discovery?

    Cheers

    Graham


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    Wednesday, November 17, 2010 4:01 PM
  • If you are still having this isue, make sure that the run-as account for the version of SQL MP you are using is set so that it can log into the database server as DBO.  It needs high degree of permissions to discover databases.
    Microsoft Corporation
    Monday, November 22, 2010 4:55 PM