Timeline for How should I organize my mdf, log and tempdb on a 3 physical disk server
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 11, 2017 at 11:45 | comment | added | Paolo Bianchi | 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 | |
| May 10, 2017 at 16:58 | history | edited | John Eisbrener | CC BY-SA 3.0 |
further clarifications
|
| May 10, 2017 at 16:50 | history | answered | John Eisbrener | CC BY-SA 3.0 |