sql cluster server configuration utility shows blank data

sql cluster server configuration utility shows blank data

Post by bpila » Wed, 16 Aug 2006 17:16:49


i there,

We are facing an issue with the failover cluster of sql server 2000 sp4.
It is running on a windows 2003 server with sql server 2000 sp4 and
clustered [build 2187]
memory 64 GB


Error causing sql restart is:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------CImageHelper::Init () Failed load of symbol file with path =C:\PROGRA~2\MICROS~2\MSSQL\binn\;;C:\Program Files (x86)\Microsoft SQLServer\MSSQL\BINN;C:\WINDOWS;C:\WINDOWS\system32 - Not enough storage isavailable to process this command.CImageHelper::Init () Failed load of symbol file with path =C:\PROGRA~2\MICROS~2\MSSQL\binn\;;C:\Program Files (x86)\Microsoft SQLServer\MSSQL\BINN;C:\WINDOWS;C:\WINDOWS\system32 - Not enough storage isavailable to process this command.***Symbol load failed - Proceed to dump without any symbols*Stack Dump being sent to D:\Program Files (x86)\Microsoft SQLServer\MSSQL\log\SQLDump0014.txtSqlDumpExceptionHandler: Process 5876 generated fatal exception c0000005EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.********************************************************************************** BEGIN STACK DUMP:* 08/15/06 16:44:03 spid 0** Exception Address = 7D620DCE* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION* Access Violation occurred reading address 00000001** MODULE BASE END SIZE** Edi: 002975B8: 00050002 000800B8 1B5A9710 00215968 0000000000000000* Esi: 002975C8: 00000000 00000000 00000002 00000001 0000000600002000* Eax: 002975D0: 00000002 00000001 00000006 00002000 0000000100000001* Ebx: 001D0000: 000000C8 0000010F EEFFEEFF 00000002 000000000000FE00* Ecx: 00000001:* Edx: 00000002:* Eip: 7D620DCE: 4A3B098B 14558904 2948850F C83B0000 2940850F53560000* Ebp: 1F27FDF8: 1F27FEE0 7D620EA5 001D0000 00000001 1F27FEC000000000* SegCs: 00000023:* EFlags: 00010246: 0053006D 00650070 003D0063 003A0043 0057005C004E0049* Esp: 1F27FDEC: 001D0000 002975B8 00000000 1F27FEE0 7D620EA5001D0000* SegSs: 0000002B:********************************************************************************* -------------------------------------------------------------------------------* Short Stack Dump* 7D620DCE Module(UNKNOWN+00000000)* 7D620EA5 Module(UNKNOWN+00000000)* 7D636994 Module(UNKNOWN+00000000)* 7D62B977 Module(UNKNOWN+00000000)* 7D4E0A7F Module(UNKNOWN+00000000)* 7D4E072F Module(UNKNOWN+00000000)* ----- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Looked into articles on this type of sql error found closest to my error.FIX: SQL Server Access Violation During SSL Connection Article ID : 312948 Last Review : October 16, 2003 Revision : 1.0This article was previously published under Q312948BUG #: 354184 (SHILOH_BUGS) BUG #: 354082 (SHILOH_BUGS)SYMPTOMSSQL Server 2000 may encounter an exception (access violation) during clientlogons when either the client or the server is configured for encryptednetwork communications (SSL encryption).CAUSEThis exception is caused by a failed memory allocation during a connectionrequest to SQL Server when Network L
 
 
 

sql cluster server configuration utility shows blank data

Post by Geoff N. H » Thu, 17 Aug 2006 01:24:45

hat are is your MAX_SERVER_MEMORY set to for SQL?

Are you using /PAE and/or /3GB in your boot.ini file?

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"bpilak" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

sql cluster server configuration utility shows blank data

Post by bpila » Thu, 17 Aug 2006 08:04:48

ax server memory is set to 15.5 GB [Physical memory in the box 16 GB]
It is a 64-bit machine with windows 64-bit server installed.
No need for /PAE and /3GB and we dont have them in boot.ini file.

Thanks
Bhaskar
"Geoff N. Hiten" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...

 
 
 

sql cluster server configuration utility shows blank data

Post by Geoff N. H » Thu, 17 Aug 2006 09:30:40

rop max server memory to 14GB.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"bpilak" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...