Just thought of giving a Update.

The query is running with in the stipulated time.

Nothing has changed over a period of time no server settings have changed not even query :doze:

Has anybody faced this Issue. This is really puzzlling . What could be the root cause