Maintenance plan creates but does not drop temp tables.
We started receiving alerts that our TempDB data file had filled up. We keep TempDB to a fixed size to prevent queries from filling up TempDB and the disk. Upon investigation, we found a large amount of "permanent" tables in TempDB all starting with _rep_ followed by a GUID. I checked through our servers and all of the servers running LiteSpeed have these tables, some with over 100,000 of them. Looking at the data in the tables, it does appear to be tables created by LiteSpeed.
Steps To Reproduce:
Status:
The latest version of LiteSpeed for SQL Server can be downloaded at https://support.quest.com