Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TempDB and Mount Points Expand / Collapse
Author
Message
Posted Thursday, July 24, 2014 7:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 15, 2014 8:24 AM
Points: 157, Visits: 960
Hi,

I have created a volume for TempDB data files (G:\) and now created another volume for TempDB data files as a mount point (G:\TempDBData\Mount). I have altered half of the tempdb data files to the new mount point and restarted SQL. Success, right? Hmm...

I opened PerfMon to see how the disk utilization is for the two volumes (G:\ and G:\TempDBData\Mount) and it looks like only G:\ is being utilized. All of the disk counters for G:\TempDBData\Mount are zero. When I opened Performance Dashboard I/O Statistics report and expand tempdb, it only shows tempdev and templog in the list.

What happened to the other TempDB data files? How come it looks like the mount point isn't being used in PerfMon?

Any help is greatly appreciated!

Thank you!


My Blog!
Post #1595893
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse