Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2008-10-27
3
334 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

792 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