Sql server 2012 Log and file data

Question

Sql server 2012 Log and file data

mteo74

Grasshopper

Points: 17
More actions
February 15, 2018 at 7:10 am

#344048

Hi all
on my server sql 2012 we have different DB (DB1,DB2,.....) but all DB file are in this path:
Files data:
D:\sql\data (rows Data)
Files Log
L:\sql\data (Log)
My question is: is correct put all file log into the same drivers? (same question for data file....)
Are there I/O problem?
Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33508 More actions · Answer 1

Putting data files on one drive and log files on another drive is a common setup.
To see if you could have I/O performance issues you have to look for yourself. This is environment specific so we can't tell. Use PerfMon or other monitoring tools to measure I/O metrics and see the performance over time.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

mteo74 Grasshopper Points: 17 More actions · Answer 2

Sorry but you don't undertend my question:
is correct put logs files data of different DB (created on same sql server) into same directory:
All Files data are save into:
D:\sql\data (rows Data)
and all Files Log are save into
L:\sql\data (Log)

Is correct for you?

HanShi SSC-Dedicated Points: 33508 More actions · Answer 3

I understood your question; I could have emphasized my answer better 😉
Putting all data files (per instance) on one drive and all log files (per instance) on another drive is a common setup.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **