SQLServer causing Windows to crash

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: GriffithsJ (GriffithsJ_520_at_hotmail.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 11:27:59 +0100

I have the following set up:

Windows 2000 (5.00.2195) sp3
Dual Xeon 2.7 GHz processor
2 GB RAM
RAID 5 disks (10,000 RPM)

SQLServer 2000 (8.00.760) sp3a (I believe, though reports as sp3)
Memory dynamically configured.

Problem:
We export data and upload this on to the database. The upload file is read
by a VB app which simply imports the data either by providing parameters to
several stored procedures or by doing bulk imports. This app has run well
for years and I'm confident that it is not to blame.

During this process the server crashes. There is no sign of a DUMP file
(the server is configured to provide a complete memory.dmp file), so it
appears as if an interrupt failed to fire.

We monitor the process and just before it falls over, the system is as
follows:
1 - CPU was flat-lining at 100% cpu
2 - SQLServer was taking 1.717 GB of memory
3 - Kernel was taking virtually no CPU

The VB app logs the stages it's at.

It reported that it was currently creating the indexes on a particular
table.

The table in question has ~ 11 million rows in it. The schema for the table
is attached.

I ran various diagnostics, each one reporting no errors. The diagnostics
were as follows:
1 - sp_server_info
2 - dbcc checkdb
3 - dbcc checkalloc
4 - dbcc checkfilegroup
5 - showcontig

----------
Any suggestions as to:
a) what's going on
b) what I can do to prevent it
c) whether there are any other diagnostics I can run that may be of use

One other oddity....the event log claimed "The previous system shutdown at
09:51:31 on 20/05/2004 was unexpected." and yet we were still monitoring
it's dying moments at least 5 minutes later than 09:51.31 (based on the
server clock). It definitely did re-boot though.

Thanks in advance

Griff

