SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server on Linux Series: Moving TempDB

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out our storage workload. Let’s move the tempdb objects to one of these new drives!

By default, our tempdb files are in the system database folder at /var/opt/mssql/data.

We previously created a folder at /var/opt/mssql/data/tempdb01 for these files. Moving them is straightforward, once you know the file system structure. The following commands will move them to the new location, and I also add additional files to equal the four vCPUs I have on this SQL Server VM. The file growth is my model database’s default of 64MB for this instance.┬áDo as you would normally do with SQL Server on Windows with tempdb file counts and separation of duties for your workload.

Restart the instance to make the new settings take effect.

You’ll notice you now have the properly configured tempdb data and log files in this location.

Also, just like in Windows, the old files are not removed upon relocation. Go clean those up.

That’s it!

In the next step we’ll set up this VM to be able to write backups across the network to a file share, just like we do in Windows! Stay tuned!

Technobabble by Klee from @kleegeek

David Klee is all around geek who loves data - including the platform it resides on, virtualizing it, improving performance, availability, and disaster recoverability, and data presentation and visualization. He frequently advises organizations on the techniques of migrating their business-critical physical SQL Servers to the VMware infrastructure in his day job as Solutions Architect. David speaks at many national SQL Saturday events and SQL Server User Group meetings, as well as writes technical columns on SQL Server and virtualization topics on various blogs. He is on Twitter (https://twitter.com/kleegeek), LinkedIn (http://www.linkedin.com/in/davidaklee), and blogs frequently (http://www.davidklee.net).

Comments

Leave a comment on the original post [www.davidklee.net, opens in a new window]

Loading comments...