Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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.


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse