SolarWinds KB

 

I've been doing work on SolarWinds products for close to a decade now, including several years as a SolarWinds consultant. 

I'm kicking off a new blog dedicated exclusively to SolarWinds at https://solarwinds.gregkjono.com where I will be sharing various scripts, queries, tips and tricks that you can use to fix, enhance, automate and integrate your SolarWinds environment. There's an RSS feed available at http://solarwinds.gregkjono.com/feeds/posts/default which you can follow to get notified of new posts as well.

In relation, I am also starting to dump various scripts and queries to a GitHub repo. Feel free to follow me on GitHub if you'd like to keep an eye on it.

Connection Pooling for Commerce Server 2007 and 2009

With as little as a couple hundred unique visitors on a website, we were seeing close to 300 SQL logons per second coming from Commerce Server. Every hit to SQL was creating a new connection. Luckily, this is a quick and easy fix to get Commerce Server to start reusing open connections to SQL by using connection pooling.

Take into account though, if you are using impersonation on your Commerce Server website then this is a security risk. If a one user reuses the SQL connection of a different user, they can assume the security rights of that previous user.