There is one datasource and one database. Every single query in the JDBC history is "finished". I notice two different ways in which the datasource is reported in FR. We have CFML queries with look like this: <cfquery datasource="#application.dsn#" ...> where application.dsn is set to "ourdatasource". and these are reported as "ourdatasource" in FR. These queries are used on the front-end of the website e.g. category and product pages (ecommerce site). Then, I see another datasource which is reported by our back-end ecommerce system, these look like this: sqlserver@listener:1433/OURDB listener points to our primary SQL server. It's latency is very low. We have a fail-over system where "listener" can change to the IP of our secondary SQL server. This has never been needed yet (we are with our current provider for only 12 months). I recognise the listener:1433/OURDB form of the datasource from our datasource setup within ColdFusion, where the setup string for our datasource "ourdatasource" is set to: jdbc:sqlserver://listener:1433;databaseName=OURDB;SelectMethod=direct;sendStringParametersAsUnicode=false;querytimeout=90 where OURDB is our database name. It seems that FR is reporting two forms of thedatasource, even though we only have one datasource set up in the CF Admin. Not sure why that is. In our back-end system which has code written by the ecommerce 3rd party, the queries are run through CFSCRIPT using their Java API. These are where we see the "sqlserver@listener:1433/OURDB" reported as the datasource. Sorry, I'm not sure what answer to give you regarding the AJP-nio threads. I do not know what hits we should be expecting. What am I looking for, specifically?
... View more