Whenever we experience heavy volume on our ECF3.1.1 site, our SQL Server (2000) comes to a crawl, the processor is pinned at 100%, and we can't serve up any pages.

We ran a SQL Profiler trace, and it said the CustomerSessionLoadBySessionKey was taking 15+ seconds to run.

I noticed that the CustomerSession table had > 2.6 million rows, 2.1 million had null for CustomerID.

I deleted all records in CustomerSession WHERE CustomerID IS NULL and that seemed to clear up the problem.

We are not running the maintance service at all.

Can you guys shed some light on what the customer session table does, if you've found that it becomes a performance problem over time, and what I can do to alleviate the problem? Thanks.

Corey

This table keeps track of all sessions and shopping carts. Should be cleared of items that are 2 months or older. You can create a SQL Script for that.

I've tried to figure out the purpose of the CustomerSession table in the past, but it wasn't clear to me. I see the ShoppingCartItems table and that's clear, but what's the purpose of the CustomerSession table and what exactly should be deleted? Only where customerid is null or is there something more?