October 31, 2013 at 12:32 pm
Hello,
How do I know which tempdb a database is using if I have 6 tempdb's?
October 31, 2013 at 12:34 pm
An instance can only have a single TempDB, so any database on that instance will use that single TempDB database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2013 at 1:41 pm
Looking at the properties of the tempdb, going to the files tab, 6 different logical names listed. Each logical name has it's own seperate path. Is there a way to tell which tempdb a DB uses?
tempdb - D:\tempdb\tempdb1\temp1.ndf
D:\tempdb\tempdb2\temp2.ndf
D:\tempdb\tempdb3\temp3.ndf
D:\tempdb\tempdb4\temp4.ndf
D:\tempdb\tempdb5\temp5.ndf
D:\tempdb\tempdb6\temp6.ndf
October 31, 2013 at 1:43 pm
That's one database with different files. There's still only one tempdb.
October 31, 2013 at 2:25 pm
One TempDB, multiple data files. You do not have multiple TempDB databases. All databases on that instance use the one sole TempDB database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply