I've recently got a new server hardware, thats having dual AMD OPTERON 6
core CPU x64 processors

The OS I am running is Win2K3 R2, SP2 wiith all latest patch updated.

Installing SQL2000 x86 in RTM version did not have any issue, and services
are all running fine.
The problem came about when I attempt to update it to SP4, I consistently
get the following error pop ups.

A service control operation failed for the MSSQL service:1460
This operation returned becaused the timeout period expired

An error occured starting the service to build system catalogs

Attempts to run SQLservice thereafter will fail.

I got the following error messages when I try to start the service

D:\MSSQL\Binn>sqlservr.exe
2010-04-22 16:10:59.90 server Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to d:\MSSQL\log\SQLDump0003.txt
*
************************************************** ****************************
*
*
* BEGIN STACK DUMP:
* 04/22/10 16:10:59 spid 0
*
* Exception Address = 7D4E237E (RaiseException + 0000004E Line 0+00000000)
* Exception Code = 400042ac PRINTSTACK
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* ntdll 7D600000 7D6EFFFF 000f0000
* kernel32 7D4C0000 7D5EFFFF 00130000
* ADVAPI32 7D1E0000 7D27BFFF 0009c000
* RPCRT4 7DA20000 7DAFFFFF 000e0000
* Secur32 7D8D0000 7D91FFFF 00050000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C8D0000 7D0CEFFF 007ff000
* msvcrt 77BA0000 77BF9FFF 0005a000
* GDI32 7D800000 7D88FFFF 00090000
* USER32 7D930000 7D9FFFFF 000d0000
* SHLWAPI 7D180000 7D1D1FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 7DEE0000 7DF3FFFF 00060000
* comctl32 7DBD0000 7DCD2FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* dbghelp 02800000 028FFFFF 00100000
*
* Edi: 00000000:
* Esi: 00000000:
* Eax: 001CE82C: 400042AC 00000000 00000000 7D4E237E 00000000
00000A
F4
* Ebx: 00000000:
* Ecx: 001D33F8: 001D3780 001D3980 00000000 00000000 00030008
000A01
9C
* Edx: 001D3780: 00000000 00000000 00000000 00000000 00030004
000801
EF
* Eip: 7D4E237E: 10C2C95E C0658300 90EBEB00 90909090 8B55FF8B
08458D
EC
* Ebp: 001CE87C: 001CE8B8 009BA6EB 400042AC 00000000 00000000
000000
00
* SegCs: 7D4D0023: 61DCA27D 61DFBA7D 61E0F27D 61CB797D 61C9397D
61C879
7D
* EFlags: 00000246:
* Esp: 001CE828: 00000000 400042AC 00000000 00000000 7D4E237E
000000
00
* SegSs: 0000002B:
*
************************************************** ****************************
*
*
------------------------------------------------------------------------------
-
* Short Stack Dump
* 7D4E237E Module(kernel32+0002237E) (RaiseException+0000004E)
* 009BA6EB Module(sqlservr+005BA6EB) (GetOSErrString+000055C7)
* 009BAB30 Module(sqlservr+005BAB30) (GetOSErrString+00005A0C)
* 00A997CF Module(sqlservr+006997CF) (CDStream::PrintDumpHeader+000DA6F3)
* 0061C36F Module(sqlservr+0021C36F) (SQLExit+000B4878)
* 00565573 Module(sqlservr+00165573)
* 005B26DA Module(sqlservr+001B26DA) (SQLExit+0004ABE3)
* 005B37AB Module(sqlservr+001B37AB) (SQLExit+0004BCB4)
* 7D4E7D42 Module(kernel32+00027D42) (BaseProcessInitPostImport+0000008D)
*
------------------------------------------------------------------------------
-

2010-04-22 16:11:02.25 server SQL Server Assertion: File: <serverma.c>,
line=
2833
Failed Assertion = '(numSMT & (numSMT - 1)) == 0'.
2010-04-22 16:11:02.25 server PSS NULL for assert - raising
EXCEPTION_ILLEGAL
_INSTRUCTION
2010-04-22 16:11:02.25 server Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to d:\MSSQL\log\SQLDump0004.txt
2010-04-22 16:11:02.25 server SqlDumpExceptionHandler: Process 2520
generated
fatal exception c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is
terminati
ng this process.
*
************************************************** ****************************
*
*
* BEGIN STACK DUMP:
* 04/22/10 16:11:02 spid 0
*
* Exception Address = 7D4E237E (RaiseException + 0000004E Line 0+00000000)
* Exception Code = c000001d EXCEPTION_ILLEGAL_INSTRUCTION
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* ntdll 7D600000 7D6EFFFF 000f0000
* kernel32 7D4C0000 7D5EFFFF 00130000
* ADVAPI32 7D1E0000 7D27BFFF 0009c000
* RPCRT4 7DA20000 7DAFFFFF 000e0000
* Secur32 7D8D0000 7D91FFFF 00050000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C8D0000 7D0CEFFF 007ff000
* msvcrt 77BA0000 77BF9FFF 0005a000
* GDI32 7D800000 7D88FFFF 00090000
* USER32 7D930000 7D9FFFFF 000d0000
* SHLWAPI 7D180000 7D1D1FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 7DEE0000 7DF3FFFF 00060000
* comctl32 7DBD0000 7DCD2FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* dbghelp 02800000 028FFFFF 00100000
*
* Edi: 001CF0F4: 00650073 00760072 00720065 0061006D 0063002E
00A900
00
* Esi: 00000000:
* Eax: 001CF050: C000001D 00000000 00000000 7D4E237E 00000000
000000
0B
* Ebx: 001CF0B8: 006E0028 006D0075 004D0053 00200054 00200026
006E00
28
* Ecx: 2A2A37F2:
* Edx: 00000000:
* Eip: 7D4E237E: 10C2C95E C0658300 90EBEB00 90909090 8B55FF8B
08458D
EC
* Ebp: 001CF0A0: 001CF84C 00A999BA C000001D 00000000 00000000
000000
00
* SegCs: 00000023:
* EFlags: 00000246:
* Esp: 001CF04C: 0000003A C000001D 00000000 00000000 7D4E237E
000000
00
* SegSs: 7C34002B: 00000000 00000000 00000000 00000000 0000F000
BA1F0E
00
*
************************************************** ****************************
*
*
------------------------------------------------------------------------------
-
* Short Stack Dump
* 7D4E237E Module(kernel32+0002237E) (RaiseException+0000004E)
* 00A999BA Module(sqlservr+006999BA) (CDStream::PrintDumpHeader+000DA8DE)
* 0061C36F Module(sqlservr+0021C36F) (SQLExit+000B4878)
* 00565573 Module(sqlservr+00165573)
* 005B26DA Module(sqlservr+001B26DA) (SQLExit+0004ABE3)
* 005B37AB Module(sqlservr+001B37AB) (SQLExit+0004BCB4)
* 7D4E7D42 Module(kernel32+00027D42) (BaseProcessInitPostImport+0000008D)
*
------------------------------------------------------------------------------
-

2010-04-22 16:11:02.32 server SQL Server is aborting. Fatal exception
c000001
d caught.

JimmyBoy (JimmyBoy (AT) discussions (DOT) microsoft.com) writes:
I found this link:
http://blogs.msdn.com/sqlserverfaq/a...ower-of-2.aspx

It certainly seems applicable to your case as you have a 6-core CPU.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland

the blog solution works flawlessly, thank you so much for your pointers.

"Erland Sommarskog" wrote: