SQL Server 2008 Index Physical Status report

Question

SQL Server 2008 Index Physical Status report

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

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

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

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."

rajsin7786 Right there with Babe Points: 718 More actions · Answer 2

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,

rajsin7786 Right there with Babe Points: 718 More actions · Answer 3

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

free_mascot One Orange Chip Points: 27164 More actions · Answer 4

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."

free_mascot One Orange Chip Points: 27164 More actions · Answer 5

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."