Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-02-10 : 18:15:47
|
| Is there anyway to make the profiler only capture events for a single database instead of the entire sql instance? |
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-02-11 : 06:37:55
|
| Yes, 1. In the event selection tab first ensure that the DatabaseName / DatabaseID column is selected.2. Then click on "Column Filters" [on the bottom right hand section of screen], In the popup window of "Edit Filter", click on DatabaseName filter and provide your like condition e.g. like %DB1%.Run the trace, this will ensure that events are filtered out only for the database name provided. |
 |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-12 : 06:50:50
|
| Or filter by Database ID in SQL Server 2000 - profiler seems to have an issue with database names for some reason... |
|
|
|
|
|
|
Profile Single Database?