[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.
>