About
Careers
Support
Partners
Community
Contact
Product
Overview
IT Discovery
IT Inventory
IT Analytics
Features
Integrations
Use Cases
IT Asset Management
Cybersecurity
Active Directory Audit
Installing Software & Patches
Automated IT Inventory
Pricing
Resources
Support Knowledge Base
Videos
Testimonials
Vulnerability Updates
Patch Tuesday
Blog
Free Download
Lansweeper
»
Lansweeper questions
»
Database size growing too large
Active Topics
Search
Join Now
Login
Notification
Error
OK
Database size growing too large
Posted:
Wednesday, March 4, 2020 3:17:02 PM(UTC)
Anthony.M
Member
Original Poster
Posts: 9
2
Like
My database seems to have grown exponentially over the last few weeks despite not gaining that many new assets:
Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) Sep 7 2018 01:37:51 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 18363: )
Database: lansweeperdb
Server: (localdb)\.\LSInstance
Schema Version: 231
Assets: 1603
Size: 8874.50 MB
Unallocated: 351.75 MB
My biggest table is:
Table Total Rows Reserved (KB) Data Size (KB) Index Size (KB) Unused Size (KB)
tblAssetJournal 8698667 7800568 7774576 24728 1264
I have done compact/shrink from database maintenance tool.
Any ideas what has happened?
#1
RKCar
Member
Posts: 82
posted:
3/4/2020 3:45:58 PM(UTC)
Have you queried that table to see what is in there? I found something that said it used with the Enterprise Edition, which I do not have installed.
User Profile
View All Posts by User
View helpful posts
#2
Anthony.M
Member
Original Poster
Posts: 9
posted:
3/4/2020 4:13:03 PM(UTC)
I have an extremely limited knowledge of SQL so when I ran a query through Management Studio I didnt see anything offhand I could recognize as an issue.
User Profile
View All Posts by User
View helpful posts
#3
RKCar
Member
Posts: 82
posted:
3/4/2020 4:39:23 PM(UTC)
Are there timestamps associated to the entries in that table? Maybe you can identify what the entries looked like prior to you noticing this uptick and see if there is something new populating that wasn't previously.
In the end you might have to contact support directly on this one. If it is related to Enterprise they may have made a chance on the cloud side that resulted in additional data populating this table.
User Profile
View All Posts by User
View helpful posts
#4
GulfMarco
Member
Posts: 12
posted:
3/5/2020 3:10:11 AM(UTC)
Mine has, too. Interesting. I'm also trying Enterprise.
User Profile
View All Posts by User
View helpful posts
#5
chris.anderson
Member
Posts: 8
posted:
5/21/2020 4:19:58 PM(UTC)
I ran into the same issue. Though now i have turned off the Enterprise connection but the table still grows like crazy. I just keep having to go in and delete all the records from the table. Not sure why it is still being used if the Enterprise option is turned off.
User Profile
View All Posts by User
View helpful posts
#6
GulfMarco
Member
Posts: 12
posted:
5/21/2020 4:23:47 PM(UTC)
I turned off and deleted the enterprise setup, only then did the database stop growing. Mine never fully sync'ed up, and database grew to 30+ GB weekly or bi-weekly, crashing the servers.
User Profile
View All Posts by User
View helpful posts
#7
ldockery
Member
Posts: 6
posted:
6/3/2020 3:20:44 PM(UTC)
Originally Posted by: GulfMarco
I turned off and deleted the enterprise setup, only then did the database stop growing. Mine never fully sync'ed up, and database grew to 30+ GB weekly or bi-weekly, crashing the servers.
How did you delete the enterprise setup?
User Profile
View All Posts by User
View helpful posts
#8
bladd
Member
Posts: 4
posted:
6/5/2020 4:26:44 PM(UTC)
I'm having this same issue, trying to DELETE FROM tblAssetJournal; but it filled up my log disk overnight and failed. Wondering if it's safe to Drop that table completely, have asked support. I can't get the Enterprise options page to come up to disable it either.
Originally Posted by: Anthony.M
My database seems to have grown exponentially over the last few weeks despite not gaining that many new assets:
Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) Sep 7 2018 01:37:51 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 18363: )
Database: lansweeperdb
Server: (localdb)\.\LSInstance
Schema Version: 231
Assets: 1603
Size: 8874.50 MB
Unallocated: 351.75 MB
My biggest table is:
Table Total Rows Reserved (KB) Data Size (KB) Index Size (KB) Unused Size (KB)
tblAssetJournal 8698667 7800568 7774576 24728 1264
I have done compact/shrink from database maintenance tool.
Any ideas what has happened?
User Profile
View All Posts by User
View helpful posts
#9
Dmitry_prg
Member
Posts: 3
posted:
6/16/2020 8:40:15 PM(UTC)
Originally Posted by: bladd
I'm having this same issue, trying to DELETE FROM tblAssetJournal; but it filled up my log disk overnight and failed. Wondering if it's safe to Drop that table completely, have asked support. I can't get the Enterprise options page to come up to disable it either.
Originally Posted by: Anthony.M
My database seems to have grown exponentially over the last few weeks despite not gaining that many new assets:
Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) Sep 7 2018 01:37:51 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 18363: )
Database: lansweeperdb
Server: (localdb)\.\LSInstance
Schema Version: 231
Assets: 1603
Size: 8874.50 MB
Unallocated: 351.75 MB
My biggest table is:
Table Total Rows Reserved (KB) Data Size (KB) Index Size (KB) Unused Size (KB)
tblAssetJournal 8698667 7800568 7774576 24728 1264
I have done compact/shrink from database maintenance tool.
Any ideas what has happened?
Hello All, have same issue?
Any news how to disable the Enterprise?
User Profile
View All Posts by User
View helpful posts
#10
bladd
Member
Posts: 4
posted:
6/16/2020 8:56:48 PM(UTC)
I was able to disable Enterprise once I ran a SQL query to bring the DB back to a manageable size. If you contact support and give them some details I'm sure they'll give you a query to run against SQL.
Here is where I disabled.
Originally Posted by: Dmitry_prg
Originally Posted by: bladd
I'm having this same issue, trying to DELETE FROM tblAssetJournal; but it filled up my log disk overnight and failed. Wondering if it's safe to Drop that table completely, have asked support. I can't get the Enterprise options page to come up to disable it either.
Originally Posted by: Anthony.M
My database seems to have grown exponentially over the last few weeks despite not gaining that many new assets:
Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) Sep 7 2018 01:37:51 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 18363: )
Database: lansweeperdb
Server: (localdb)\.\LSInstance
Schema Version: 231
Assets: 1603
Size: 8874.50 MB
Unallocated: 351.75 MB
My biggest table is:
Table Total Rows Reserved (KB) Data Size (KB) Index Size (KB) Unused Size (KB)
tblAssetJournal 8698667 7800568 7774576 24728 1264
I have done compact/shrink from database maintenance tool.
Any ideas what has happened?
Hello All, have same issue?
Any news how to disable the Enterprise?
User Profile
View All Posts by User
View helpful posts
#11
Dmitry_prg
Member
Posts: 3
posted:
6/16/2020 9:02:12 PM(UTC)
Originally Posted by: bladd
I was able to disable Enterprise once I ran a SQL query to bring the DB back to a manageable size. If you contact support and give them some details I'm sure they'll give you a query to run against SQL.
Here is where I disabled.
I cannot go there - website is not responding. Loading and loading
User Profile
View All Posts by User
View helpful posts
#12
bladd
Member
Posts: 4
posted:
6/16/2020 9:04:11 PM(UTC)
That's why you need to get your database fixed first, mine was over 50GB, is now less than 1GB.
Originally Posted by: Dmitry_prg
Originally Posted by: bladd
I was able to disable Enterprise once I ran a SQL query to bring the DB back to a manageable size. If you contact support and give them some details I'm sure they'll give you a query to run against SQL.
Here is where I disabled.
I cannot go there - website is not responding. Loading and loading
User Profile
View All Posts by User
View helpful posts
#13
Urmas
Member
Posts: 2
posted:
12/22/2020 3:28:05 PM(UTC)
Have same problem with table tblAssetJournal.
Table | Total Rows | Reserved (KB) | Data Size (KB) | Index Size (KB) | Unused Size (KB)
tblAssetJournal | 23252651 | 8496240 | 8455216 | 39928 | 1096
We don't use enterprise functions and there is no "Enterprise Options" menu item below the "Database Tables".
What do we lose if we just delete everything from this table?
Running version 8.1.110.1
User Profile
View All Posts by User
View helpful posts
#14
FrankSc
Member
Administration
Posts: 107
posted:
12/23/2020 1:08:23 PM(UTC)
This table only contains data regarding the Enterprise functionality.
You can safely truncate the table, you won't lose information regarding the on-prem installation.
To truncate the table you can use the query below:
Truncate table tblAssetJournal
User Profile
View All Posts by User
View helpful posts
Active Discussions
Help Desk Users Required To Have Email
by
josh.d
Last post:
Yesterday
at 10:34:27 PM(UTC)
Real Ticket Templates
by
TimHolmes1973
Last post:
Yesterday
at 9:38:08 PM(UTC)
Event Filter Widget Cases
by
taext
Last post:
Yesterday
at 7:56:07 AM(UTC)
No antivirus installed
by
MB@CC-IT
Last post:
1/26/2021 5:14:50 PM(UTC)
New License
by
Mikey
Last post:
1/26/2021 3:46:57 PM(UTC)
Powershell module for Lansweeper - Automation
by
Hendrik.VE
Last post:
1/26/2021 1:48:59 PM(UTC)
ticket not generate in lansweeper until I restart lansweeper server service
by
Bruce Tran
Last post:
1/25/2021 10:56:17 PM(UTC)
Email - Email notifications not working
by
Bruce Tran
Last post:
1/25/2021 10:46:29 PM(UTC)