.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Estimating Web Analytics db sizes - how?

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :SharePoint
 

Hi all,

 

I have spent literally days and days looking for info on how to size our web analytics databases for a new SP2010 install.

 

I found the great whitepaper : http://technet.microsoft.com/en-us/library/cc298801.aspx   for SQL db sizing and it does all databases EXCEPT the Web anlaytics dbs.

 

We


View Complete Post


More Related Resource Links

Estimating Web analytics database sizes Sp2010 new install

  

Hi

Does anyone know, if we know the number of expected users, number of documents and general usage of a SP2010 system, how I could estimate the sizes of the 2 web analytics databases please? I'm trying to get a very rough idea of SQL db sizing and this part of the process has me stumped. I have spent a lot of time reading all the MS whitepapers and they are good for size estimation except for these 2 databases.

Any help much appreciated.

Thanks in advance,

SG 


SharePoint Gets Search Analytics

  
Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Implementing Google Analytics in Asp.net mvc

  
I want to integrate Google analytics in my asp.net mvc application. So im doing some R&D for it to find out which one is the better. I find out a Google Analytic Dashboard Controls which are available at http://gadashboardcontrols.codeplex.com/ But they are server control and im not sure how to implement in asp.net mvc. Secondly can i implement asp.net charts in my asp.net mvc application?

Site Web Analytics Reports not updating

  
When I go to my site > site settings > Site Web Analytics reports or Site Collection Analytics reports I get old data as in the ribbon displayed "Data Last Updated: 7/10/2010 4:00:20 AM" - Web Analytics Data Processing Service & Web Analytics Web Service are "Running" - Followed http://technet.microsoft.com/en-us/library/ff453926.aspx No success anyone an idea?

Need to learn how to change FONT SIZES within web parts through Sharepoint

  
I'm a new user to Sharepoint 2010 - have casually used Sharepoint Services since 2.0. I'm trying to find a way to change the FONT SIZE of Links in a LINK web part - there does not seem to be a user-friendly option for this.  How can I increase the font size of links in a LINK web part, so that the user can see them more easily?  Does it require something in Sharepoint Designer to do this?  If so - is there any info on easy steps to navigate Sharepoint Designer, to do a simple task like increasing a font size of the links?

How to use SharePoint web analytics data programatically?

  
Hello Everyone, We have a requirement to pull out the 10 most visited pages from a particular Content Type and show them on a Web Part. We need to display the titles of these articles. Therefore, I would assume that only way to proceed is to create a custom Web Part that programmatically retrieves the web analytic data (OOTB Web Anlytics Web Part cannot be used due to the lack of customizability). So far, we could not find any details on how to use web analytics data programmatically. Any help on this is greatly appreciated. * Note that SPWeb.GetUsageData() is useless as it returns only 2000 records. We also looked at the reflected code of Web Analytics Web Part, and the code is fairly complex as it directly consumes the Web Analytics Service Application.   Thanks & Regards, Amal  

