We have multiple web sites running accross multiple VMWares. These web sites all run under 1 IIS entry with each web site getting a host header to pull what the web site will look like from teh database (Think Content Management).
I want to record the pageview to our database for statics later. We already use IIS logs but there is more information that I want to record. I would like this to record in a cache or MS Message Queuing looking for preference and ideas In caching I would notify when the cache is set to expire (Is this realiable) and record the entries into the database. In MS QUE I would record each page view then create a SSIS package to gather them up and place the directly into the enterprise database. I would like to keep the recording of these page views from the web site; seperate from recording them to the database. Meaning I do not want each page request to take the time to do the insert. I want a business layer that will control the database entries. I want the load of the SQL DB to be lite. Due to licenseing I only have access to a standard SQL server from the web sites. Our Enterprise license cannot be touched by the web pages. The page views will end up in analytics over on the enterprise side of the system. Just to clarify I am looking for a business layer abstraction that allows the web site to record page to location X. At a given time a different app will pickup the data and process the records to it final location. Any ideas or suggestion or alternatives would be helpful.
