cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Anthony_TMEIC
Engaged Sweeper II
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?
15 REPLIES 15
JTempleton
Engaged Sweeper III
I am having this issue as well. truncating the table is fine, but how do I disable it once and for all!
FrankSc
Lansweeper Tech Support
Lansweeper Tech Support
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
UrmasZ
Engaged Sweeper
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
bladd
Engaged Sweeper
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.

Anthony.M wrote:
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?


bladd wrote:
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.

Anthony.M wrote:
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?
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.

Disable

Dmitry_prg wrote:
bladd wrote:
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.

Anthony.M wrote:
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?


bladd wrote:
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.

Disable


I cannot go there - website is not responding. Loading and loading
That's why you need to get your database fixed first, mine was over 50GB, is now less than 1GB.

Dmitry_prg wrote:
bladd wrote:
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.

Disable


I cannot go there - website is not responding. Loading and loading


GulfMarco
Engaged Sweeper III
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.