Reputation: 1
What is TEMP_DB_CONTENTION ?
In our server there is table named TEMP_DB_CONTENTION and is occupying 190 GB of space. what is the use of this table and can we delete it if not required?
Upvotes: 0
Views: 39
Reputation: 46213
This is a user table, not something created automatically by SQL Server. Since tempdb is recreated whenever SQL Server restarts, it seems the table have been created recently. Run:
SELECT create_date
FROM sys.tables
WHERE name = N'TEMP_DB_CONTENTION';
to ascertain when it was created. The name suggests it might be (or have been) used for performance or load testing.
Upvotes: 1