hai all

Question

Post reply

hai all

naidu6

SSC Enthusiast

Points: 195
More actions
July 15, 2013 at 6:34 am

#280241

if i have a single table which is of 1 TB in size and the fragmentation percent is 85% ,i know i can rebulid the indexes,but apart from rebuilding the indexes what other options we have to improve the performance of sql server.
Can anyone please help me out.
thanks in advance.

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Are you sure the fragmentation is the direct cause of the poor performance?

To fix fragmentation, rebuild or reorganise the index.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

naidu6 SSC Enthusiast Points: 195 More actions · Answer 2

Thank you Gail,

apart from rebulid and reorganize is there any other ways of fixing it.

thanks in advance.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

As I said, to fix fragmentation you have to either rebuild the index or reorganise the index.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

naidu6 SSC Enthusiast Points: 195 More actions · Answer 4

Gail, this was the question i faced in an interview recently,but i don't know what interviewer mean by that?He asked me clearly other possible ways to do it.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Then the correct answer would be 'There are no other sensible ways of doing it.'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

naidu6 SSC Enthusiast Points: 195 More actions · Answer 6

Thank you so much Gail for helping dba's like me for sharing your knowledge with us.