Duration of stored procedure in SQLTest is much higher than SSMS

[Yoni Sade]

Hi

I'm running a stored procedure in SSMS and it finishes in 6 seconds after fetching 50,000 rows while in SQLTest it finishes in 17 seconds.

"Workload Statistics" + "Detailed Statistics " + "Show results" are all turned off (when "Show results" is on the displayed results takes forever to be written on screen)

[Ramesh Meyyappan]

Could it be plan drift? you can verify that by setting ARITHABORT to ON/OFF.

SQLTest used SQLClient, the ARITHABORT default is different from SSMS

Let me know