• Problem solved!

    It was at newly installed switch on half duplex that made the communication between web server and db server slow.

    So, this also means that when SQL Server profiler says that the duration of the stored procedure execution is x milliseconds, that number also includes transport of result to web-server!