Hello - 

We're in investigation mode and perhaps the community has some insights.  We have a SPROC that runs in less than 3 seconds (on average and is consistant) on a sql server that doesn't share resource with any other applications.  However, the SMO that is connected to this SPROC often times takes upwards of 45 seconds inconsistantly.  So my primary question is as follows:

1. Has anyone else seen this before and realized that there was just something that needed to be done when utilizing a SPROC to return SMO results that would make it speedy-er?

Advice on places I can check/test/tackle would be appreciated.  We have many solutions, but this seems to be specific to the SPROC to SMO relationship...

Many thanks!