tempdb

How to Resize tempdb

  • Article

When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.

2018-08-21

4,154 reads

Blogs

A Memory-Optimized Roundup – T-SQL Tuesday #117

By

The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...

How do you debug your spark-dotnet app in visual studio?

By

When you run an application using spark-dotnet, to launch the application you need to...

More PowerShell Remoting coverage in dbatools

By

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...

Read the latest Blogs

Forums

Reading Part of a Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reading Part of a Dataframe

The First Rule

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The First Rule

ColumnStore Indexes not releasing the Deleted Rows

By TRACEY-320982

In on table which has CCI columnstore indexes on it, and I run select...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers