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

2010-11-23 Thread BarryC
Hi, We have an issue currently where our Microsoft SQL server runs close to 100% CPU for a lot of the time. There also seems to be a lack of memory cache hits (we would expect a reasonable amount given the traffic for our site). Our website generates a lot of small queries (approximately 200odd

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

2010-11-23 Thread Steve Onnis
I would say it is from running it on VMWare. I have never had good experiences running SQL server on VMWare. There just isn't the grunt there to do it. I started shifting my SQL servers to VMs and started having CPU issues so i moved them back to physical servers. -Original Message-

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

2010-11-23 Thread Kai Koenig
What Steve says is def. contributing to it. Another thing I'd look into before moving it away from VMWare though would be the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc. How's your disk IO looking on that VM? Cheers Kai On 24/11/2010, at 11:48 AM, Steve Onnis

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

2010-11-23 Thread Joey Daly
We're running SQL Server 2005 quad core on VMWare, and it works fine without any problems. On 24 November 2010 09:48, Steve Onnis st...@cfcentral.com.au wrote: I would say it is from running it on VMWare. I have never had good experiences running SQL server on VMWare. There just isn't the

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

2010-11-23 Thread Carl
Hello Barry, Some people say to obtain maximum performance the JDBC driver should transmit data to the database server in packets that are equal in size to the maximum packet size configured on the database server. For SQL to check packet size: -SQL Management Studio (connect to server etc)

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

2010-11-23 Thread Kym Kovan
On 24/11/2010 09:53, Kai Koenig wrote: What Steve says is def. contributing to it. Another thing I'd look into before moving it away from VMWare though would be the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc. How's your disk IO looking on that VM? We use SQL2008

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

2010-11-23 Thread Pat
I haven't checked in a while but the jtds driver (http:// jtds.sourceforge.net/) used to be faster than default JDBC driver CF come's with for MSSQL On Nov 24, 7:13 am, BarryC barrychester...@gmail.com wrote: Hi, We have an issue currently where our Microsoft SQL server runs close to 100% CPU

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

2010-11-23 Thread Carl
Hello Pat, I use the divers built in CF. The JDBC divers in CF8/9 are type4. I see datadirect has released jdbc type5 drivers: http://web.datadirect.com/products/jdbc/index.html Regards, Carl. I haven't checked in a while but the jtds driver (http:// jtds.sourceforge.net/) used to be faster

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

[cfaussie] Does a service require Application.cfc/cfm

2010-11-23 Thread Gavin Beau Baumanis
Hi Everyone, Most will be aware that (at my work) I'm currently altering our monolithic application into several discreet services and that we're using Robin Hilliard's (Rocketboots) open source Galaxy service, service. It's all progressing quite nicely - but I have an (almost) silly question.