Link to home
Start Free TrialLog in
Avatar of Paulconsulting
Paulconsulting

asked on

Trace a specific database using SQL Profiler

Our database server hosts multiple databases for various apps and I'd like to set up SQL Profiler to monitor a specific Database.  I do not know how to do this.

Avatar of Aneesh
Aneesh
Flag of Canada image

Create a new trace, click on the filter settings, select either the database name or database Id and enter the name /id of the database
Hope this gives you a brief idea on the usage of SQL Profiler using this document

http://articles.techrepublic.com.com/5100-10878_11-5054787.html

In Figure D,you have to choose the Database Name which you like to Audit.
Pictures slightly differ in SQL Server 2005 as the site shows SQL Server 2000 snapshots.

In 2005, You can start profiler from SSMS --> Tools

Hope this helps
Avatar of Paulconsulting
Paulconsulting

ASKER

where are the filter settings?
Hope you can see the Filter settings as mentioned in Figure D in the link above.
I don't have a filters tab - just one that says General and one that says Events Selection
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks :)
Welcome..