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

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.

RESOLUTION

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.

File name	File version	File size	Date	Time
Dasserver.dll	5.0.2911.30	4,041,968	04-Feb-2006	01:20

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://www.microsoft.com/technet/prodtechnol/mom/mom2000/mompfsiz.mspx

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