Hi GilaMonster,

Thanks GilaMonster for reply..

you are right we can not use DDL command during Snapshot isolation..

but usage of application is almost 24 hours. Is there any other way so...

Hi GilaMonster,

It is something like,

Session 1: executed get stored procedure of business logic. means only SELECT statement is in that SP under SNAPSHOT ISOLATION LEVEL.

...

Hi Gianluca Sartori,

I have used "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" in store procedure and dynamic script (rebuild indexes and update statistics) are written in Job.

Hi Gila, Kenpo,

🙂

thanks for ur replies..

i have limit the logical reads and it works fine now.. 🙂

//

Hi,

it happen in in most of all stored procedure. it takes more time when execute first time and then from next time it will execute in 0 seconds.

i checked logical...

Hi,

how can we know the "Compile" and "data cache" time of particular store procedure when it execute first time.

can you please guide me??

Thank You in Advance...

GilaMonster,

yes you are right..

it takes time to cache more than 1.25 GB data approx.. huge amount of data page scanning and logical reads happen by this procedure..

i really appreciate...

Jeff Moden,

we replaced #table to @table in stored procedure.. it works for 2 days. and suddenly it started to taking more then 10 seconds.

if we execute from Java application...

Jeff Moden,

This is the actual code, we used this stored procedure to check connection to the database and this is also taking 10 seconds sometimes. and also other SP which...