setting message sizes for wcf web service

  
Hi.    I am working on silverlight application that communicates with wcf web service. I have function on service side that takes string as parameter. like:    [OperationContract ]          bool DoSomeServiceWork (string imputText );    when i call this function (using auto generated proxy) asynchronously with string smaller than certain size (around 1000 chars) everything works fine.    As soon as string size gets larger, i get exception "The remote server returned an error: NotFound ."    Now it seems to me that problem is in message size so i tried to change maximum buffer, maximum message size everywhere in the confing files i could find them, but nothing helps.  It come to me that obviously i don't know what I'am doing so can someone help me out here ?    (i found in different forums many posts regarding maximum message size but nothing helped, most of them are suggesting changing values in various confing files but it seems it doesn't work, and there is nowhere explanation what those numbers actually change, because its obviously not parameter size for a function) I'm completely missing something out here. sending few kb to web service suppose to be easy, and I'm getting crazy here.    btw can somebody please give complete instructions

Setting message sizes for wcf web service

  
Hi.    I am working on silverlight application that communicates with wcf web service. I have function on service side that takes string as parameter. like:    [OperationContract ]          bool DoSomeServiceWork (string imputText );    when i call this function (using auto generated proxy) asynchronously with string smaller than certain size (around 1000 chars) everything works fine.    As soon as string size gets larger, i get exception "The remote server returned an error: NotFound ."    Now it seems to me that problem is in message size so i tried to change maximum buffer, maximum message size everywhere in the confing files i could find them, but nothing helps.  It come to me that obviously i don't know what I'am doing so can someone help me out here ?    (i found in different forums many posts regarding maximum message size but nothing helped, most of them are suggesting changing values in various confing files but it seems it doesn't work, and there is nowhere explanation what those numbers actually change, because its obviously not parameter size for a function) I'm completely missing something out here. sending few kb to web service suppose to be easy, and I'm getting crazy here.    btw can somebody please give complete instructions

Controls appear as different sizes on two different computers

  
Hello, i've got a very strange problem. I've noticed that when i build a windows form, some of the controls appear as different sizes depending on the machine on which they are running. For instance, if a text box is 200 long on one PC, it will display as 50 long on another. Has anyone experienced this problem in the past?

Site Web Analytics reports and Site Collection Web Analytics reports show no data

  
Although I have enabled all the web analytics and health data collection option and can see that usage data files are being created both my Site Web and Site Collection analytics reports show no activity. I have checked the Sharepoint 2010 documentation and it basically states only thing to do is enable the respective option under the 'Configure web analytics and health data collection' section.

How to enable Web Analytics?

  
1. Central Admin: Web Analytics Service Application is OK
2. Central Admin: Web Analytics Service is started
3. Site Collection: Feature is enabled
4. Site Collection: Web Analytics Reports: No reports available.

Kenny_I

Google Analytics with asp.net c#

  

Hello ,


        I want to track google analytic ecommerce  data through asp.net c# code. 

        The format I  want  is  :  transaction Id              |      Landing Page Path   |  Date


        If some one did it before or haev any resource to do it , please share with us.

     

Thanks

Udal


Web Analytics job schedule

  

Hello,

I have a request from our information architect to update the web analytics more frequently.  Currently the site web analytics pages show an update time of 2am every day.  I thought this would be done by the 2 Health analyzer jobs in Central Admin -> Monitoring -> Review Job definitions.  I ran the following two jobs: Health Analysis Job (Daily, Web Analytics Data Processing Service, Any Server) and Health Analysis Job (Daily, Web Analytics Web Service, Any Server) and the site web analytics did not update.  What am I missing here?


Problem with Web Analytics

  
Hello all!
Three days ago my Web Analytics doesn't work. I show all reports, but data is empty. Jobs working! I'm used Sharepoint Server 2010 beta
What's wrong?

Web Analytics: Monitors the health of...

  
Health Analyzer reported this
The running time for the Report Consolidator component should always be less than 12 hours.
RunningTime > Threshold: Service Application:Web Analytics Service Application\t Database:WebAnalyticsServiceApplication_ReportingDB_a8f287bd-a020-409d-ba0c-ac9ee5267daf.
The running time for the Logging Extractor component should always be less than the threshold.
RunningTime > Threshold: Service Application:Web Analytics Service Application\t Database:WebAnalyticsServiceApplication_StagingDB_2a76b63f-a7d1-4bb4-9343-6331493aa96e.
The running time for the Data Analyzer Light component should always be less than the threshold.
RunningTime > Threshold: Service Application:Web Analytics Service Application\t Database:WebAnalyticsServiceApplication_StagingDB_2a76b63f-a7d1-4bb4-9343-6331493aa96e
The running time and the batch queue size for the User Behavior Analyzer component should always be less than the threshold.
RunningTime > Threshold: Service Application:Web Analytics Service Application\t Database:WebAnalyticsServiceApplication_StagingDB_2a76b63f-a7d1-4bb4-9343-6331493aa96e.
This is a fresh build. Not enough going on to warant more data bases.
Anyone run into this yet?

Web Analytics Service Functionality Questions

  
 

I started the Web Analytics Service 2 days ago and the site collection analytics displayed it's first set of data yesterday.  Couple questions I have:

  1. On the Summary page, does the Value (Previous) display the previous days metrics? 
  1. Under the Inventory section, all the pages (i.e. Storage Usage, Number of Sites, Top Site Product Version, Top Site Languages) display the following message:

There is no data available for this report. Here are some possible reasons: (1) Web Analytics has not been enabled long enough to generate data; (2) There is insufficient data to generate this report; (3) Data logging required for this report might not be enabled; (4) Data aggregation might not be enabled at the level required for this report.

Could this be more likely due to reason (1) or am I missing something in order

Web Analytics logs are empty

  

The situation is similar to this post (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/790b0068-1815-4278-a5e9-32204b3a41c7).

I configured Web Analytics application service to C:\SPLOG directory.
Some of the log files like an upgrading log are created normally. But web analytics logs are created without any contents. All are 0 KB.

Considering of file permissions, I added EVERYONE's Full Control to the log directory. However nothing changed.

An somebody in the referenced post mentioned at the top of the article said changing a service account to localservice is working for the issue, but I do not want to change to local accounts.

Is anyone having same issue? If you sense some hints, please help me.

Thank you!


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend