November 5, 2014 at 4:10 am
We have a cluster with two nodes and two instances of SQL Server 2012 Standard Edition running on them. Volume W: is a Fusion-IO card.
On one of these nodes a lot of database names are showing up in the resource monitor as *.mdf files (W:0\MSSQL1…).
Can someone explain how and why SQL Server is using these files?
They only show up on one of the nodes having more load.
Volume I: is the volume where the transaction log is written so we can explain these files.
November 5, 2014 at 4:17 am
The title states mdb. Should be mdf of course. Can't change the title it seems.
November 5, 2014 at 9:27 am
I am not sure I understand the question. .mdf files are SQL Server database data files, so you expect them to see lots of activity. Is there something else you are looking for here??
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 6, 2014 at 7:38 am
Hi, the problem seems to be related to the filing system of the OS. We expect the file names to be listed as "H:\..." but the OS is using "W:0\...".
W:\ is the volume of the tempdb.
H:\ is the volume of the datafiles (mdf).
I:\ is the volume of the logfiles (ldf).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply