Hi Alpesh,

I should stress that I'm giving a simplified view of what actually happens, but yes the active log will "wrap around" so that that MaxLSN is now in VLF...

Mike - it's great to hear you're looking forward to the rest of the articles. I hope you enjoy them! The first five levels can be found here[/url]. Bear in...

Many thanks for the feedback so far, and especially to h.berg for correcting my misunderstanding with regard to thread execution.

It's interesting that you mention "...less context switching because more...

I don't think my cause was helped by forgetting to take the editorial out of "draft" mode. It meant that until yesterday the editorial wasn't visible and the "discussion" link...

Steve is right: it was an idea inspired by working with Alex on his book. The editorial was not written with the sole purpose of plugging the book (and, in...

Performance - "alternative solutions are failing to meet performance targets"

Also, I don't think the idea only applies to cases where a technique is "unsupported". I think it's an interesting idea...

I wasn't really complaining that the award is judged by Microsoft employees; just arguing that it could be a little more open and that introducing an element of community voting...

Apologies to all -- I've now made a correction to the answers so that it applies correctly to SQL Server 2005.

Best,

Tony.

All,

Apologies for the any difficulties that you've had with these videos, and thanks for all your feedback.

The criterion was that the videos should fit on the screen at 1024x768 resolution.

With...

Yes, Gail is right: this is a SQL 2008 technique, although you can get some wait event data out of SQL 2005, as shown in this article:

http://www.simple-talk.com/sql/performance/taking-the-guesswork-out-of-sql-server-performance-profiling-part-2/

It's true...

Don't worry, Jeff. I'll offer you as much help as I can,...

Hi Mark,

In terms of the "classic" programming titles, the ones that tend to get name-checked are the likes of:

"C Programming Language" by Kernighan & Ritchie

"The Art of Computer Programming" by...

I guess I was really just trying to challenge the inherent "high means all is well, low means trouble" assumption that accompanies the BCHR.

Thanks Andy ;). As is often the case on SSC, the discussion is just as (if not more) interesting than the original post.

Talk like that will get you turned back at the airport, and rightly so. 😉