[dba-SQLServer] SSMS priority

Mark Breen marklbreen at gmail.com
Sun Sep 18 10:46:00 CDT 2011


Hi John,

I use coretemp and I like it because I can set it to shut down when my temps
go above a certain temp.
BTW, I run my i7 at 50(idle)  70(busy) degrees C, what do you run your AMD's
at (idle and busy)

Mark


On 17 September 2011 22:50, jwcolby <jwcolby at colbyconsulting.com> wrote:

> 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 <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@**databaseadvisors.com<dba-sqlserver-bounces at databaseadvisors.com>
>> [mailto:dba-sqlserver-bounces@**databaseadvisors.com<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@**databaseadvisors.com<dba-sqlserver-bounces at databaseadvisors.com>
>>> [mailto:dba-sqlserver-bounces@**databaseadvisors.com<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@**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@**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@**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>
>
>



More information about the dba-SQLServer mailing list