[dba-SQLServer] How to troubleshoot a blue screen

jwcolby jwcolby at colbyconsulting.com
Tue Jun 19 11:54:24 CDT 2012


Yea, and I am going to do that.  With 64 gigs of memory it will be more than "a few hours"!  ;)

It may be that the problem was a SSD which died Monday morning.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it


On 6/19/2012 9:17 AM, Francisco Tapia wrote:
> if you have some time, you can test the RAM easily by just downloading the
> memtest application to a cd rom boot to it let it run for a few hours, if
> it's ram related it'll show up in the monitor.
>
> http://www.memtest.org/
>
>
>
> -Francisco
> http://bit.ly/sqlthis   | Tsql and More...
> Let Apple know you want turn by turn on your iPhone 4!
> https://plus.google.com/112803888444646122406/posts/HmQej9pHZQM
>
> <http://db.tt/JeXURAx>
>
>
>
>
> On Sat, Jun 16, 2012 at 7:53 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:
>
>> My SQL Server blue screens about once a month or so.  It does not appear
>> to be heat related, or at least CPU heat related as I have top flight HSFs
>> which hold the temps below 35 C.  The temps in the case stay around that
>> temperature or below.  The blue screens appear to be SQL Server related, as
>> they seem to be triggered by my doing something in SSMS.  This last time I
>> started an update query and it immediately blue screened, by which I mean I
>> clicked start (the query) and the blue screen occurred.
>>
>> This is an AMD dual cpu server, both CPUs populated.  32 gigs ECC RAM on
>> each side.  Being a server there is no overclocking.  There is a lot going
>> on hardware wise however.  I use an Areca 16 port RAID controller, RAID 6
>> arrays built from 1 tb WD black drives.  I am using SSDs to create a Raid1
>> array hosting several of my Read Mostly databases.  The specific update
>> that caused the blue screen was not on SSD however, it was on the Areca
>> rotating media raid 6.
>>
>> I am at a loss on how to troubleshoot.  It "feels" like it must be a
>> memory problem, and yet the memory is ECC.  Perhaps I have a bad DIMM which
>> just flakes out.
>>
>> --
>> John W. Colby
>> Colby Consulting
>>
>> Reality is what refuses to go away
>> when you do not believe in it
>>
>>
>> ______________________________**_________________
>> dba-SQLServer mailing list
>> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com>
>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver>
>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list