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.
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
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
ASKER
where are the filter settings?
Hope you can see the Filter settings as mentioned in Figure D in the link above.
ASKER
I don't have a filters tab - just one that says General and one that says Events Selection
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks :)
Welcome..