Create a new table PageViews
Columns
1. PageId (INT OR VARCHAR)
2. Views INT
Whenever user visits a page update this table based on PageId and increment the View by 1
declare @views INT
select @views = views from
PageViews
where PageId = @PageId
update PageViews
set View = @views + 1
where PageId = @PageId
To get total Page Views of site
select sum(Views)
from PageViews