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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy