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

Trace flag 4199 Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 5:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
Generally do you run with this on or off?
I've always been slightly worried about setting this trace flag to ON as I don't really have any load like production on any other environment; however I'm thinking running without optimiser fixes may not be the best idea, for the system in question there's a lots of very complex and heavy sql and any performance improvements would be helpful < grin >


The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1429192
Posted Monday, March 11, 2013 6:57 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 6, 2014 11:07 AM
Points: 11, Visits: 47
Hi!

I work with more than 300 instances of SQL SERVER (all versions) and in all of it, we use this trace flag without problems :)

Regards,


André CR
Post #1429240
Posted Tuesday, March 12, 2013 8:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:18 PM
Points: 4,406, Visits: 6,268
colin.Leversuch-Roberts (3/11/2013)
Generally do you run with this on or off?
I've always been slightly worried about setting this trace flag to ON as I don't really have any load like production on any other environment; however I'm thinking running without optimiser fixes may not be the best idea, for the system in question there's a lots of very complex and heavy sql and any performance improvements would be helpful < grin >


As you note there are quite a few optimizer "fixes" covered by that TF. The issue as always is what if a particular system or even single query gets regressed by one of those fixes?? That could be devastating for a particular application. You either test fully to KNOW you are good or you put it on and hope for the best. There is no middle ground here IMHO. I will say that I am in agreement with you and WANT those fixes enabled if I don't get those ugly regressions.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1429843
Posted Tuesday, March 12, 2013 10:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
I'm going to progress it through my environments the same as patches. Hopefully if there is an issue my monitoring and/or the testers will pick it up before we get to production.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1429919
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse