The biggest benefit to moving your wwession table to SQL is so that SSL persistence doesn't matter. You can fail out a web server and the end user's experience is seamless. Another web server picks up their request and knows their authentication info.

I like having a single wwRequestLog on the SQL server because I can analyze slow request, traffic history, etc. easily.

(I run a web farm that serves 8 million+ pageviews a month.)