How do I change the size of the tempdb?

Question

In MSSQL Server Management Studio, expand the Databases and right click on tempdb.Choose Properties.Go to Files page.On this page, you can increase or decrease the tempdb size. 8 нояб. 2013 г.

How do I make tempdb smaller?

Right-click on the TempDB and go to Tasks. In the tasks list, click on Shrink, and you can select Database or files. Both Database and Files options are similar to the DBCC SHRINKDATABASE and DBCC SHRINKFILE command we explained earlier.

How do I know my tempdb size?

In this case, the query below can be used to check the number of tempdb data files currently defined. SELECT file_id, type_desc, name, physical_name, [size], state_desc FROM tempdb. sys.

Expert · Answer

Right-click on the TempDB and go to Tasks. In the tasks list, click on Shrink, and you can select Database or files. Both Database and Files options are similar to the DBCC SHRINKDATABASE and DBCC SHRINKFILE command we explained earlier.

Expert · Answer

In this case, the query below can be used to check the number of tempdb data files currently defined. SELECT file_id, type_desc, name, physical_name, [size], state_desc FROM tempdb. sys.

How do I change the size of the tempdb?

How do I make tempdb smaller?

How do I know my tempdb size?

Related Questions