In the corporative ERP, there is a SP that sometimes (more and more) takes on minute and means in executing itself. With the analyzer I capture ' text' of the SPCompleted event of those SP that surpass the minute of execution. If that same ' text' I send it in the Query, single it takes 3 seconds to me (and it is the logical thing, since quite simple 2 the single SP does selects in 2 tables with index on the fields of select). I do not capture at the moments that take minute and means in executing nor re-compilations, nor Inter-lockeds. To what this difference in run time can be due?. During that minute and means, the use of reading of the RAID where they are located the data is of the 100%, which stops the rest of processes. Thanks for your aid, and you pardon my lamentable English.