Web Connection
Using SQL for RequestLogs and maybe Sessions?
03/18/2010
09:42:05 AM
2W30KSOLI Show this entire thread in new window
Gratar Image based on email address
From:
Brett Baggott
To:
All 
Attachments:
None
I'm trying to move to a web farm model, primarily for redundancy. We average about 120k pageviews/day right now so it might also be good to have a way to scale already in place should we need it.

I am going to be moving my data off direct attached and onto our EMC SAN via CIFS. I'm wondering if now is the time to move our RequestLogs and possibly our Sessions to SQL Server. Currently I "roll" our RequestLogs every night at midnight so it's not like our RequestLogs get unbearably huge anyway. I keep our Sessions file well groomed too, it usually runs about a million records or so at any given time.

So, my question is, is there any need/advantage of moving these tables to SQL Server instead of keeping them as DBF's over CIFS on the SAN (which is _extremely_ fast, btw - of course our SQL Server ain't no slouch either).

Any ideas?