Dan Waters
df.waters at comcast.net
Sat Sep 17 13:03:04 CDT 2011
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