[dba-SQLServer] SSMS priority

I have aftermarket heat pipe HSFs but they are just not enough by themselves.

John W. Colby
www.ColbyConsulting.com

On 9/17/2011 2:03 PM, Dan Waters wrote:
> Ah - Cooling!  I discovered on my box that straight through air flow worked
> a lot better.  I originally started with the OEM fan that blew straight down
> onto the processor and motherboard, but temps seemed a little high.  Then I
> got a CPU cooler that has tubes which are cooled by a 'radiator' assembly
> with a fan attached which complemented the airflow I already had going from
> front to back.  Temps went down several degrees.  That cooler cost<  $50, so
> it was a good buy.  You can also get two fans for those coolers which might
> help.
>
> Dan
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
> Lawrence
> Sent: Saturday, September 17, 2011 12:36 PM
> To: 'Discussion concerning MS SQL Server'
> Subject: Re: [dba-SQLServer] SSMS priority
>
> 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.
>
> --
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>