Tuesday, April 2, 2013

ASP.NET Persistent session state with Riak

Hello World,

Many of us have faced this pertinent question of choosing a persistent storage for ASP.NET session state, especially if you've worked with high usage e-commerce websites. During my research for an elegant yet simple to implement solution that does not overburden the production SQL server, I landed on this post by Jeremiah Peschka.

As Jeremiah highlights, the solution proposed meets the requirements on durable and fault tolerant session state with a ton of enterprise class features.

The core tool used is an open source key value database (never knew there was something like that :-)) called Riak.

I will try to dig deep and do a follow up post on how the experience is with a basic implementation using Riak as the session store.

Happy Coding!

Finding out who is active with your MS SQL Server Database

Hello World,

I was trying to research how to quickly (and easily :-)) find out what is currently active on a particular database instance and landed on this excellent post by Brent Ozar. He describes in a short, crisp video a tool called sp_whoIsActive created by Adam Machanic. You need to run the SQL script on your master database and once done, fire it from the context of the database you are interested in:

EXEC master..sp_WhoIsActive

You would get this nice result window:



Happy Coding!