jwcolby
jwcolby at colbyconsulting.com
Mon Sep 19 16:32:21 CDT 2011
Mark, I run it at whatever temp it runs at. ;) I had moved the main server as well as my UnRaid server to the basement to get the noise and heat out of my office. I surrounded it with a plywood wall to keep inquisitive fingers out. It turns out that by taking the end piece of plywood off (the hot exhaust side) I managed to drop the temps by several degrees, So now it is running at 52C idle and about 61C under full load. And I managed to assign another two cores to SQL Server without pushing the temps up to the blue screen point. At this moment I have 14 cores maxed out. 88% processor utilization of a 16 core server, with 35.6 gigs of Ram in use. BTW I was just checking the times to perform some of my process. I had built two "temp" databases on rotating media and was doing a process which carves out 1 million records and writes them to file. It was taking about 10-15 minutes per file to do that. This afternoon I moved those databases to my SSD and the times are down to about 4-5 minutes. Given that I have to build 157 of these files for this particular job, that makes a huge difference. John W. Colby www.ColbyConsulting.com On 9/18/2011 11:46 AM, Mark Breen wrote: > 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> >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >