Online Reindexing question? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Online Reindexing question?

Author

Topic

Gopher
Yak Posting Veteran

83 Posts

Posted - 2007-11-13 : 08:11:36

Hi All

I currently have an SAP system which I have migrated to SQL 2005 and I want to run a reindex. Is there a 'dbcc reindex' I can run for the whole lot or do I have to pick out a few of the larger tables and do them individually?

Also I am assuming that this online reindexing can be done when users are using the system?

Thanks

Gopher

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-11-13 : 11:53:12

quote:
Originally posted by Gopher

Hi All

I currently have an SAP system which I have migrated to SQL 2005 and I want to run a reindex. Is there a 'dbcc reindex' I can run for the whole lot or do I have to pick out a few of the larger tables and do them individually?

Yeah.. Tara has some scripts on her blog: http://weblogs.sqlteam.com/tarad/Default.aspx

quote:
Originally posted by Gopher

Hi All

Also I am assuming that this online reindexing can be done when users are using the system?

Yes..but "Online index operations are available only in SQL Server 2005 Enterprise Edition."

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Hommer
Aged Yak Warrior

808 Posts

Posted - 2007-11-13 : 12:23:01

Even you could do the reindex in real time in SQl05, I still don't think you should do it at production server in the peak hours.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-11-13 : 12:27:20

quote:
Originally posted by Hommer

Even you could do the reindex in real time in SQl05, I still don't think you should do it at production server in the peak hours.

concur with that..unless you have a very low load or you have tested it out thouroughly..not QA testing but load testing..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-13 : 15:59:14

Online indexing doesn't work on table that has column of LOB data type.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources