I have a basic knowledge about Microsoft SQL Server Profiler but I want to know that can I monitor a production environment to see which stored procedures are affecting performance by executing too slowly?
SQL Server Profile is very bad for using it in production environment. It could be cause of performance degradation. I could recommend to you two ways
1. Extended Events
I prefer first one. You can find a lot of information and examples how to use both of them
Thanks andrew for your suggestion