SQL Server Performance

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Errors in Event Source:WinMgmt ID:10 /Event ID:3315

Discussion in 'SQL Server 2005 General DBA Questions' started by snivas, Nov 28, 2011.

  1. snivas Member

    Dear all,

    I have Windows 2003 cluster server with Microsoft SQL Server 2005 - 9.00.1399.06 (X64) and regularly it is loging an error

    Event Type: Error
    Event Category: (2)
    Event ID: 3315
    Date: 11/28/2011
    Time: 4:38:35 PM
    User: N/A
    During rollback, the following process did not hold an expected lock:
    process 10 with mode 8 at level 2 for row Rid pageid is (1:599823) and row num is 0x0 in database 'userdB' under transaction (1:1763464765).
    Restore a backup of the database, or repair the database.

    Event Type: Error
    Event Source: WinMgmt
    Event Category: None
    Event ID: 10
    Date: 11/28/2011
    Time: 4:56:04 PM
    User: N/A
    Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'"
    could not be (re)activated in namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error 0x80041010.
    Events may not be delivered through this filter until the problem is corrected.
    Is above error are due to Service pack problems or some thing else related storage ?

    Thanks in advance.
  2. satya Moderator

    You got some serious issues on the database consistency there, when was the last time DBCC CHECKDB or CHECKTABLE is executed on this database?

Share This Page