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

Performance Impact of Querying SQL Server 2005 Scheduler-Related DMV's


Happy reading.