Hello,

Now I have more details. Maybe this is relevant.

So I am executing this stored procedure

alter Proc usp__BMBBI_oltp_trigger (@IsMarket as int = null,

@IsZone as int =...

Let me please put one more question.

If I have a SP which as several others inside and I stop that speaks, all the others will stop also ? Or...

So, after they execute I execute and vice-versa.

Both of us using the same SQL Server and at the same time...

If I execute the 6 SPs like this (from inside another SP) the time is not consistent and I takes a lot of time.

exec [BMB1_Market].bmb_ms.[usp_BMBBI_audit_procedure_result_update] @Start_date,@End_Date, @market_code, @intNumRead...

It is very strange, because if they trigger the same SPs (in same order with same parameters) from SSIS, it works fine and takes always the same time.

If you instead...

Understood. Thank you

Thank you for the reply.

Because I have a stored procedure which calls several others.

Every time I call this procedures I pass difterent parameters and it seems that the query plans...

But probably this is at this moment. What I would like is to measure for one day

Hello Those are the results of the 4 queryes

1: SQL...SQL.. 2

2:1342172721228663213840971616059868Available physical memory is high

3:SQL...SQL... ...

Hello,

Thank you for the feedback.

"Also, did you really expect people to read through 4500+ lines of your document? "

No, I was not 🙂

It is just a sample.

Problem is that I...

Another question related with the same topic is this:

I have added the following code to the my sp_procedure:

create sP_name ()

AS

BEGIN

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

--Transaction is handled by...

thank you

What they want is an excel with the tables sequence. Does anyone have a script capable of doing this?

The order that I want is just related with fk. No business need