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 translations Article translations
Article ID: 913801 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.

RESOLUTION

Update information

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

Collapse this imageExpand this image
Download
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.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTime
Dasserver.dll5.0.2911.304,041,96804-Feb-200601:20

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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

REFERENCES

For more information, see the "MOM 2000 SP1 - Performance and Sizing" white paper. To do this, visit the following Web site:
http://technet.microsoft.com/en-us/library/cc750905.aspx
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
298475 How to troubleshoot SQL Server performance issues

Properties

Article ID: 913801 - Last Review: October 9, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Operations Manager (MOM) 2005
Keywords: 
atdownload kbqfe KB913801

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com