[dba-SQLServer] SSMS priority

I am using speedfan.  That is how I determined that I was pushing the envelope.  It is OK but not 
great, it does the job.  It doesn't see all of the cores, but it does return the temps of both dies 
in the MCM that is the AMD processor.

 > Also, it may be time to go to refrigerated liquid cooling.

No, I really don't want to go there.

I am using a 4U cabinet and could use a push/pull cooler (fan on both sides) but for this socket 
they are about $90 each.  I will do that as a last resort.

I really get the feeling that one of the HSFs is not seated properly.  There is no other explanation 
for a 10 degree C difference between the sockets at idle.

John W. Colby
www.ColbyConsulting.com

On 9/17/2011 5:22 PM, Jim Lawrence wrote:
> Hi John:
>
> Here is a little program that might help you with monitoring heating issue:
> http://www.almico.com/speedfan.php
>
> It is a free download and can monitor fan speeds, CPU temperatures, can send
> you an email if a threshold is exceeded and is customizable for specific
> motherboards and circuitry.
>
> Also, it may be time to go to refrigerated liquid cooling.
>
> Jim
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Saturday, September 17, 2011 11:43 AM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] SSMS priority
>
> LOL, yep.  I have a server with about 16 hard drives, plus a 16 port raid
> controller, plus two amd
> 6128 processors plus eight 8 gb dimms.
>
> Plenty of heat generated there.
>
> After the blue screen i changed the fan wall between the disks and the
> motherboard area, changing to
> thhree 120 mm fans.  That helped a lot.  Went back to my jet engine exhaust
> fans.  They are loud but
> pull tons of air out of the case.
>
> The processor hsf is the real issue.  I have ordered an adapter to use a
> 120mm fan on those.  That
> will get as much air blowing on them as I am ever going to get.
>
> I think I need to remove and reinstall the hsf on both sockets.  One is 10
> degrees C hotter than the
> other.  Something wrong there.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 9/17/2011 1:36 PM, Jim Lawrence wrote:
>> You need a cooling kit and a few more fans. ;-)
>>
>> Jim
>>
>>
>> -----Original Message-----
>> From: dba-sqlserver-bounces at databaseadvisors.com
>> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Saturday, September 17, 2011 6:55 AM
>> To: Sqlserver-Dba
>> Subject: [dba-SQLServer] SSMS priority
>>
>> I am running a query which is maxing out all 12 cores assigned to SQL
>> Server.  Just as an aside i
>> had to reduce the number of cores assigned in order to reduce the
>> temperature of the cores below
>> where it would blue screen.
>>
>> In any event I now have 4 cores and 8 gigs assigned to the OS (Windows
>> 2008R2), or more correctly
>> not assigned to SQL Server.
>>
>> My issue is that when all the resources are in use, SSMS responds very
>> slowly.  For example I opened
>> SSMS and clicked on the databases tree and it took several minutes to drop
>> down.  After that things
>> took 10 seconds to 30 seconds which normally take a second.
>>
>> Is there a setting somewhere which will tell sql server to leave some
>> resources for SSMS, or
>> basically for any process other than the thing it is currently doing.  In
>> this case it is running a
>> simple append query, about 7 fields, from one database / table (index on
>> those 7 fields) to another
>> database / table.
>>
>> In this specific case I am trying to copy these 7 fields for about 150
>> million records, rotating
>> media for both databases, and for some reason it is incredibly slow.  The
>> records do have to be
>> inserted in sorted order, sorted on 3 fields.
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>