Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
SELECT srvr.CustomerName, COUNT(DISTINCT usr.UserID) AS UserCount, COUNT(page.PageExtension) AS PageViews, COUNT(page.PageExtension) AS HitCount FROM fact_IIS_user_ip fact JOIN IISLogServer srvr ON fact.ServerID = srvr.ServerID JOIN dim_IIS_user usr ON fact.UserID = usr.UserID AND usr.username != 'Not Specified' JOIN dim_IIS_Page_PageExtension page ON fact.PageID = page.PageID JOIN dbo.dim_IIS_scstatus stat ON fact.SCStatusID = stat.scstatusid AND stat.scstatus IN (200, 304) WHERE fact.dateid IN (SELECT CONVERT(CHAR(8),GETDATE()-1,112)) AND page.PageExtension IN ('aspx', 'html') GROUP BY CustomerName
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.