The Resource Database – leave it alone!
When
separating data and log files, you might think that moving the Resource
database (mssqlsystemresource.mdf and mssqlsystemresource.ldf) is a good idea.
Suggestion – don’t move it. So, you’re concerned about I/O, and
synchronous/asynchronous activity? I wouldn’t be. Moving this is probably a
waste of time, and there is one huge gotcha that you need to be aware of if you
do. In BOL, it states that
If you move the master database, you must also move the Resource
database to the same location as the master data file.
What
happens if you don’t? I don’t have an exhaustive list, but what I did learn is
that when I tried to apply a service pack, the log file got overwritten. The
new log file did not match the data file, and the install was history. I
probably could have tried to find a workaround (sp_attach_singe_file_db?), but
opted to reinstall. If you decide to move it, as I did (dorking around with
it), make sure and leave both the data and log files with master.mdf!
Lee
-------------------------
Amazing what is stuck in the fine print of Books Online
5cef9a50-3ac0-486b-a7fc-509660b16b42|0|.0