Profiler for SQL Ce

Profiler for Sql CE

The only tested solution I know of that could solve this problem is Altiris Profiler which is a tool I designed at my previous job, but is closed source and not-for-sale.

The way you would hook it in, is by creating a factory for your commands and proxing them for profiling purposes before using them (using RealProxy). Its really light weight and about 10 lines of code to implement.

On my question Flory talks about a new tool called dynaTrace that may also be able to solve this problem as well.

Query analyzer or profiler for SQL Server CE 4

Yes, if you install Visual Studio 2010 SP1 + SQL Server Compact 4 Tools, you get a query analyzer (if you use VS Premium or higher). You can also use my VS add-in: http://sqlcetoolbox.codeplex.com

There is no profiler, only Query Analyzer (SHOWPLAN)

Can I get sql profiler for sql2008 for free?

First. SQL Profiler does work with SQL Express. Second. You can get SQL Profiler with the Developer version of SQL, which is included with all MSDN licenses. However you will not be able to get it for free with SQL Express like you can with SSMS.

SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?

Here's what was happening, and how to work around it.

It appears that Reporting Server caches data in a temp database. Since most of our reports all used a common view, all of that data was being retrieved from cache.

After selected "Show All Events", under "Stored Procedures" I selected CacheHit, CacheInert, CacheMiss, Completed, StmtCompleted, and StmtStarting.

There was then enough information in the trace file for the profiler to evaluate and make recommendations.

Problem using SQL Server CE with Entity Framework code-first and ASP.NET MVC 3 and mvc miniprofiler

This is an issue with EF 4.1 update 1 which breaks all profilers

See:

• http://code.google.com/p/mvc-mini-profiler/issues/detail?id=100
• http://weblogs.asp.net/fbouma/archive/2011/07/28/entity-framework-v4-1-update-1-the-kill-the-tool-eco-system-version.aspx
• http://ayende.com/blog/75777/entity-framework-4-1-update-1-backward-compatibility-and-microsoft

Mark Young just implemented a SQL CE specific workaround in the main trunk, use:

// only ever set to false when profiling SQL CE
MvcMiniProfiler.Initialize_EF42(supportExplicitConnectionStrings: false); 

---

Related Topics