Post reply

SQL Server 2008 Index Physical Status report

  • April 7, 2014 at 4:29 am

    #292058

    Hello Members,

    For some reason the 'Index Physical Status report' doesn't seem to bring up the data from the database.

    Can someone help me with query to get this information please?

    Thanks,

  • April 7, 2014 at 5:05 am

    #1703712

    Do you mean index physical statistics?

    Be patience and wait for sometime it will take some time to pop up report.

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

  • April 7, 2014 at 5:11 am

    #1703714

    Hello,

    Thanks for your response, yes apologies 'I meant Index Physical Statistics report . I have been waiting over 45 minutes now. Do you think the report is going to give me the data or just stay there forever?

    Running against a 1TB DB with 8 data files and 1 log file.

    Thanks,

  • April 7, 2014 at 5:15 am

    #1703717

    Okay I was being impatient , I must have taken your experts words. It took around 75 minutes but its over now. Thank god.

  • April 7, 2014 at 5:20 am

    #1703718

    Check the current execution on the server and see if still spid is active?

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

  • April 7, 2014 at 5:23 am

    #1703720

    rajsin7786 (4/7/2014)

    Okay I was being impatient , I must have taken your experts words. It took around 75 minutes but its over now. Thank god.

    OK 😎

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

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

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