We are using a SQL Server 2005 database.
We currently have no maintenance on our databases indexes. Some of our indexes are showing over 85% fragmentation when looking at the table sys.dm_db_index_physical_stats
.
We plan to reorganise the indexes on our own server as a test before performing the same operation on a client site. On our own server any negative impact will have minimal or no effect on our business. After this we will set up an automated plan to reorganise the indexes.
But before being able to roll this out to our client sites (2005 and 2008r2) we will have to justify the action and to do this we have to show non-technical people a measure of improvement. How can I justify my existence? How do I measure/demonstrate any improvements?