Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

TempDB and Mount Points Expand / Collapse
Posted Thursday, July 24, 2014 7:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:53 PM
Points: 219, Visits: 1,233

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