• SSD drive is 1.5 TB

    Database is 50 GB

    tempdb is 85 GB. Last week it filled up and crashed the server.

    The database has performance issues due to table scans in stored procedures. Manager wants to throw hardware at the issue instead of tuning. (He has been advised otherwise)