Does SQL Profiler work with LocalDB?

localdb, profiling, sql-server

Solution

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

Problem

Original source