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 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 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----- > From: BarryC [mailto:barrychester...@gmail.com] > Sent: Wednesday, 24 November 2010 8:14 AM > To: cfaussie > Subject: [cfaussie] Microsoft SQL server CPU very high, close to 100% a lot > of the time > > 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 > queries a second on average, which includes all our cluster servers), > most of these queries complete in under 2 or 3 milliseconds. > > Has anyone had anything similar to this, or may know of any related > issues to do with the servers / software versions we are running? this > is our configuration; > > Microsoft SQL server 2008, single CPU on VMWare. > Coldfusion 9 (no updaters) - runs on Linux Red Hat servers with JRun > 4. > Our Coldfusion datasource driver is the Microsoft SQL server drvier > that ships with CF 9. > > Our datasource configuration parameters are: > > Driver: MSSQLServer > JDBC URL: jdbc: macromedia:sqlserver://ourservername: > 1433;databaseName=dbprod;SelectMethod=direct;sendStringParametersAsUnicode=t > rue;querytimeout=0;MaxPooledStatements=1000 > Login timeout: 30 seconds > Long text buffer size: 256000 > Timeout: 1200 seconds > Maintain connections: Yes > Interval: 420 seconds > Restricted SQL operations: > Disable connections: No > CLOB is enabled (as well as High ASCII characters) > > > I know this isn't an SQL group, but someone might have run into this > before :) > > It is possible we just need to add another CPU to our DB server, but > we are trying to eliminate other possible issues first. > > Thanks > Barry > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaus...@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > > > > > > ======= > Email scanned by PC Tools - No viruses or spyware found. > (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16350) > http://www.pctools.com/ > ======= > > > > > > ======= > Email scanned by PC Tools - No viruses or spyware found. > (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16350) > http://www.pctools.com/ > ======= > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaus...@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de twitter: http://www.twitter.com/agentK !!! New AU mobile number !!! -- -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
