I will follow yours recommendations, wait stats in extended event and to rewrite de code.
Grant,...

Hello Grant.
I use a extended event sqlserver.rpc_completed and the DMV sys.dm_exec_procedure_stats because the application executes procs, never adhoc. A lot of procs use sp_executesql.
I don't need a perfect match for...

Jeff, thank you very much.

NorthernSoul, Sue_H, thanks for yours answers.
Then i can suppose that the best option is to control engine, applications, etc, etc to determine the best space for tempdb and to...

Anthony Green, now yes, i had a little confusion because, i thought that for to set READ_COMMITTED_SNAPSHOT,...

Hello Jeff, thank you for yours recommendations.
There is an error in the second proc, is "id>=@id", not "@id>=@id"
In the first, if you pass null on @Id, return all...

Thanks for all, yours opinions are importants for me.

Hello, thanks for yours answers.
The idea is that procedures return one row or all, simple idea for a simple example.
The table is a simple and little table, with...

Hello Steve.
I understand and i don't have problems with to put sets in the code. I only said that i would like to know if i can to change...

John, why not?
We have definied a default value for user options of 5496 and i don't understand why the job changes it.
I would like to know how...

John, Sue, thanks for all answers.
I knew that Sets in code are above sp_configure values.
It isn't a problem.
With a trace, I detected a curious thing: 
With the...

Thanks for the answers.
Some instances can execute 15000-20000 procedures in one minute.
Cached plans more or less 12500.
Maybe, to put 768KB in Minimum memory per query helps in...

Hello RandomEvent.
The 4 instalations have the same application.
The parameters are id from database, id from table, id from any index and default for partition.
Few rows for execution...

Igor, Mr and MRs. 500, the clarification helps me to understand correctly, thanks for all.