Post reply

Does we should worry about informational message in error logs?

  • October 7, 2010 at 7:36 am

    #241381

    Hi,

    SQL Server Logs some Informational messages in error log. I have found like "This instance of SQL Server has been using a process ID of 1588 since datetime"

    Does we should be worry about informational message in error logs. Can some one help me to understand why SQL server informs us to using process id from long time. should I take action as DBA?

    Some Informational messages are understandable but some are not. Is there a detail on internet or on Microsoft sites to understand them?

    Ram
    MSSQL DBA

  • October 7, 2010 at 8:02 am

    #1233588

    Reo (10/7/2010)

    SQL Server Logs some Informational messages in error log. I have found like "This instance of SQL Server has been using a process ID of 1588 since datetime"

    Does we should be worry about informational message in error logs. Can some one help me to understand why SQL server informs us to using process id from long time. should I take action as DBA?

    Some Informational messages are understandable but some are not. Is there a detail on internet or on Microsoft sites to understand them?

    I see informational messages in error logs as events SQL Server wants you to be aware of, not necessarily worried about them.

    Having spare time I would check informational messages and investigate further the ones that call my attention.

    SQL Server KB is plenty of information to help understand such messages.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • October 7, 2010 at 9:11 am

    #1233682

    I tend not to worry about most of them. You could have processes that are connected for a long time, so I wouldn't worry about that. I think that's left over from when we had fewer resources and worried about stalled/stuck connections.

Viewing 3 posts - 1 through 2 (of 2 total)

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