Tririga Maintenance - Index Defragmentation.

Luis

Hi,

Is the command TRIDATA_DBCC_INDEXDEFRAG available on Tririga Admin Console obsolete?

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-indexdefrag-transact-sql?view=sql-server-ver15 - Here it suggests to use Alter Index instead.

I reviewed the stored procedure on the DB and it uses the SQL Command:

DBCC INDEXDEFRAG()

We are using MS SQL Server 2016.

Would be safe to remove it and now use Alter Index to rebuild and reorganize instead?

Regards.

Admin

Hi @rickster6311 , can you take a look at Luis's defrag issue? Thx!

Luis

Hello,

Just refreshing the request for help 😃

rickster6311

Hi Luis ,

Sorry for the late reply.

You are correct that the INDEXDEFRAG has been deprecated by Microsofyt, but it is not obsolete and has not been removed from TRIRIGA yet.

However, in anticipation of the command being removed from MS SQL Server, we have opened an internal work item to implement a replacement function (likely based on ALTER INDEX) at a future time.

For now, we advise customers to continue to use the command TRIDATA_DBCC_INDEXDEFRAG unless they have a DBA who can create something based on ALTER INDEX that would do the same work as TRIDATA_DBCC_INDEXDEFRAG.

If you have those skills available and would prefer to start using ALTER INDEX now, that is fine; however, we don't advise deleting the current TRIDATA_DBCC_INDEXDEFRAG. Implement a new solution and use that in place of TRIDATA_DBCC_INDEXDEFRAG instead.

I hope that adequately answered your question, but if you need any further information, please reply here and we will be happy to address it.

Rick Rhea
Senior Architect, Wipro Ltd
TRIRIGA Performance & DevOps

Admin

Hi @rickster6311 , I know you're busy, but can you take a quick look at Luis's defrag issue? Thx!

Luis

Thank you!