Tempdb Splitting File/Filegroups among different Databases 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.
No.

Resource Governor is for throttling CPU, query workspace memory, and storage throughput, but there is no feature in SQL Server that restricts which files/filegroups a database can access in TempDB.

Plus, think about cross-database queries - if you had a cross-database query, how would that even work?