• Ok, it's not a terrible thing that they don't have clustered PKs.

    Do they have any clustered indexes in the database at all?

    You mentioned that the app has to be restarted to get things to return to normal. Have you investigated the app server for memory leaks as well as performance issues?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events