Monitoring CLR Activity

• Rootman

  SSCrazy

  Points: 2641

  More actions

  February 13, 2009 at 3:54 am

  #218460

  Can anyone tell me how I could monitor CLR activity on my server?

  I am interested in memory usage, no of calls etc, CPU time.

  Thanks for any help

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  February 13, 2009 at 6:41 am

  #943510

  Read the following document by Kimberly Tripp that covers monitoring CLR.

  http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLCLRforDBAs.doc

  Basically, you look at the normal .NET performance counter objects, and then pick the sqlservr instance for the ones of interest and monitor it through those counters.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]