Sree
Sree

Reputation: 1

SQL Server TEMP_DB_CONTENTION

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

Answers (1)

Dan Guzman
Dan Guzman

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

Related Questions