thanks SQL buddy can we calculate procedure cache @db level

thanks

its 64 bit will it matter

how to calculate Data Cache usage

i notice physical reads for first time to keep in cache and next executions are fast.

but after some time again it is doing physical reads. how to avaid this is...

thanks Eric , PLE is looks good. will there be a way to stop procedure not to recompile

i can replicate this issue in multiple environments

yup its working fine after first run.

After one hr or so if you try to execute same it will take over couple of minuts

Thanks Gail ! but in my case just i am selecting a records(select statement) which is holding an intent exclusive lock until the end of the transaction

thanks again. I dont have any performance issues right now to share execution plan or ddl code. when we discuss last we in team meet we have discussed all the...

thanks guys. few issues i noticed is queries are running slow, not always but few times

stored proc need to create a execution plan whenever there is change in...

thanks Jeff you are so helpful as always !!!!!!

thanks for your reply.

i think you r right

will this work on SQL 2K5 instance ?

thanks Jeff

thanks

thanks what does 0 mean ? i notice blocking sql(spid 79) is a select statement and blocked sql(spid 81) is an insert.

spid 81 wait resource on Lck_M_IX