begin 666 dbo.accountProducts.TAB
M+RHJ*BHJ*B!/8FIE8W0Z("!486)L92!;9&)O72Y;86-C;W5N=%!R;V1U8W1S
M72 @("!38W)I<'0@1&%T93H@,C O,#4O,C P-" Q,#HU.#HQ-B J*BHJ*BHO
M#0II9B!E>&ES=',@*'-E;&5C=" J(&9R;VT@9&)O+G-Y<V]B:F5C=',@=VAE
M<F4@:60@/2!O8FIE8W1?:60H3B=;9&)O72Y;86-C;W5N=%!R;V1U8W1S72<I
M(&%N9"!/0DI%0U104D]015)462AI9"P@3B=)<U5S97)486)L92<I(#T@,2D-
M"F1R;W @=&%B;&4@6V1B;UTN6V%C8V]U;G10<F]D=6-T<UT-"D=/#0H-"D-2
M14%412!404),12!;9&)O72Y;86-C;W5N=%!R;V1U8W1S72 H#0H)6V%C8V]U
M;G10<F]D=6-T261=(%MI;G1=($E$14Y42519("@Q+" Q*2!.3U0@3E5,3" L
M#0H)6W-U<'!L:65R261=(%MV87)C:&%R72 H,38I($-/3$Q!5$4@3&%T:6XQ
M7T=E;F5R86Q?0TE?05,@3E5,3" L#0H)6W!R;V1U8W1#;V1E72!;=F%R8VAA
M<ET@*#(P*2!#3TQ,051%($QA=&EN,5]'96YE<F%L7T-)7T%3($Y53$P@+ T*
M"5MA8V-O=6YT3F%M95T@6W9A<F-H87)=("@X*2!#3TQ,051%($QA=&EN,5]'
M96YE<F%L7T-)7T%3($Y53$P@+ T*"5MA8V-O=6YT4')O9'5C=$-O9&5=(%MV
M87)C:&%R72 H,C I($-/3$Q!5$4@3&%T:6XQ7T=E;F5R86Q?0TE?05,@3E5,
M3" L#0H)6V%C8V]U;G10<F]D=6-T1&5S8W)I<'1I;VY=(%MV87)C:&%R72 H
M,C4U*2!#3TQ,051%($QA=&EN,5]'96YE<F%L7T-)7T%3($Y53$P@+ T*"5MA
M8V-O=6YT4V5L;&EN9U!E<ET@6VEN=%T@3E5,3" L#0H)6W!A8VM3<&QI='1A
M8FQE72!;=F%R8VAA<ET@*#$I($-/3$Q!5$4@3&%T:6XQ7T=E;F5R86Q?0TE?
M05,@3E5,3" L#0H)6W!R;V1U8W1/;D-O;G1R86-T72!;:6YT72!.54Q,("P-
M"@E;<')O;6]T:6]N4')I8V5D4')O9'5C=%T@6VEN=%T@3E5,3" L#0H)6W5N
M:710<FEC95T@6VEN=%T@3E5,3" L#0H)6V)A;F0Q475A;G1I='E=(%MI;G1=
M($Y53$P@+ T*"5MB86YD,5-E;&Q686QU95T@6VEN=%T@3E5,3" L#0H)6V)A
M;F0R475A;G1I='E=(%MI;G1=($Y53$P@+ T*"5MB86YD,E-E;&Q686QU95T@
M6VEN=%T@3E5,3" L#0H)6V)A;F0S475A;G1I='E=(%MI;G1=($Y53$P@+ T*
M"5MB86YD,U-E;&Q686QU95T@6VEN=%T@3E5,3" L#0H)6V)A;F0T475A;G1I
M='E=(%MI;G1=($Y53$P@+ T*"5MB86YD-%-E;&Q686QU95T@6VEN=%T@3E5,
M3" L#0H)6V)A;F0U475A;G1I='E=(%MI;G1=($Y53$P@+ T*"5MB86YD-5-E
M;&Q686QU95T@6VEN=%T@3E5,3" L#0H)6V)A;F0V475A;G1I='E=(%MI;G1=
M($Y53$P@+ T*"5MB86YD-E-E;&Q686QU95T@6VEN=%T@3E5,3" L#0H)6W9A
M=$-O9&5=(%MV87)C:&%R72 H,BD@0T],3$%412!,871I;C%?1V5N97)A;%]#
M25]!4R!.54Q,("P-"@E;<V]R=%!R:6]R:71Y72!;:6YT72!.54Q,("P-"@E;
M9&5L971E9%T@6VEN=%T@3E5,3" L#0H)6V1E<V-R:7!T:6]N0VAU;FMS06-C
M;W5N=$-O9&5=(%MV87)C:&%R72 H,C I($-/3$Q!5$4@3&%T:6XQ7T=E;F5R
M86Q?0TE?05,@3E5,3" -"BD@3TX@6U!224U!4EE=#0I'3PT*#0H@0U)%051%
M("!#3%535$52140@($E.1$58(%MA8V-O=6YT4')O9'5C='-?86-C;W5N=$YA
M;65?86YD7W-U<'!L:65R261?86YD7W!R;V1U8W1#;V1E26YD97A=($].(%MD
M8F]=+EMA8V-O=6YT4')O9'5C='-=*%MA8V-O=6YT3F%M95TL(%MS=7!P;&EE
M<DED72P@6W!R;V1U8W1#;V1E72P@6V1E<V-R:7!T:6]N0VAU;FMS06-C;W5N
M=$-O9&5=*2!/3B!;4%))34%265T-"D=/#0H-"B!#4D5!5$4@($E.1$58(%MA
M8V-O=6YT4')O9'5C='-?86-C;W5N=%!R;V1U8W1)9$EN9&5X72!/3B!;9&)O
M72Y;86-C;W5N=%!R;V1U8W1S72A;86-C;W5N=%!R;V1U8W1)9%TI($].(%M0
14DE-05)970T*1T\-"@T*#0H`
`
end

Relevant Pages

  • SQLServer causing Windows to crash
    ... During this process the server crashes. ... - CPU was flat-lining at 100% cpu ... I ran various diagnostics, ... - dbcc checkalloc ...
    (microsoft.public.sqlserver.server)
  • SQLServer causing Windows to crash
    ... During this process the server crashes. ... - CPU was flat-lining at 100% cpu ... I ran various diagnostics, ... - dbcc checkalloc ...
    (microsoft.public.windows.server.general)
  • Performance Problems.. Server hardware smoked by $500 box?
    ... webserver with a separate db/file server sitting behind it. ... Now granted the development machine has the most Mhz, ... CPU: Intel Pentium III Origin = ... Ubench CPU: 25713 ...
    (freebsd-performance)
  • Performance Problems.. Server hardware smoked by $500 box?
    ... webserver with a separate db/file server sitting behind it. ... Now granted the development machine has the most Mhz, ... CPU: Intel Pentium III Origin = ... Ubench CPU: 25713 ...
    (freebsd-questions)
  • Re: Chat server : Threading in select call
    ... on the same CPU. ... the server continues to make forward progress on ... For example, in the typical case, the server handles each request as ... any server where there is tight integration between connections (one ...
    (comp.unix.programmer)