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 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=true;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.