SQL Monitor - 3.2
Configuring Profiler trace - SQL Monitor
Enabling trace allows you to continuously capture SQL Profiler trace data on the selected instance. When an alert is raised, the SQL statements that were executing around the time of the alert are displayed under SQL Processes in the Performance data section for that alert.
Configuring trace
- Go to the Configuration tab. Under Monitoring, select Trace:
- For each SQL Server instance you want to store trace data for, Select On from the Trace drop-down list, then click the Save settings button.
If trace is enabled for a SQL Server instance, the trace status is displayed on the Global overview and Host machine overview pages:
What trace data is captured?
The following trace information is captured (SQL Server event number in brackets):
- RPC_Starting (11)
- SQL_BatchStarting (13)
- Audit_Login (14)
- Attention (16)
- SQL_Exception (33)
Storing and purging trace data
If trace is enabled, a trace data file is stored locally on the monitored server. Sections of the data file from around the time an alert was raised are copied to the SQL Monitor Data Repository. When you click on an alert in the Alert Inbox to display more details, the trace data is retrieved from the Data Repository.
Note: To prevent the trace data file from taking up excessive storage space on the monitored server, it is automatically deleted after it has remained on the server for 15 minutes, or reaches 1 GB in size.
Trace data stored in the Data Repository is categorized as SQL Server data for the purposes of purging. To specify how long to keep stored trace data in the Data Repository, use the SQL Server data purging option on the Data purging page (Configuration > Data purging).Trace data stored in the Data Repository is categorized as SQL Server data for the purposes of purging. To specify how long to keep stored trace data in the Data Repository, use the SQL Server data purging option on the Data purging page (Configuration > Data purging).
Was this article helpful?
Using SQL MonitorSQL Monitor
- Example configuration of SQL Monitor using virtualization software
- Retrieving alert settings using SQL Data Compare
- Licensing issues with SQL Monitor
- Log files in SQL Monitor
- Upgrading to a later version of SQL Monitor
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Monitor
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
