Trace flag 4199

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Trace flag 4199

Trace flag 4199

Rate Topic

Display Mode

Topic Options

Author

Message

colin.Leversuch-Roberts

Posted Monday, March 11, 2013 5:41 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668, Visits: 688

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

andrecesarr

Posted Monday, March 11, 2013 6:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:11 PM
Points: 9, Visits: 40

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

TheSQLGuru

Posted Tuesday, March 12, 2013 8:18 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 3,575, Visits: 5,115

colin.Leversuch-Roberts (3/11/2013)

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

colin.Leversuch-Roberts

Posted Tuesday, March 12, 2013 10:01 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668, Visits: 688

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 »

Permissions