how to turn on SQL profiler for LocalDb
-
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
All Replies
-
Saturday, February 02, 2013 5:25 AMModerator
Hello,
Try to use localhost as server name when connecting using SQL Server Profiler.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Saturday, February 02, 2013 11:03 PM
Hi there,
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.
cheers
kumar
-
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 ?Thanks
Manish
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
Hi Kiran,
Please try to select "Tuning" template when create a trace.
You can refer to the following blog about detail information:
http://www.mssqltips.com/sqlservertip/2040/use-sql-server-profiler-to-trace-database-calls-from-third-party-applications/Regards,
Fanny Liu
If you have any feedback on our support, please click here .
Fanny Liu
TechNet Community Support
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Friday, February 08, 2013 9:38 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Friday, March 08, 2013 4:25 AM
.png)
