tempDB system

pma111
pma111 used Ask the Experts™
on
Is there any specific why having the tempDB on the C drive is more of a concern than the other default system databases (not from an MSSQL background).
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
the system drive is already using a lot of iops (lots of read/writes), and tempdb is an io hog and while it is waiting for i/o to complete the database is effectively stopped  better to put it on a drive (physical) that is not already tasked with a lot of i/o activity.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today