SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server challenge: show me trace flag 1118 is significant

published 955 days, 14 hours, 37 minutes ago posted by

sa 965 days, 9 hours, 10 minutes ago

SQL Server challenge: show me trace flag 1118 is significant

Here is a SQL Server challenge as I have failed so far: Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled. I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen any concrete evidence or test cases that actually show its impact on SQL Server 2005 or SQL Server 2008. The empiricist in me just itches for some solid data points.

I have also talked...

category: News | clicked: 1 | | source: sqlblog.com | show counter code

tags: Benchmark, Best Practices, SQL Server 2008, tempdb, Trace flags, Waits

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server challenge: show me trace flag 1118 is significant

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up