Websites loading time

[WildPh]

I've just installed the new lansweeper release (4.0.0.27). The installation is divided into two parts a SQL server 2008, SP2 and the application server, where IIS installed. I use port 81.
Booth boxes run runder W2K8, SP (x64).
Functionally everything works fine, but it takes ages (> 15 s) to load the web pages.

[WildPh]

Open the firewall (on a W2K8 Server) for sqlservr.exe

[cweislak]

I am having the same issue with our server here. I just upgraded to the latest version to see if that would help. It didn't

[Hemoco]

cweislak wrote:
I am having the same issue with our server here. I just upgraded to the latest version to see if that would help. It didn't

This problem was caused by the firewall between the webserver and SQL server.

[Hemoco]

Please contact us by e-mail to take a look at your server.

[WildPh]

Yes, I set the same settings in IIS 7.0 as Martin did - but the performance issue remain the same.

[WildPh]

The link your refering to, is about the AutoClose Property in SQL Server.
I've checked the settings and they seem OK. AutoClose=0 (Off).

[Hemoco]

WildPh wrote:
The link your refering to, is about the AutoClose Property in SQL Server.
I've checked the settings and they seem OK. AutoClose=0 (Off).

Did you make the changes to the Website application pool as suggested in the other thread?

[WildPh]

Thanks for the link. It seems that Martin and I have the same (unsolved) issue.
If this issue persists, we will not be able to migrate to relase 4. Have you got some other ideas how to fix this issue?

[Hemoco]

WildPh wrote:
Thanks for the link. It seems that Martin and I have the same (unsolved) issue.
If this issue persists, we will not be able to migrate to relase 4. Have you got some other ideas how to fix this issue?

Martin resolved the issue by changing the application pool settings.

Also check the following:
http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx