P
P
Pavel2019-06-02 00:54:12
SQL Server
Pavel, 2019-06-02 00:54:12

Why did tempdb grow?

I made a working database rebuild index + update statistics through a maintenance plan, having previously disconnected all clients from the database, after the application was launched, tempdb grew to 50 gigabytes, and performance dipped, queries that used to work out 5-10 minutes began to run for almost an hour.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-06-02
@tsklab

How to shrink the tempdb database .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question