Thanks All.

One more point to add.

Even after restarting the Server/Services does not help. We have to execute this job after that.

Most of the day it is working fine say 28...

Affected queried.

Queries are large.

Some details of the queries

Using Temp objects,Table variables , cursors, 2-3 levels of nesting. Finally taking data from Jobs table.

I'd suggest optimising those. They don't sound at...

Thanks Gail.

Please find the information.

namerowsreserveddataindex_sizeunused

JOBS1207018 4301464 KB1235384 KB3042224 KB23856 KB

The tables has 1207018 rows and Using SP_SPACEUSEd , I found the size as above.

Definition:-

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Thanks Scary DBA.

I too suspect the Table.It is the max used table. Hence the earlier team has overloaded it with lots of indexes and statistics.

The surprise here is building...