Solved

how to analysis trace table data before and after table rebuild index

Posted on 2008-10-27
3
304 Views
Last Modified: 2012-05-05
hi,
i have 4 tables with data before rebuild index and after rebuid index of 2 table each.
i named tables as bad1, bad2,  good1 and good2.
obviously the performance increased after rebuild index with dbreindex
how can i know what is eaxtly happened after rebiulding index
how i can analysis data to know the reasons
i am using standard edition 2005
0
Comment
Question by:brahma007
3 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 50 total points
ID: 22825555
to see indexers fragmentation.. before and after try to use
sql server 2005 sys.dm_db_index_physical_stats
2000/2005
dbcc showcontig
 check
How to Detect Table Fragmentation in SQL Server 2000 and 2005 By : Satya Jayanty
http://www.sql-server-performance.com/articles/per/detect_fragmentation_sql2000_sql2005_p1.aspx
-----
 http://msdn.microsoft.com/en-us/library/ms175008(SQL.90).aspx
more
Script: SP To Run DBCC SHOWCONTIG On All Tables
By Paul Matthews
http://www.databasejournal.com/features/mssql/article.php/1442901
 
http://www.sqlknowledge.com/index.php/articles/37-perfmornace-tuning/57-dbcc-showcontig-
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now