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..