You put the tempdb for an on-site server on a separate *volume* because that makes it easy to see. Especially if you have no resident DBA. Your ordinary spy system discovers if it fills up. I don't remember if Windows still has a limit of 1000 or 1200 IO operations per volume per second, but spreading data on several volumes should reduce memory requirements somewhat. At least there would be that option.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
You are God sent
If you had a server with RAID1 10K OS disks and RAID1 SAS SSD Data drives how you configure the tempdb location and the other database locations?
During the install you pick where you want it to live.
your jokes make me wanna smoke SO BAD!
I hope that's a good thing, hahaha.
Thanks for the video. I think it's a positive that I understand the technical content more than the cultural references.
You put the tempdb for an on-site server on a separate *volume* because that makes it easy to see. Especially if you have no resident DBA. Your ordinary spy system discovers if it fills up.
I don't remember if Windows still has a limit of 1000 or 1200 IO operations per volume per second, but spreading data on several volumes should reduce memory requirements somewhat. At least there would be that option.
1000 operations per volume per second? Holy smokes, you must be a time traveler from the 1980s. Time to report to some modern training, chief.