Lansweeper Load Balancing?

[jmzhs]

We just pulled a report and have about 25k assets listed. The database right now is at about 6 gig. We are looking into migrating this data over from SQL compact to SQL Server.

Could somebody who's managing a lot of assets chime in? We'd like to keep a historical record of all of our assets. We want to use Lansweeper for as an asset manager and tie users to assets and keep a historical record without being purged.

What are the usual bottlenecks of Lansweeper? Is it the scanning? I read that the scanning can be spread across multiple servers sharing one database.

Can this be done without additional licensing? Thank you all!

[Bruce_B · Accepted solution]

If you have 25k assets you're well over the recommended asset count for an SQL Compact database, which is about 5k. Though you indicate that your database size is 6GB~ while the SQL Compact size limit is actually 4GB, you may already be running an SQL Server database, express edition, which is limited to 10GB. You can check which database edition you're using under Configuration\Database Scripts.

If you are still running an SQL Compact database, you can migrate to SQL Server using this article. Make sure you're running the latest Lansweeper version (6.0.0.51) prior to migrating.

When you use an SQL Server database, it is possible to split your components (web console, scanning service and database) between multiple servers, that should already provide a performance increase. You can check if your license allows multiple scanning servers under Configuration\Your Lansweeper License. If there is no mention of a scanning server above your asset limit, you'll be limited to a single scanning server. If you wish to upgrade your license to allow for multiple scanning servers you can contact our sales department for this (https://www.lansweeper.com/contact-sales/).