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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center