Sitescope - Database Query Monitor - Too many connections (457 Views)
Reply
Occasional Advisor
WilliamWalteros
Posts: 12
Registered: ‎01-20-2014
Message 1 of 6 (457 Views)
Accepted Solution

Sitescope - Database Query Monitor - Too many connections

Hi.

 

We are experience some problems with the Database Query monitor when running a query against a MS SQL Server.

In some of the monitor execution the result is "connect error, Too many connections".

I attach a document with the configuration and the error.

Please suggest me a solution. I'll apreciate it.

 

Sitescope 11.23 on Windows Server 2008 R2

HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 2 of 6 (448 Views)

Re: Sitescope - Database Query Monitor - Too many connections

Hi William,

 

Would you please use the DB Connection tool and post the output here?

 

Best Regards,

 

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Occasional Advisor
WilliamWalteros
Posts: 12
Registered: ‎01-20-2014
Message 3 of 6 (444 Views)

Re: Sitescope - Database Query Monitor - Too many connections

Hi Gunnar,

 

Please find attached a screen - using DB Connection Tool.

 

Thanks,

 

William

HP Expert
kenneth.gonzalez
Posts: 1,769
Registered: ‎04-28-2011
Message 4 of 6 (437 Views)

Re: Sitescope - Database Query Monitor - Too many connections

What about checking on MS SQL side? Maybe you reached the max connections allowed via JDBC
Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 5 of 6 (434 Views)

Re: Sitescope - Database Query Monitor - Too many connections

William,

 

I know that this connection is working but would you please use the SQL driver instead the Inet driver?

 

You have to use this in the driver string: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

And this in the URL info:

 

jdbc:sqlserver://<database_server>:<posrt>;databaseName=<database_name>;

 

Please request the JDBC driver to your DBA and place it in SiteScope\WEB-INF\lib

 

Best Regards,

 

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Occasional Advisor
WilliamWalteros
Posts: 12
Registered: ‎01-20-2014
Message 6 of 6 (396 Views)

Re: Sitescope - Database Query Monitor - Too many connections

Gunnar!!

I used SQL driver instead the Inet driver and for any reason it works!

Now 'connection error: too many connections' no longer appear.

Thank you so much.

William.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.