trace a database

hi can anyone tell me how to put on a database trace using sql2005 please..

thanks
ac_davis2002Asked:
Who is Participating?
 
sachinpatil10dConnect With a Mentor Commented:
Try this

Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database.
0
 
tigin44Connect With a Mentor Commented:
trace operation look for many parameters. which ones do you want to trace?
you can start the trace operation from within the Management Studio by choosing SQL Profiler menu.
once you started the trace operation you should connect to the database you want to trace and then choose the appropriate metrics and define the required filters and then run the trace. The trace operation consumes system resources and should used as needed.
0
 
Anuradha GoliConnect With a Mentor Systems Development / Support SpecialistCommented:
Try using SQL Profiler and select the database you wanted to trace and set any filters if needed.
0
 
ac_davis2002Author Commented:
Thanks, i have opened the profiler but can see where you select the database you want to trace?
0
 
Anuradha GoliSystems Development / Support SpecialistCommented:
Hi You can follow the steps shown in picture
select show all columns
click column filters
select databasename
In like enter databasename within% as '%DBNAME%'
flow of profiler to filter databasename
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.