[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

Shrink Temp Database


Currently i am running below mentioned insert statment in one of my user database.The destination table is partioned table & it contains 2 indexes (one clustered and one non-clustred).

Insert into table_1
select * from table_2

The problem is: tempdb log file size is growing very high. So i am planning to  shrink log file (same time that is insert statment is executing, alternatively i am planning to shrink log file).

by performing to transactions at same, is there any impact on my source/destination tables.

The reason is tempdb is located in seprate drive (the size is very low).

So i am planning to shrink tempdb log file.

please let me know
1. is there any impact on source/destination table?
2. is there any impact on tempdb?
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
there can be some performance hit, otherthan that nothing
If the tempdb database is growing due to the insert command then it will be impossible to shrink it at the same time. Same is valid for log file. You should rather divide the insert into several smaller parts.
srinivas_ganamurAuthor Commented:

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now