Sockets, Cores, and Threads, oh my!

Sockets, Cores, and Threads, oh my!

What do you mean, exactly, by “CPU”? Once upon a time, computers sat on our desks; we knew exactly how many processors they had; and back then our biggest uncertainty was whether they could handle Y2K. Fast forward to today: our computers have 4, 8 or 16...
Reducing the Use of TempDB to Keep Costs Down

Reducing the Use of TempDB to Keep Costs Down

There comes a time in everyone’s life that they need to be concerned about tempdb. I know… we all have configured it correctly and it’s running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing....