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.
