Well, I planned to do it last week, but it got delay for personal reasons.
But here it is, Linq to SQL Profiler is now out of beta, and I personally think it is awesome. Using the profiler, you gain valuable insight about the actual data access pattern of your application (which is usually abstracted away by the Linq to SQL framework). But the profiler goes beyond just dumping a heap of data on you, it takes it several steps further by:
- Tying together queries and code, you can go directly from any query to the line of code that generated it, no more scratching about “what caused this query”.
- Analyzing your data access patterns and alerting your about bad practices and suggesting how to fix them.
- Provide detailed reports on your application’s database usage, perfect for sending to the DBA for optimization.
I got some really nice feedback from people with it: