Performance Impact of querying SQL Server 2005 DMVs and implementing Page Checksum
Many of you have asked me the performance impact of:
a) Running a default profiler trace
b) Enabling page checksum
Although there is only theoretical information available in BOL, Linchi Shea (SQL Server MPV) has some good posts on empirical analysis on these features.
Recommended that you read them!
Performance Impact of Enabling Page Checksum and Default Trace
https://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx
Performance Impact of Querying SQL Server 2005 Scheduler-Related DMV's
Happy reading.
Sanchan