Solved

trace a database

Posted on 2012-04-02
5
350 Views
Last Modified: 2012-04-06
hi can anyone tell me how to put on a database trace using sql2005 please..

thanks
0
Comment
Question by:ac_davis2002
5 Comments
 
LVL 9

Accepted Solution

by:
sachinpatil10d earned 167 total points
ID: 37795384
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
 
LVL 26

Assisted Solution

by:tigin44
tigin44 earned 167 total points
ID: 37795387
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
 
LVL 12

Assisted Solution

by:Anuradha Goli
Anuradha Goli earned 166 total points
ID: 37795477
Try using SQL Profiler and select the database you wanted to trace and set any filters if needed.
0
 

Author Comment

by:ac_davis2002
ID: 37795545
Thanks, i have opened the profiler but can see where you select the database you want to trace?
0
 
LVL 12

Expert Comment

by:Anuradha Goli
ID: 37815991
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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
powershell to dynamically populate dropdown list with selection in list box 2 39
SQL Login 17 37
TSQL DateADD update Question 4 24
Sql Join Problem 2 19
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now