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

Managing Indexes in a Database Expand / Collapse
Author
Message
Posted Friday, November 30, 2007 5:56 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 5:07 PM
Points: 227, Visits: 192
I have a database which has a over 80 to 100 indexes. How do we maintain these indexes, I think re-indexing all of them is not a good idea. Is there any other way of monitoring these indexes in SQL Server 2005 for fragmentation etc. Your insight is appreciated!!

Regards,


Razi, M.
http://questivity.com/it-training.html
Post #428381
Posted Saturday, December 1, 2007 11:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:20 PM
Points: 33,078, Visits: 15,191
You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.

Other than that, SQL Server maintains the indexes fairly well.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #428451
Posted Saturday, December 1, 2007 12:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 5:07 PM
Points: 227, Visits: 192
Thanks Steve. Guess what I told this to an interview but he still wanted to see what else we can do? I was stuck:)
I think there are some system DMVs in 2005 that show statistical information regarding indexes.

Regards,


Razi, M.
http://questivity.com/it-training.html
Post #428456
Posted Saturday, December 1, 2007 2:27 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:20 PM
Points: 33,078, Visits: 15,191
Yes, as far as checking to see if indexes are being used, you can use the DMVs so see what's being used.

This blog post can help: http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #428457
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse