Microsoft KB Archive/280074

= BUG: Messages Logged in the Application Log of Windows 2000 Capture SQL Server 7.0 Performance Counters =

Article ID: 280074

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q280074



BUG #: 57324 (SQLBUG_70)



SYMPTOMS
The Application Log in the Event Viewer of any Microsoft Windows 2000 Edition may have the following warning message when SQL Server specific performance counters are captured:

Event ID:1016

The data buffer created for the &quot;MSSQLServer&quot; service in the &quot;C:\WINNT\system32\SQLCTR70.DLL&quot; library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of this library.

These warning messages are benign and the performance data shown by the Performance Monitor is not affected in any way.



CAUSE
Microsoft SQL Server 7.0 uses 4-byte alignment for performance data. However, starting with Windows 2000 and later, the alignment changes to 8-byte alignment. Because Microsoft Windows 2000 was released after Microsoft SQL Server 7.0, 8-byte alignment is only propagated in versions of SQL Server released after Windows 2000, starting with SQL Server 2000.



WORKAROUND
Because this problem is fixed in SQL Server 2000, upgrading to SQL Server 2000 resolves the problem.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: perflib

Keywords: kbbug kbpending KB280074

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.