Sproc Executing Slow? It Might be This
Posted by: Fervent Coder,
on 07 Nov 2009 |
View original | Bookmarked: 0 time(s)
So you have stored procedure and its having issues. When you run it, it returns really fast. When .NET runs it, its like a dog.
The first thing you learn about SQL Server is that it has something called ARITHABORT and it is turned on in SQL Management Studio and OFF in ADO.NET. Yeah you heard that right. OFF. So when you find this out, your first thought is WTF, mate?! Why do we have to make this hard on ourselves?
Reference post: http://sqladvice.com/blogs/gstark/archive/2008/02/12/Arithabort-Option-Effects-Stored-Procedure-Performance.aspx
So...