August 27, 2009 at 4:24 pm
I read somewhere that sql compact edition does not have hooks to support profiler. Is that true ? Does it mean there is no way to profiler Sql CE based dbs ?
August 28, 2009 at 3:37 am
You can log certain commands on the IIS server. This doesnt give you the SQL commands but verbose information on the connection via the web server.
Or, I found a article asking the same quesiton.
http://stackoverflow.com/questions/225121/profiler-for-sql-ce/278310
August 28, 2009 at 10:43 am
Yep thats the place I read it. SqlCE has no hooks for profilers to use. I am wondering if anyone has any insight on the 'tested solution' given on that stackoverflow.com thread.
It was mentioned
"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."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply