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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How do I limit size of Usage ( Usage and Health Data Collection ) database size please?

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint


How do I control the size of my usage database ( Usage and Health Data Collection database ) in SP2010 so it never exceeds a certain size?

Its not clear how you do this - does anyone know? I want to set it so it never exceeds 100 GB in size but logs pretty much everything.

Thanks in advance,


View Complete Post

More Related Resource Links

Site Collection Usage Summary: No Data Available


Usage analysis processing is enable for my farm in both Central Administration and in the SSP.

I've checked TImer Job Status and the three timer jobs responsible for doing the log analsis are all running.

I've also checked the log file locations and the log files are being generated.

Yet when I browse the "Site collection usage summary" report (SpUsageSite.aspx) I get the following:

No data is available for this report. Usage analysis might have been enabled only recently, or there might have been insufficient usage to result in any values for the report.

My farm is running 2007 Enterprise SP2 (

Can someone confirm if this issue was fixed with one of the CU's that were issues post-SP2?

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

database size limit about SQL Server 2005 Express

I know that there is a size limit (4 GB) for SQL Server 2005 Express, but I am not quite sure if the limit is applied for only ONE database data file or for ALL the database data, suppose I have two databases DB1 and DB2, so which of the following statement is correct? A. The size limit for DB1 is 4GB, and the size limit for DB2 is also 4GB, so if DB1 is 3G and DB2 is 3.5G,that will be OK. B. The total size for both DB1 and DB2 can not be larger than 4GB, which means if DB1 is 3G, then DB2 can not be large than 1G.

Share point database and site collection size, and restrictions and workflow


Sharepoint site collections


More Detail



We had a 3rd party into to develop the share-point service, This is really a very difficult situation not the solution but the documents that are stored and the way it was retrieved.


The real thing is that we receive an item it is booked into SAP and then we send an automated xml to set up a local site this site will then have details from the SAP system fed by ABAP. After the site is created, and then we add documents files and .jpg. These documents must show a detailed audit trail so that if challenged in a court of law can show who had access and who updated documents. 


SO the problem is 


1 Site Collection that is 170gig and the design means that we have 1600 sites and these contain images that are stored in the single site collection. How do we remove the full documents and images and replace with links rather than the doc, img. 


2. We have around 8 business units the problem is that they can share information acros

Site Collection Usage Report Include Outlook?


Hi all,

Does anyone know if the Site Collection Usage Report includes activity that occurs from Outlook? For example, if a user contributes to a discussion board without ever physically touching the site or if the user just reads list content from Outlook, is this included?

ANY help at all is greatly appreciated.


XML size cost to a database

I am in the process of integrating a procedure that imports data into an xml format. The question I have what is the cost on disk versus just importing each colunm. Say I have 10 columns of data, how much more space does an xml column take than just 10 individual columns with the same data. I have searched everywhere and I can not find a definite answer that addresses this question. Any help is greaty appreciated.

site collection size

what is the solution of a site collection if its size grows beyond 100GB?  There is no way we can split it into two site collections and the content database will be large than 100GB even if it contains a signal site collection. Thanks in advance, Peter  

error code for size limit reached

What is the error code, when the DB reaches the 10GB limit. I just wasn't ready yet to check the 36.000 error codes of SQL Server 2008 R2.

Database Mail configuring the maximum mail size (not attachment 'MaxFileSize')

Hi can anyone tell me if it's possible to configure the maximum size of an email when using database mail?  I know it's possible to use sysmail_configure_sp to set 'MaxFileSize', I want to prevent an email being sent the size of the body of the email is very large. In my case the body is based on a query result set inserted as html. Thanks      

calculating the size required for backup of database

Hi, How to calculate the size required to take backup of a database in mssql 2000.the results returned by sp_spaceused differ too much from the actual size taken on the disk. Thanks in advance

Sharepoint Database size question

We have just installed Sharepoint 2010 in our network.  We currently have 2 users who are accessing the system, since we are in alpha stage.  What I have noticed is that  User Profile Service Application_SyncDB database size is at 800mb.  is this normal? In addtion, WSS_Logging database size is at 140mb. 

transport size limit for WCF

Hi, I am returning a Cashflow object from a WCF service, like this. [OperationContract] [ServiceKnownType(typeof(Cashflow))] Cashflow GetCashflow();   The cashflow objects contains a list of double values. After receiving the cashflow object in the WCF client, i am printing the double values contained in it in a text   file. It works well, till the file size is around 500 kb. If the cashflow object is bigger, meaning, the list contains more double values, I get an exception "An error occurred while receiving the HTTP response to http://server.corp.net:1000/service.svc. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details." When I saw the logs in the IIS, the sc-status was 200 and sc-win32-status was 64. I have put maxReceivedMessageSize as 2147483648 in the config file of the client. I am using the wsHttpBinding. I think that I am getting the error coz I am trying to transport a large amount of data through WCF. But in that case the standard error is "The maximum message size quota for incoming messages has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element." Is it possible in some way to return very large data objects

SQL Server XML Size Limit

Hello,I am aware that the maximum amount of space an xml variable can hold is 2GB, and I am fairly certain that is not my problem here; though it does seem to be some sort of size constraint.. kind of? First, my example code, basically generating xml from a table of 4 columns and 275 records: -------------------------------------------------------------------/* SETUP */use tempdbgocreate table mytest (col0 int,col1 varchar(30),col2 varchar(30), col3 varchar(30))godeclare @v intset @v=0while @v<275begin  insert into mytest values (@v,                             'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA',                             'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',                             'CCCCCCCCCCCCCCCCCCCCCCCCCCCCCC')  set @v=@v+1end/* TEST */DECLARE @xmlDoc XMLSET @xmlDoc = (                SELECT 'BEGIN' as '@BEGIN',                      ( SELECT col0 as '@REC_NUM',                               col1,                                col2,                               col3                          FROM mytest                        FOR XML PATH('MYPATH'), TYPE )                FOR XML PATH('XML'), root('ROOT')                )SELECT @xmlDoc as 'WHY IS THIS EMPTY?'/* CLEANUP */drop table mytest------------------------------------------------------------------- My problem is that after creating and populating the table, the code in the 'TEST' section does

Xml size limit


 Hi guys.

I would be grate if someone would let me know what size I should restrict my xml files to on a new website.

I designing a cart for an existing site and looking  to store basic product records in xml which can be called via httprequest etc. The site currently has between two to three hundred sequencial users and I need to clarify the performance limitations and how they may apply before I proceed. Any assistance would be gratefully received




how to Input data from textbox to unknown size of array or arraylist?


I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me?

I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview.

I have more than 1 data to input. Do i need to use loop to bind?

Thank you for your kind attention and patient.

Powerhsell script for MOSS 2007 to get content database size



Can you please provide me a script to get content database size in MOSS 2007.




Size limit for STSADM -o backup


Hi all

Is there a size limit for the .dat backup that can be taken using STSADM -o backup

and for the .dat that can be restore using STSADM.

Thanks in Advance

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