• we quickly resolved the situation by upgrading the server to 2GB of RAM

    Heh... I guess they didn't think too much of their server 😛

    Good write up about what to look for when you first "move in". I'd also add that you should determine the number of CPU's, what the disk configuration is, and where they keep the backups. Guess that might fall under the "Total/available disk space and other relevant server specs" bullet you mentioned, but wanted to break those out, for sure.

    I'd probably also talk with the boys in OPs and find out what type of firewalls are in place and also check to see what types of encryption may be in place.

    Heh... then there's the matter of finding out what the SA passwords are for all the servers, once you find all the servers 🙂

    Anyway, good article. Thanks for taking the time to write it.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)