Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there a way to view the CAML that is running on a SharePoint 2010 installation?

A bit like how you can monitor SQL running on a database with MS-SQL Server - is this possible with CAML and SharePoint?

share|improve this question
1  
Check the-sharepoint.blogspot.com/2011/07/… –  Ashish Patel Jul 14 '11 at 2:18

3 Answers 3

up vote 1 down vote accepted

Yes, to a certain extend you can watch CAML being executed by SharePoint Server. Here are the high level steps:

  1. Go to Central Admin -> Monitoring --> Configure Diagnostic Logging -> Expand "SharePoint Foundation" and Check Monitoring

Make sure you select "Verbose" for event log and trace log and then save your settings

You may want to do IIS reset at this point.

  1. Download ULS Viewer and run it

  2. Load From ULS log in the ULS log viewer to start monitoring. Filter the log entries (Edit Menu - > Modify Filter) for condition like "Message contains CAML" so that it shows only relevant messages to you real time.

I am working on a for this at http://the-sharepoint.blogspot.com/2011/07/know-caml-queries-executed-by.html

share|improve this answer

You can use tools like U2U CAML builder and Stramit CamlViewer to see what CAML is generated or use it to roll your own. I don't know of anything that monitors for that type of thing though.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.