Page History
...
- DBCC TRACEON. This may increase the number of sessions that have a NULL batch handle and therefore increase the amount of Text N/A batches.
Workaround: You can add DBCC TRACEON 2861 in the starting parameter of the SQL Server instance (-T 2861). - DBCC INPUTBUFFER (if needed by the internal collector logic). This may limit the ability the retrieve the statement/batch text when the system encounters some known bugs in SQL Server.
- Metrics for not responding transactions. You will get an error in Alerts.
- Show statistics and Show config views enabled in index/table entities in the Objects tab. They will stop working.
- Recommendations. This may limit to get recommendation for objects and statements.
For more information, see Initializing see Start and Use the Database Engine Tuning Advisor on the MSDN website.