• Just curious but what other databases are on that server? That sounds like a lot of hardware for only a 50GB database.

    Not that that would be related to bad table scans.