Thank you, we will see if we can make it to a stored procedure and also run profiler to see what sqls are running when this happened.
It is difficult...

I checked with the .net developer what code behind when running those pages,
He says:
It’s a series of entity framework queries, an update and some inserts....

Thanks all.

But the problem is we don't know what query  that caused this problem. could you know from the error message?

Is it also a way to estimate by the size of database, for example if total size is 200GB, worst case put them all in the RAM, we should buy...

Sorry, I searched and found the info.

So if I buy 240 GB for the server, and my SQL server will use Database engine of 128 GB and SSRS...

Thanks for the info frederico_fonseca. I can only find the document online about 128GB is max that SQL Server instance will use for...

Thanks Jeff for the detailed explanation, that is what I am looking for  and made a lot of sense.

I would like to include the script of it to a build process instead of a SQL job.

Is there a way that I can have the backup- copy-restore...

Thanks, I will give it a try.

It takes about 5 minutes to copy the file for this case.
But could be any minutes depending on the size of the database.

I asked is because the restore...

Thanks for the nice script.

One question, about the select top 1, is there a reason to use top 1 instead of just select?

Thanks

Thanks,

yes, I noticed that tool, I see it is null at name column for those VM backup records I guess.

When you say you use SQL backups,...

Thanks, if I run a rebuild of index, does that help too?

Also we do added some columns recently and dropped some. Is there a way to clean tables not data?