jwcolby
jwcolby at colbyconsulting.com
Mon Sep 19 18:43:26 CDT 2011
> Your app and your automation of that work is really amazing. Thanks Mark. It is amazing and amazingly fun to do. It is also very difficult. I have a manager and three different supervisor classes all running threads to perform all of the pieces so that these records can be exported, processed through Accuzip (third party software) on a virtual machine, and re-imported "in parallel". Trying to synchronize all of that is difficult, and took a lot of debugging to get working as well as I have. That many threads all working at essentially the same task can be daunting especially when it comes time to step through code. Each thread gets a step, in rotation which is just confusing to watch / step through! It turns out you can stop threads manually to work around that but then if they are supposed to be doing something... But it is fun. Until SQl Server blue screens and all of those threads lose contact with the server. Incredibly we are working through this scenario as well and causing the software to pick back up when SQl Server comes back up. But in the end, with software this complex there is always something to deal with. John W. Colby www.ColbyConsulting.com On 9/19/2011 6:49 PM, Mark Breen wrote: > Hi John, > > thanks for the reply, > > I was working on an AMD Phenom II x4 840 for the last few days and it never > went above 19 degrees C on idle and 32 degrees C on 100% Prime95 torture > test. Your temps are more like what I experience. > > Your app and your automation of that work is really amazing. > > Mark > > > On 19 September 2011 22:32, jwcolby<jwcolby at colbyconsulting.com> wrote: > >> 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 >> >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >