First of all, please read my comment.
It could be several reasons of slow execution of SP. Here you'll find some of them:
The Seven Sins against TSQL Performance[
^]
This is quite often asked question. Also, i would suggest to use
SearchBox[
^] at the right-top corner of this site.