Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Trace Flag 2861 Expand / Collapse
Author
Message
Posted Tuesday, August 26, 2014 6:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:21 AM
Points: 1,263, Visits: 600
digitalox (7/24/2012)
The current version of Confio Ignite will also do this.

True.
Post #1607432
Posted Tuesday, August 26, 2014 6:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:21 AM
Points: 1,263, Visits: 600
Jo Pattyn (1/23/2006)


<A href="http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx">http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx</A>

Trace flag 2861 causes SQL Server to cache query plans for trivial queries that have a cost of zero or close to zero. SQL Server typically won't cache plans for these trivial queries because the cost of caching the plan is higher than the cost of generating a new plan for such a simple query. Generally this design makes sense and efficiently manages compilation.

However, some people like to use the fn_get_sql() function to see what queries are running on a server, but fn_get_sql() can't see queries associated with the zero-cost plans unless you enable trace flag 2861.

Thanx, that helped.
Post #1607433
Posted Tuesday, August 26, 2014 6:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:21 AM
Points: 1,263, Visits: 600
sqlpadawan_1 (7/27/2012)
Wow, 5 yr old thread answers the question I have today, especially the confio ignite comment 3 days ago.

Go figure.

Thanks,

Even after 8.5 Yrs. still usefull
Post #1607434
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse