Hi,

I have built myself a little hit counter. It's just a few lines of VBScript that submit the page name and date to an SQL Server db.

It executes every time the page is accessed. I am a little concerned that this method may put strain on the server given that the home page averages about 3000 hits a week.

I wanted to do it this way because it allows me to use the date field to analyse the usage on a weekly or monthly basis.

Does anyone know if this will put too much strain on the server? Really I'm just interested to know under what circumstances the db server will struggle.

We've got SQL Server 2000, IIS 6 Win2K3. Not sure about RAM - probably 1GB.

thanks

3000 hits a week is not a lot of hits for SQL, 3000 hits an hour should be fine too (depending on design and length of recordsets returned)
Try stress testing it

http://sqlservercode.blogspot.com/