Following is the code to fetch the number of Page views from a SharePoint site using the RequestUsage Table

We must enable Usage and Health Reporting from Central Administration with the important event being Page Requests.  Enabling this will create a new database, named WSS_Logging.This Database contains the table RequestUsage which will be used for Reporting the PageViews.

 
select Userlogin ,ServerUrl,SiteUrl,weburl,DocumentPath,LogTime  from RequestUsage
where  serverurl = 'https://intranet.contoso.com'  --webappurl
and siteurl = '/blog/blog1'   --sitecollectionurl
and weburl = '/user'    --weburl
and DocumentPath = '/default.aspx'  --page for which the number of views needs to be determined
order by logtime desc


Refrence Links
http://technet.microsoft.com/en-us/library/hh769360(v=office.14).aspx
http://www.codeproject.com/Articles/70865/SharePoint-2010-Logging-Database