TempDB: the forgotten pillar of Performance Tuning

SQL SERVER & Data Management User Group Christchurch, NZ
SQL SERVER & Data Management User Group Christchurch, NZ
Public group


Madras Street · Christchurch

How to find us

For this meetup we are in S block room S169. Just up the corridor from our usual room.

Location image of event venue


Hi everyone,

Sorry for the late mail out - we had our February speaker pull out at the last minute and have been trying to get hold of another speaker.

Because there was some discussion at the last meetup around tempDB tuning - I've offered to step in and run a fairly interactive session around it.

This will be a practise run for me as I am presenting it in Sydney at the SQL Saturday there on 27th February. So come along and feel free to heckle me (you know who you are....)


Here's the blurb:

" Tempdb is an integral part of SQL Server, and is often overlooked when trying to get the most out of your system. In this session we will go over what tempdb is used for, why it is a special type of database and how to use it to tune the performance of your overall system.

We will start with determining the best configuration, number of database files to use and the common performance issues that tempdb can indicate.

We will then use these best practices to optimise our instance and performance tune our queries to make your system faster."

The room we normally use is unfortunately booked so we are just up the corridor in S Block in Room S169.

As mentioned last month we have finalised a person for the precon training that will take place at CPIT on 15th April and the details are on the website:


John is a great speaker and trainer and this week he spoke at the Nelson UG and got rave reviews. Having a full day training with him for only $250 is too good an opportunity to turn down.

Also if you haven't registered for the SQL Saturday on 16th April - please do. We're finalising the speaker line up and the day will cater for DEV, BI and DBA so should be a really good event.

See you next Wednesday - as always the doors to room S169 will be open from 5:30pm and the session will start at 6:00pm.


Hamish, Nick, Simon, Martin, Sarah and Rob