Does SQL Profiler work with LocalDB?

Question

Is it possible to use SQL Profiler to observe queries being requested of a LocalDB instance?

Answer 1

You can use SQL Profiler just as you do with all other SQL editions as long as you know the proper server name. You can find the server name using the SqlLocalDb utility.

To find it, use sqllocaldb info YourInstanceName to find the Instance Pipe Name. It has the form np:\\.\pipe\LOCALDB#12345\tsql\query

Use this as the server name to connect to the server and start profiling