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 read/write, physical read/write. it is not big figure now.
is there any way to know following time of particular stored procedure:
1. Compile time (in milliseconds)
2. stored procedure plan generation and plan cache time (in milliseconds)
3. data/index page cache time (in milliseconds)
is any DMV query or demo script available or any other way?
can you please guide me..
Thanks in advance...