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

https://sqlblog.com/blogs/linchi_shea/archive/2007/01/18/performance-impact-of-querying-sql-server-2005-scheduler-related-dmv-s.aspx

 

Happy reading.

 

Sanchan

Comments

• Anonymous
  August 01, 2010
  Can u guide me good basic book in sql server for troubleshooting ? Please guide me rohitgupta006@gmail.com