• The server has 64 logical processors. 20 is a bit of overkill but not much.

    Stats are updated nightly. Indexes are defragmented nightly.

    Performance issues are truly caused by poorly written stored procs.

    The application database has twice the IO as the TempDB

    So, which is it better to put on the SSD drive? The application database or the TempDB?