February 8, 2016 at 8:59 am
Hi,
anyone knows how to exclude a specific Wait from Data Collector's reports? The problem is that my mirroring related Waits misrepresents the data collected.
Thanks!
Davide
February 10, 2016 at 4:58 am
Not to my knowledge. But, the data is stored there in a table, just write a different report using a good set of filters on the wait stats.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2016 at 9:16 am
Thanks Grant.
Probably I've found a solution: there's a field 'ignore' in the 'core.waits_categories' table that could be used to exclude some Waits.
Davide
February 10, 2016 at 10:25 am
Excellent. I wasn't aware of that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply