The SQL Log screens shows all the activity that took place while the SQL Log was enabled. You can sort the screen by the Seconds column to find the longest running queries.
You can enable SQL Logging by following the below steps:
1. Click Shift+F9 from within Momentus Enterprise. The Diagnostic Information screen opens.
2. Select the Configure SQL Log tab.
3. Click the Enable SQL Logging link to begin the SQL Logging.
4. Perform whatever system processes as necessary to capture the desired activity or to find a slow query or queries.
5. Click Shift+F9 from within Enterprise. The Diagnostic Information screen opens.
6. Select the Configure SQL Log tab.
7. Click the Disable SQL Logging link to end the SQL Logging.
8. Click the Launch SQL Log link. The SQL Log screen opens.
Click on a a line on the screen to view the SQL string. You can highlight the SQL string, right-click and select Copy to copy it to the clipboard.
You can also export the log file by clicking Tools -> Export to Excel.
Comments
2 comments
SQL Logging has 3 options: Log SQL, Log Server and Log SL WebService. What is the difference among these 3 options?
0 upvotes
Hi Kenny,
I got some input from my technical team:
Log SQL Server – this will log query execution against the Ungerboeck database you are connected to.
Log Server – This will log information for the database server used for Ungerboeck
Log SL Web Service – This will log information for the web server that is used for Ungerboeck
Hope that help!
Thanks,
Maggie
0 upvotes
Please sign in to leave a comment.