Pedro

You'll want to set the affinity manually, otherwise you may end up with each instance using some or all of the same processors as the others.

John

There's a lot to worry about in that code, I'm afraid.  The loop within a loop will mean it'll run really slow.  And you have a SELECT TOP 1 clause...

Matt

Does the job run at exactly the same time each day, or does it sometimes run before midnight and sometimes after?

Of course, the wider problem here...

You can't just remove the cursor, because now the stored procedure isn't doing the same thing.  It's inserting just one row instead of all the rows.  You need to rewrite...

That's not the whole stored procedure definition, is it?  The execution plan shows that there's a cursor involved.  Also, do you have an example of the table parameter (@TableWaybillID) that...

Please specify exactly what you need the user to be able to do.  First you said it was only for one particular database; now you seem to be saying that...

There's no reason to run SQL Server on an old operating system.  You should use SQL Server 2016.  I don't know what the individual benefits are, but I do know...

Do you have the option to change code?  The SelectWaybillID stored procedure uses a cursor - probably dreadfully inefficient.  Please will you post the full definition of the stored procedure,...

Sounds as if you may have a disk bottleneck.  But I think you need a slightly more detailed analysis of your wait stats.  Paul Randal's and Brent Ozar's blogs have...

What other applications run on the server?  How much memory is in the server and what is max server memory set to in sys.configurations?

John

The first problem is that your table mytable doesn't appear in the query.  The second is that your subquery isn't correlated to the outer query.  Therefore, all rows in the...