It ’ s TEMPDB Why Should You Care?. It is more than just a little system database. Tim Radney, Senior DBA for a top 40 US Bank President of “ Columbus GA SQL Users Group ” PASS Regional Mentor – South East USA. What is it?. It is installed by default but what is it?
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
It is more than just a little system database.
Tim Radney, Senior DBA for a top 40 US Bank
President of “Columbus GA SQL Users Group”
PASS Regional Mentor – South East USA
It is installed by default but what is it?
What makes this guy unique?
A good starting point for configuring TEMPDB
What is contention? Wikipedia = “competition by users of a system for the facility at the same time”
SELECT session_id AS sessionid,
wait_duration_ms AS wait_time_in_milliseconds,
resource_description AS type_of_allocation_contention
WHERE wait_type LIKE ‘Pagelatch_%’
AND (resource_description LIKE ‘2:%’),
Put TEMPDB on your fastest possible drives
Put TEMPDB on the fastest RAID you can support
Options for more IOPs
Put data files and log file on different sets of disks
Split the individual data files to different sets of disks
Need more IOPs
Visit FUSIONIO.COM. GO with SSD’s, with over 100,000 IOPsOther tips?
Were you paying attention?