Rebuild jobs crashes the DB server

  • My first thought was you need to check the max memory setting, make sure it is NOT the default. However the limited SAN space may be the problem.

  • Limited SAN space could be culprit. However let us know the detail error message for further investigation.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Thaks djj and free_mascot for your replies. yes I will try to figure this out by noon.

    Any idea how do I go about rebuilding the index on this table ? Do we have to add additional space on the SAN drive? if yes how much space is required? the table is 400 GB so how much space would be required by the rebuild job? any way to calculate this?

  • thanks a lot guys problem was confirmed due to SAN running out of disk

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply