Microsoft KB Archive/913801

= You notice an increase in event and performance data latency after you upgrade the MOM 2005 Server OnePoint database to Microsoft SQL Server 2005 =

Article ID: 913801

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-





SYMPTOMS
After you upgrade the Microsoft Operations Manager (MOM) 2005 Server OnePoint database to Microsoft SQL Server 2005, you notice an increase in event and performance data latency. Additionally, if you use the SQL Profiler tool, SQL trace flag 1204, or SQL trace flag 1222 to monitor the computer that is running Microsoft SQL Server 2005, you notice an unusually high number of deadlocks.



CAUSE
This problem occurs because of a change in the way that SQL Server 2005 handles the TABLOCK hint when SQL Server 2005 processes bulk insert operations.



Update information
The following file is available for download from the Microsoft Download Center:

Download the MOM2005-Shttp://www.microsoft.com/downloads/details.aspx?amp;displaylang=en&familyid=596710CC-CF17-476F-A30C-8973612F4AC7&displaylang=en-KB913801-X86-ENU.MSI package now.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. The Global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
MOM 2005 uses the TABLOCK hint for bulk inserts into the OnePoint database. The way that SQL Server 2005 handles the TABLOCK hint differs from the way that SQL Server 2000 handles the TABLOCK hint. The change causes lots of deadlocks for some of the operations that MOM performs. Overall, these deadlocks do not have a significant affect on the event and performance data latency results. However, if you have an unusually high volume of incoming event and performance data, the changes to the TABLOCK hint can cause the number of deadlocks to reach a level that can cause latency issues.

This update addresses one very specific issue. You may be experiencing additional issues that contribute to the same symptoms or that cause the same symptoms. We recommend that you contact Microsoft Product Support Services (PSS) to help you troubleshoot these symptoms.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

