Performance counter name of "Error/Sec"

  • Hi Friends,

    I configured alert for counter name of "Errors/Sec", In this alert received daily at 10:00 PM, Please suggestion me, how to troubleshoot as below alert?

    DATE/TIME:2/24/2011 10:00:41 PM

    DESCRIPTION:The SQL Server performance counter 'Errors/sec' (instance 'Info Errors') of object 'SQLServer:SQL Errors' is now above the threshold of 1.00 (the current value is 2.95).

    Thanks

    ananda

  • I couldn't possibly tell you what to do without knowing what errors are involved. Check the SQL Server error logs. In Management Studio, expand the management box and it's under SQL Server logs

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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