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. (more…)
Tag: tempdb
SQL Rally 2012 Recap and Session Files
SQL Rally 2012 was hosted by the North Texas SQL Server User Group. More tha anything, it was nice to be back in the area where I grew up. I was born in Houston, but I grew up in the Dallas/Ft. Worth area. It really brought back a lot of great memories for me like…
Whitepaper: Demystify Tempdb Performance & Management
There are many misconceptions and myths about tempdb and purported best practices are inconsistent at best. It’s hard to know which advice to follow when one resource says to always do it one way and another tells you to always do it the opposite way. Many times, both resources are correct in certain situations or…
Why We Follow Best Practices
There are many reasons why we follow best practices. My own reasons have changed over the course of my career. Early in my career as a database developer and then later as a new DBA, I followed best practices because people who claimed to know more about SQL Server said to, and I assumed that…
Optimizing TempDB Performance
Today I thought I would blog about TempDB performance. On one of my new servers, with 24 cores, I allocated eight TempDB files as that should be enough to distribute the load, reduce contention and improve performance. However, I forgot to restart the server after hours and it went on for a week and performance…
Breaking Down TempDB Contention (part 2)
I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me about the script. Jonathan said that he thought the math was off just a little bit in the script. The original script…
Moving the Master Database Lesson Learned
With the new 2008R2 servers that were recently built, I am hoping to institute some standard best practices on the boxes moving forward. The first one was to move the TempDB to its own drive on a separate LUN and since I have moved a TempDB before, no problems here. The second best practice was…