Hi



Being very new to SQL so iam hoping that this will be

easy.



Using a dts package to transfer IIS logs into a SQL

database i would now like to knpw of there is any

resource that gives some idea on the best stats to take

from IIS Logs.



i have create a query that is a count of [c-ip] i would

like to find out what is the max hourly count of [c-ip]

grouped by day the data is very mixed as when log a is

recorded could be 3 a second or not one for a few

seconds ? but generally data is at per second level?

	
Quote:
	

	

		

			
				Originally posted by Simon Jelinek 

Hi



Being very new to SQL so iam hoping that this will be

easy.



Using a dts package to transfer IIS logs into a SQL

database i would now like to knpw of there is any

resource that gives some idea on the best stats to take

from IIS Logs.



i have create a query that is a count of [c-ip] i would

like to find out what is the max hourly count of [c-ip]

grouped by day the data is very mixed as when log a is

recorded could be 3 a second or not one for a few

seconds ? but generally data is at per second level? 
			
		
	
	
Try asking your manager, I hear he is very good at this sort of thing