A common problem placing databases on one server Instance is they all share same tempdb. Is it possible to allocate tempdb file/and filegroups for separate databases. Does Resource Governor allow this?
Database 1, only gets access to one file/filegroup 1 in tempdb.
Database 2, only gets access to one file/filegroup 2 in tempdb.