Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-29 Thread Barry Chesterman
Hi Charlie, I have checked our client variables pages and there aren't any DSN's listed (just the default option of registry selected), I've checked the cfapplication tag for the site too and it uses the default (registry). I'll log full query stats for a day anyhow and see if it shows us

RE: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-29 Thread charlie arehart
, November 29, 2010 3:41 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time Hi Charlie, I have checked our client variables pages and there aren't any DSN's listed (just the default option of registry selected), I've

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread Barry Chesterman
*From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *Barry Chesterman *Sent:* Friday, November 26, 2010 5:17 PM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time Hey guys

RE: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread charlie arehart
SQL server CPU very high, close to 100% a lot of the time Thanks Charlie, It is SQL running on its own box, I'll get the DBA to check what else is running (such as antivirus). I'm pretty sure he checked the event logs and there was nothing odd there, he pretty much said that the query

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread Barry Chesterman
It is looking like a 'death of a thousand cuts' issue as you put it, and we do have a plan if that is the case :) We have limits on the JDBC stuff in fusionreactor because we haven't really needed to use it. Our DBA is fairly certain that there isn't a set of, or a specific query that is causing

RE: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread charlie arehart
, November 28, 2010 8:25 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time It is looking like a 'death of a thousand cuts' issue as you put it, and we do have a plan if that is the case :) We have limits on the JDBC

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread Gavin Beau Baumanis
] On Behalf Of Barry Chesterman Sent: Sunday, November 28, 2010 8:25 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time It is looking like a 'death of a thousand cuts' issue as you put it, and we do have a plan

RE: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-28 Thread charlie arehart
that helps. /charlie From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Gavin Beau Baumanis Sent: Sunday, November 28, 2010 11:33 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

RE: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-27 Thread charlie arehart
that helps. /charlie From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Barry Chesterman Sent: Friday, November 26, 2010 5:17 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time Hey guys

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-26 Thread Barry Chesterman
Hey guys, thanks for all the feedback, I'll pass on those ideas to our DBA :) I haven't replied earlier sorry because I've been on holliday up in Auckland to see U2, but we'll follow up some of the ideas here on Monday at work and I'll let you all know if we manage to fix the problem :) Thanks!

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-24 Thread Kym Kovan
On 25/11/2010 12:59, Pat wrote: Good clarifications Kai. Always nice to cut through some of the marketing spin. Carl, swapping out your JDBC drivers would be a fairly small amount of effort to see if it gives you any performance improvements. Are we drifting off-track? The OP complaint was

Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time

2010-11-23 Thread Kai Koenig
Just a quick note to make a few things clear: - the type doesn't reflect on the quality. E.g. a type 4 driver is not better than a type3 driver and a type5 driver not necessary better than a type4 driver. They just do things in different ways. I just want to avoid that the type is seen as a