Managing a tempdb database

MySQL   |  PostgreSQL   |  SQL Server

This page describes the management of the tempdb database in Cloud SQL for SQL Server.

The tempdb database is a system database that holds many objects, including temporary tables, stored procedures, and more. In your instances, you can perform common operations on this database.

You can manage the tempdb database of your instance in a way that meets your needs.

A tempdb database is recreated each time an instance is restarted. To prevent the loss of user permissions, Cloud SQL provides permissions to the sqlserver user after an instance is restarted.

Overview

The sqlserver user has the ALTER permission for managing the tempdb database options.

See the general information about managing a tempdb database.

Managing tempdb files

After you connect to an instance, the sqlserver user can manage the tempdb files.

Number of files

The user has the CONTROL permission on the tempdb database. The user can control settings for the number of files (and more). For example, the user can perform these operations:

• ALTER DATABASE [tempdb] ADD FILE
• ALTER DATABASE [tempdb] REMOVE

Note: See Physical properties of tempdb in SQL Server, which includes recommendations related to these settings. Review the information about the number of tempdb data files that would correspond to a given number of logical processors. By default, Cloud SQL creates a minimum of eight files for instances that have greater than or equal to eight logical processors. As included in those recommendations, if the number of logical processors is fewer than or equal to eight, the number of files created is equal to the number of logical processors.

File size

The user can control the size of files in the tempdb database. For information about using the ALTER DATABASE statement to change the file size options, see ALTER DATABASE (Transact-SQL) File and Filegroup Options.

What's next

• Learn about Instance settings.
• Learn about Monitoring Cloud SQL instances.