Thanks..

Can you tell me if there could be dependent issues like, JVM / Memory leak / any other.?

I tried to execute the query,

SELECT OBJECT_NAME(i.object_id) AS TableName, i.name AS IndexName,

indexstats.avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') indexstats

INNER JOIN sys.indexes i ON i.object_id = indexstats.object_id

AND i.index_id = indexstats.index_id

but I keep...