Datamaker: Issue with queries when doing data selects, inserts, etc.

Article Id: 17032

Status: Published

Updated On: 14-02-2018 07:47

Legacy Id: TEC1518993

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

Our temptable seems to be growing and is not emptying out. Our DBAs can increase the temptable, but want to know if it can be managed within the tool.

Is there a method, SQL statement, or any kind of procedure to reduce or release "stale" data in the temptable in SQL?

Environment:

Release: TDMTDD99000-4.4-Test Data Manager-for Test Data on Demand
Component:

Resolution:

The temp database is used by the SQL Server query optimizer. We do not interact directly with this database. Therefore, we do not have a method to be able to release space.