This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- Re: Lansweeper 4.0 - performance issue
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2010 02:48 PM
Hello,
I have a performance issue with the new version of Lansweeper.
I leave my PC on for night, with LS website open. In the morning, when I click on any LS link, I have to wait about 15-20 sec. for the page to display. But when it finally opens, all subsequent pages will open up immediately or with a 1-2 sec. delay which is absolutely fine. But after that, when I leave LS 'untouched' for ~30 min., the delay problem comes back; it's not that long this time, maybe 10 sec. but long enough to be a nuisance when you're having a user on the phone.
The version 3.5.2 was OK. The problem started with LS v.4 beta which was installed on a different physical server from scratch. I was hoping it's because of the overall poor performance of that server but I've recently installed LS 4 (from scratch) on the server where LS 3.5.2 used to be and the problem persists.
According to your suggestion I looked through SQL 2005 logs, and the server event logs but cannot see anything suspected. I checked Windows logs on my client workstation where I open LS website but no dodgy entries.
LS is installed on W2k3 Enterprise SP2, 12GB RAM, 2 x Quad Core Xeon E5430.
LS website uses windows authentication mode.
SQL Server 2005 where LS DB sits on is on a different physical server, same LAN (Gigabit).
I know it's not likely but from my point of view it looks as if the LS DB put itself in some 'sleep mode' after some time, or LS website 'forgets' my credentials and needs to authenticate me in the background first which takes the said couple of seconds...?
I've just removed AD windows authentication section from web.config to disprove the 2nd part of my supposition but I see no noticeable change.
Do you have any ideas?
Cheers,
Martin
I have a performance issue with the new version of Lansweeper.
I leave my PC on for night, with LS website open. In the morning, when I click on any LS link, I have to wait about 15-20 sec. for the page to display. But when it finally opens, all subsequent pages will open up immediately or with a 1-2 sec. delay which is absolutely fine. But after that, when I leave LS 'untouched' for ~30 min., the delay problem comes back; it's not that long this time, maybe 10 sec. but long enough to be a nuisance when you're having a user on the phone.
The version 3.5.2 was OK. The problem started with LS v.4 beta which was installed on a different physical server from scratch. I was hoping it's because of the overall poor performance of that server but I've recently installed LS 4 (from scratch) on the server where LS 3.5.2 used to be and the problem persists.
According to your suggestion I looked through SQL 2005 logs, and the server event logs but cannot see anything suspected. I checked Windows logs on my client workstation where I open LS website but no dodgy entries.
LS is installed on W2k3 Enterprise SP2, 12GB RAM, 2 x Quad Core Xeon E5430.
LS website uses windows authentication mode.
SQL Server 2005 where LS DB sits on is on a different physical server, same LAN (Gigabit).
I know it's not likely but from my point of view it looks as if the LS DB put itself in some 'sleep mode' after some time, or LS website 'forgets' my credentials and needs to authenticate me in the background first which takes the said couple of seconds...?
I've just removed AD windows authentication section from web.config to disprove the 2nd part of my supposition but I see no noticeable change.
Do you have any ideas?
Cheers,
Martin
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2010 02:55 PM
Before creating a separate AP for LS I ran a couple of tests again (we've been closed for last 4 days) and I think all's working OK now. And I have an impression that the suggestion from the post #8 was the key one; maybe it needed to restart a service which I didn't do on that day?
Anyway many thanks to all LS support team and BullGates!
Take care guys,
Martin
Anyway many thanks to all LS support team and BullGates!
Take care guys,
Martin
19 REPLIES 19
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2010 08:31 PM
We're also noticing the same issue. I will try to use some tuning, this looks like an SQL performance issue, when we access the reports dashboard it queries a lot of tables to fill in the dashboard data...
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2010 06:30 PM
Right, here's what I've figured out so far:
I asked all LS users not to click on any LS links and after 1.5 hrs I asked one person to click on Dashboard reports which took him ~12 seconds. Then I refreshed mine which took ~1 sec. After another 1.5 hrs of not touching LS the scenario repeated in the same way but with a different person. We all use IE8. This proved the issue doesn't stay with my PC only, but still does not reveal the real reason.
Cheers,
Martin
I asked all LS users not to click on any LS links and after 1.5 hrs I asked one person to click on Dashboard reports which took him ~12 seconds. Then I refreshed mine which took ~1 sec. After another 1.5 hrs of not touching LS the scenario repeated in the same way but with a different person. We all use IE8. This proved the issue doesn't stay with my PC only, but still does not reveal the real reason.
Cheers,
Martin
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2010 12:28 PM
I did that, thanks. And I'm still trying to spot the difference. When I use Chrome with IE plugin it seems to be running OK but I do not know if it's not because somebody else in my office keeps refreshing LS on their PC... I'll get back to IE8 and test it today. Then I'll let you know. Meanwhile I'll check IE8 settings as I noticed that some people in our office do not seem to complain, but again - this might be a coincident because somebody else might have used LS a moment before and "refreshed" the database or IIS or who-knows what else...
Cheers,
Martin
Cheers,
Martin
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2010 12:13 PM
Maybe try to disable the "idle timeout" and lower the "startup time" (to 2 seconds)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2010 12:08 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2010 11:17 AM
Could you post all your application pool screenshots please.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2010 07:00 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2010 06:00 PM
Looks like the sql queries take only 5 seconds.
Must be another problem (IIS related?)
Can you try switching between classic APP pool and the normal one?
Must be another problem (IIS related?)
Can you try switching between classic APP pool and the normal one?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2010 05:33 PM
Hi,
the LS database has 'auto close' option OFF.
If it comes to the sql profiler I did the following:
At 13:46:55 I pressed 'Dashboard reports' on LS website (I was on 'Departament overview'). After 13 seconds 'Dashboard reports' finally opened (13:47:08). Attached you will find the extract from sql profiler.
Getting back to 'Department overview' took me 0.5 sec., and opening 'All available reports' took 1 sec.
Cheers,
Martin
the LS database has 'auto close' option OFF.
If it comes to the sql profiler I did the following:
At 13:46:55 I pressed 'Dashboard reports' on LS website (I was on 'Departament overview'). After 13 seconds 'Dashboard reports' finally opened (13:47:08). Attached you will find the extract from sql profiler.
Getting back to 'Department overview' took me 0.5 sec., and opening 'All available reports' took 1 sec.
Cheers,
Martin
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2010 03:04 PM
On the database server you can start the sql profiler for tuning.
This will show you the exact queries and the time it takes.
In the options of the database, can you check if "auto close" is set to "false"
This will show you the exact queries and the time it takes.
In the options of the database, can you check if "auto close" is set to "false"
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
