Confluence goes down everytime

[AKASH BHARDWAJ]

Hi,

We have Confluence Instance with MSSQL database. Our Confluence Instance goes down pretty often.

I was looking for Database Pool connections but i couldn't find it under confluence-cfg.xml file.

Any help will be greatly appreciated.

Thanks,

AKash

[Mike Rathwell]

Akash,

The tomcat datasource statements are in <conf-install>/conf/server.xml. The pool connections are in <conf-install>/confluence/WEB-INF/web.xml. This last, when I upgraded to 5.7 perhaps isn't necessary (had some problems that Atlassian helped me out with) as they were commenting that it really doesn't add much to the performance.

I think, first, let us know if anything shows up in the log files that might provide a clue. Personally, I might take out the connection pool statements from the web.xml as well in case that is giving SQL Server fits with trying to handle too many connections at once.

On a more technical personal note, I would really consider just not using SQL Server; I've had nothing but anguish anytime I've had to touch it and, if you have the choice, go to PostgreSQL being, in my experience, faster, lighter, and far more reliable.

[Nic Brough -Adaptavist-]

What does the log file say is going wrong?