Thanks a lot GilaMonster and Joe !
I just checked with client end, and found they are ok with the performance of sql server but... they got one error while performing Delete operation with PTJOBLOGS.. (:
The were trying to perform below delete operation:
DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469
and got error message:
Msg 8908, Level 22, State 6, Line 1
Table error: Database ID 23, object ID 901578250, index ID 0. Chain linkage mismatch. (1:753306)->next = (1:753307), but (1:753307)->prev = (1:706408).
It seems its consistency error that Checkdb was not able to repair. Should I run checkdb again with All_ErrorMSGS ? to know whts going on ? OR any other way to cope with this error ? Indexid=0 seems cluster index issue..