Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do I do reindexing & defragmentation of my database Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2008 4:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 2:22 AM
Points: 57, 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
Post #451522
Posted Tuesday, February 5, 2008 4:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
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
Post #451529
Posted Tuesday, February 5, 2008 4:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
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
Post #451532
Posted Tuesday, February 5, 2008 4:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 2:22 AM
Points: 57, 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..
Post #451535
Posted Tuesday, February 5, 2008 4:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 2:22 AM
Points: 57, Visits: 131


where could I found the script & what it contains..
plz give me path or script.

Regards
Majid
Post #451537
Posted Tuesday, February 5, 2008 5:10 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:25 AM
Points: 42,761, Visits: 35,853
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 2008, MVP
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

Post #451554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse