Solved

trace a database

Posted on 2012-04-02
5
355 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

726 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