Solved

trace a database

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Querying data from 3 tables, all with 1 common column 4 37
SQL - Copy data from one database to another 6 20
Help in Bulk Insert 9 36
SQL Count issue 24 17
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

831 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