paul.corujo (6/2/2010)
The sp in question run in SSMS in under 1 second. How would I determine why it is taking more than 30 when called via the application.
if its running fine then thats not DBA's call it should be kept in Developers plate. but one concern is there that is "tons of call"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)