Saturday, February 02, 2013 4:05 AMI am developing application in WPF - MVVM with SQL 2012 localDB as backend, how to turn on SQL profiler for locadb to see what queries are being executed from application
Saturday, February 02, 2013 5:25 AMModerator
Try to use localhost as server name when connecting using SQL Server Profiler.
Hope this helps.
Saturday, February 02, 2013 11:03 PM
open your SSMS and profiler connect to the sql server.
in the new trace select event selection tab. then check the show all events check box
from the list select the checkboxes under data base name.
now use column filter then select databasename.
select like and type %localDB%. then start the trace. it will capture every thing on that database.
Sunday, February 03, 2013 5:59 AMhttp://blog.sqlauthority.com/2009/08/03/sql-server-introduction-to-sql-server-2008-profiler-2/
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
Monday, February 04, 2013 5:10 AMThat does not work - profiler does not show up qieries
Monday, February 04, 2013 5:21 AM
That does not work - profiler does not show up qieries
Kiran, which template you are using ?
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Wednesday, February 06, 2013 10:06 AMModerator
Please try to select "Tuning" template when create a trace.
You can refer to the following blog about detail information:
TechNet Community Support