How do I do reindexing & defragmentation of my database

Question

How do I do reindexing & defragmentation of my database

mjafar

SSCommitted

Points: 1539
More actions
February 5, 2008 at 4:09 am

#76895

Nowadays my database is running very slow.
So I have decided to do re indexing & defragmentation.
I have did shrinking of database.
Here first time I am doing re indexing & defragmentation of database.
How do I go for this. Is there any procedure for this task.
What are the commands/stored proc, steps take to consider.
please reply soon __.____._
Regard
Majid

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

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

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

mjafar (2/5/2008)
Nowadays my database is running very slow.
So I have decided to do re indexing & defragmentation.
I have did shrinking of database.
Here first time I am doing re indexing & defragmentation of database.
How do I go for this. Is there any procedure for this task.
What are the commands/stored proc, steps take to consider.
please reply soon __.____._
Regard
Majid

This you have posted in the 2005 forums as well http://www.sqlservercentral.com/Forums/Topic451520-357-1.aspx.

Is this a 2000 or 2005 server? (the syntax for reindexing and defragmenting is different).

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Chand00 SSCertifiable Points: 6466 More actions · Answer 2

Dear Friend,

Please checkout the scripts given in this site. It will help you. One of my query was working fine for the past two years and suddenly it was running for even two to three hours without output. I had taken the script from this site. And within 7 mins I got the data required.

Regards

Mohan

[font="Verdana"]Thanks
Chandra Mohan[/font]

mjafar SSCommitted Points: 1539 More actions · Answer 3

By mistake,

I place this message in SQL 2005 forum.

Actually my server is SQL server 2000 Enteprise edition.

So my query is about to SQL server 2000 databases..

mjafar SSCommitted Points: 1539 More actions · Answer 4

where could I found the script & what it contains..

plz give me path or script.

Regards

Majid

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

Don't shrink your databases. It causes index fragmentation. See my blog post on this[/url]

To rebuild your indexes on SQL 2000, look up DBCC DBReindex in Books Online.

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