how we can find out Tempdb data file is on its own disk volume
-
how we can find out Tempdb data file is on its own disk volume
(in case of multiple tempdb data files)
-
Right-Click tempdb in SSMS and select files:
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn -
sql query to find out Tempdb data file is on its own disk volume?
-
select * from sys.sysaltfiles will tell you where the files are located , if your looking for a dedicatde disk drive volume lable then the first char ( C , D , E ) will not be found for other database files. If you want to know the disk itself is dedicated then look under computer Management > storage >Disk management and then check if the drive has its own Disk.
It is possible to have multiple drive residing on the same disk.
-
Jayanth_Kurup (1/15/2013)
select * from sys.sysaltfiles will tell you where the files are located , if your looking for a dedicatde disk drive volume lable then the first char ( C , D , E ) will not be found for other database files. If you want to know the disk itself is dedicated then look under computer Management > storage >Disk management and then check if the drive has its own Disk.It is possible to have multiple drive residing on the same disk.
sys.sysaltfiles is depreciated, use sys.master_files instead.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply