How important is SQL Profiler when debugging database application?
Posted on 2011-02-26
I have used it on several projects at other companies and find it to be a required debugging tool in some development shops. As a contractor, when I first learned of it, I was looked down upon for not having used it before.
I have heard some DBA's say it's not important at all during debugging, that the old trial and error method of debugging works fine.
What do you think?
We are new all to Entity Framework and I have argued since the start of the project we needed to see the exact SQL being created by EF4 so we could help remove the mystery by the magical tool :)
We have not gotten SQL Profiler running and still have as much mystery as when the project began.
I hope to hear some opinions on the use of SQL Profiler to read the auto generated SQL that's being presented to the database.