Solved

trace a database

Posted on 2012-04-02
5
349 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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.
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

705 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

18 Experts available now in Live!

Get 1:1 Help Now