SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How do I do reindexing & defragmentation of my database


How do I do reindexing & defragmentation of my database

Author
Message
mjafar
mjafar
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 131
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
Andras Belokosztolszki
Andras Belokosztolszki
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2247 Visits: 1585
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
Chand00
Right there with Babe
Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)

Group: General Forum Members
Points: 762 Visits: 1257
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

Thanks
Chandra Mohan

mjafar
mjafar
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 131
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
mjafar
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 131
where could I found the script & what it contains..
plz give me path or script.

Regards
Majid
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87307 Visits: 45272
Don't shrink your databases. It causes index fragmentation. See my blog post on this

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search