Simon-413722 (7/1/2008)
Whilst it does make sense to only have 1 transaction log per User DB, any idea about tempdb? The recommendation from M$ was to have 1 data file per CPU but they didn't mention anything about the number transaction log. I would assume 1 transaction log would suffice for multiple tempdb data files as well, but has anyone came across any credible evidence for this recommendation?- Simon
You mean credible evidence that would be considered incontrovertible and admissible in a court of law? I don't think so.
Like most of us, I know what I read. I read that one log file for the TempDB database is all you need. I've never read anything else.
LC