Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2011-04-06 : 10:57:26
|
| Hi,I have 2 questions... have received a build from external provider, they forgot to Change the Allocation Unit size on the server. They have managed to Update the Data & Log files, but cannot change backup or Tempdb (which we make heavy use of) there might be a delay in the rebuild and im on a tight deadline, but have been instructed to provide optimum performance for the server. Sounds like I could create a bottleneck if I dont have it setup properly, opinions?My 2nd question is regarding system DB file location. It is common knowledge to split the data nad log files for all user db's. But is there a performance gain in spliting Master, MSDB, model & Tempdb ?Thanks,Chris |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Allocation Unit Size & System Db file location