Skip to main content
Paolo Bianchi's user avatar
Paolo Bianchi's user avatar
Paolo Bianchi's user avatar
Paolo Bianchi
  • Member for 7 years, 7 months
  • Last seen more than 6 years ago
awarded
awarded
comment
How should I organize my mdf, log and tempdb on a 3 physical disk server
As i explained in another response, the 2 SSD are 4 physical SSD in raid, so i write 2 SSD to simplify the "logic" ;) 64 Kb for SQL is ok, i know, sql pages are read 8K at a time, so 64K block size are ok for I/O Your "crossed" suddivision is very interesting, i like it! :-) Not sure about setting autogrowth off for TempDB... Initial dimensioning is very important, ok, but a failed transaction is not good... Sure we must trigger alert on disk usage. Very interesting response, thank you Paolo
awarded
comment
How should I organize my mdf, log and tempdb on a 3 physical disk server
OK, maybe, or maybe D: MDF + TempDB and E: LDF ... Sure i'd keep MDF and LDF of production DB separed, i must choice where to put tempdb Thanx| Paolo
comment
How should I organize my mdf, log and tempdb on a 3 physical disk server
More the second situation, no heavvy work on tempdb but many read/write on software db. I think that dividing data and log files of sotfware db is essenctial, so the real question was where to put tempdb... I think your solution could be the best choice in my environment. Thanx! Paolo
Loading…