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

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

query w.r.t to SharePoint 2010 Performance Planning & Extranet Topology

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :SharePoint
  1.      Which extranet topology to go with in case of exposing Intranet to Remote Employees / Partners ?   My understanding:   There are 3 extranet topologies : Edge Firewall , Back to Back , Split back to back   If Scenario is : a)      Only Employees needs to access Intranet from Home ,we can go for Edge Firewall b)      If partners & Employees , both needs to access Intranet ( it will have some partner sites ) , then we can go for Back to Back OR Split back to back .   Questions: ·         Is Understanding correct ? ·         Is there any factor which can help in making a decision between Back to Back Or Split back to back ?   2.      As part of sizing , I read that we should capture following information -          What should be maximum acceptable CPU utilization in production servers ? ( Example : 70%) -          What will be the concurrent number of users accessing portal during peak hour of a day ? ( Example 1000 users from total of 18000 users ) -          How many request per second are done to portal

View Complete Post

More Related Resource Links

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Sharepoint 2010 FullTextSqlQuery query problem with where condition

Hello, i´m developing a webpart under Sharepoint 2010, i need to launch some different query´s to filter data but i´m having problems. First of all, i launch this query and i get all the users; SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') ORDER BY "Rank" DESC with that results i fill different dropdownlist with each of the columns, then I can filter for each column. For example: I filter by PreferredName, Lastname or WorkEmail, with this query SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') AND (("LastName" Like '%MOSS%')) ORDER BY "Rank" DESC But when i try to use the columns Department, OfficeNumber and Jobtitle every query returns 0 rows. SELECT PreferredName, LastName, Department, OfficeNumber, JobTitle, WorkEmail, PictureUrl FROM Scope() WHERE ("scope" = 'Personas') AND (("Department" Like '%Dirección%')) ORDER BY "Rank" DESC The main thing is if i get all the data i see that these columns (officeNumber, Jobtitle, Department) are not empty. Some of them have values some of them don´t. All the columns have the property "Reduce storage recquirement for text propert

SharePoint 2010 - Performance Point & Dashboard Designer

We have successfully installed SharePoint 2010 onto our dev machine; we have also followed the documented steps for configuring Performance Point; http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx.  All seems fine however we do not seem to be able to create a connection from Dashboard designer back into SharePoint.  When we check the logs we get the following error Critical   An unexpected error occurred.  Error 5678.  Exception details: Microsoft.SharePoint.Upgrade.SPUpgradeCompatibilityException: There is a compatibility range mismatch between the Web server and database "WSS_Content_PerformancePoint_1", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range. We have a farm config on a single 64 bit box and SQL Server 2008 loaded.  We have un-installed and re-installed the site collection. Does anyone have any ideas? Eddie Barrett

Query server not responding in SharePoint 2010


When I try to search anything in SharePoint 2010 site its showing

Internal Server Exception.

So when i looked into the Central administraion page ->Manage Service Applications->Shares Services-Search Service:Search Administraion it is showing "Query server not responding (4eb29e88-2523-4f3a-9a7b-4a96d33e570e-query-0)"

Anyone please help me to solve the search error


Setting SharePoint 2010 Form Fields Using Query String Variables


Hi All,

I have a requirement to populate sharepoint form field value with query string while uploading document to document library.

While uploading the document to document library, I want to populate claim number available from query string in a pop up page i.e in my case EditForm.aspx, Located at http://servername:port/sitename/documentlibraryname/forms/EditForm.aspx.

Additional Information:

  • Created document library and added custom columns like claim number etc..
  • Created a view to filter uploaded documents as per claim number.

Server Details:

  • Windows Server 2008 R2
  • SharePoint 2010
  • SQL Server 2008 R2

I have written javascript for the same, but not sure where exactly to add the code in EditForm.aspx page.

Any help on this would be greatly appreciated.

Thanking you in advacne.



Performance(Load/Stress) testing in the SharePoint 2010?


I have SharePoint Server 2010 Enterprise based small farm. Farm consist of 2 servers. All users are in AD. This Intranet portal is currently on development phase and we don't have all 300 users active. There are currenly only 10 users who are part of the development project.

How to test performance of the SharePoint farm?

In past, I used to test performance of SharePoint 2007 with SQL Server Profiler and Windows Server 2003 Performance Monitor. Is this method good enough to measure actual performance? Any better tools for this?

How about load testing of SharePoint 2010 Server?

Is there tools can generate loads and reports?

Any experience about Load testing with Visual Studio 2010?

Load testing tool the Microsoft SharePoint 2010 Administration Toolkit is for testing SharePoint 2007?

Is Load testing tool totally wrong tool for SharePoint 2010 Server?



Problem with content DB planning SharePoint 2010


Hi Guys

I need to find out what to do regarding planning out content databases. The problem is that I need to design a solution where I would have two different types of content. I want to keep the site collections as simple as possible so I want to use a records centre with two document libraries for each content type.

Now the problem I have is that there is going to be about 8 Site Collections each with up to 8 terrabytes of content I need to store.

This will obviously affect performance. What can I look at here?


sharepoint 2010 Search topology ?


Hi Team,

I have gone through the microsoft site for information but could not get what actualy it want to say.

What does following statement means, please explain with example:

  • Add or remove an index partition
  • Add or remove a query component
  • Add or remove a crawl database
  • Add or remove a crawl component
  • Add or remove a property database
  • Add or remove a host distribution rule

  • manoj.verma

    Inconvenient SharePoint 2010 Content Query Web Part and Anonymous Access


    Morning every one

    I am hoping some one has found a work around regarding this.

    I am using a JQuery random 'quote' generator (http://nextconnect.blogspot.com/2009/12/jquery-random-quote-viewer.html) in my site.I have enabled full anonymous access. My issue is that it still prompts you for the login in order to see the quote generator. I have tried the "ViewFormPagesLockDown" fix but it isn't even activated on my site. And now I am at a complete loss. I did some googling (Read 5 hours) and it seems that in Sharepoint 2010 doesn't have a work around for this and I am really hoping I am wrong.


    Any ideas?


    Have a great friday :)


    Server FARM Topology : 2010 imp query?


    HI have 4 farm:-


    2nd FARM (n Server) Application hosting WFE

    3rd FARM (n Server) Application Servers

    How would the communication in the FARM will happen?

    How the data shearing like MYSITE creating, Indexing etc will take place amoung these various farms?


    Content Query Web Part Sharepoint 2010 AND Customize the data presentation


    In fields to display you have a Title field. We will like to show two columns (Section Name and Status) in the title field, but only the fist one is displayed in the result.We use this syntax:

    Column [Group];Column [Group]

    When I use this formula

    Section Name [Agresso R&D Base Columns] ; Status [Agresso R&D Base Columns ]

    in the title field, the Section Name is displayed, and no Status, When I use this formula

    Status [Agresso R&D Base Columns ]; Section Name [Agresso R&D Base Columns] ;

    in the title field the Status field is displayed, and no section name. Is this a bug? or is it an other way to show both columns in the title field?


    Fields to display Depending on the scope of your query, you can select one or more site or list columns whose values you want to show in the display slots for this style. To specify a column from a particular group, type the name of the group in square brackets after the column name, for example, Column [Group]. Be sure to separate each column you enter with a semi-colon.


    Viewing Video's in Sharepoint 2010--Will it slow down the performance for the end users?


    I understand how to upload files to the media web part and creating an asset library, however; i'm trying to figure out where these files are being stored and the performance of the users.  I read the digital asset management library information on technet and couldn't find the exact answer i'm looking for. 

    So, here's my question:  If I want to upload 10 videos to the asset library, they each may have around 50mb or less for the file size, and we want 200 plus users to access it, will this affect the performance of when these users hit the site?  We want to display the video's without having to buy a media server.  And the main question that will be asked is, who will host the content?  And, where is it residing?  My guess is that tt will be hosted in SP 2010.

    I'm trying to incorporate a new intranet portal site for my company that will have a video to be played on the home page of the intranet site and the links will be located on the left and right side of the page with the video webpart in the center.  Will using the Blob cache and bit throttling be sufficient for this request?  I think it will be, I just want to make sure before we role this out.  Any help will be greatly appreciated.  Thanks.



    Sharepoint 2010 Excel Services Extranet Access


    Hi to all,
    I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).

    I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the excellent SP2010 Kerberos Guide.

    Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.

    In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.

    So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".

    Anyone has any hint on the possible causes?

    Thanks in

    SharePoint 2010 sql search query issues



    I am using tool for testing SharePoint search queries (http://blogs.technet.com/b/speschka/archive/2010/08/15/free-developer-search-tool-for-sharepoint-2010-search-and-fast-search-for-sharepoint.aspx). I have tested some queries and received some strange results. For example:


    SELECT Size, Rank, Path, Title, Description, Write, Filename, FileExtension FROM scope() WHERE CONTAINS (Title, 'get') ORDER BY Rank DESC

    This query returns two results for me. And next one returns no results.

    SELECT Size, Rank, Path, Title, Description, Write, Filename, FileExtension FROM scope() WHERE Title LIKE '%get%' ORDER BY Rank DESC

    However I was expecting to receive two or more results.


    Another example is:

    SELECT Size, Rank, Path, Title, Description, Write, Filename, FileExtension FROM scope() WHERE FileExtension = 'txt' ORDER BY Rank DESC

    This query returns one result for me. And next one returns no results.

    SELECT Size, Rank, Path, Title, Description, Write, Filename, FileExtension FROM scope() WHERE CONTAINS (FileExtension, 'txt') ORDER BY Rank DESC

    I was expecting at least one result from this query. I would like also to mention that issue #2 is reproducible for FileExtension property only.

    Could anyone please help me with these issues. Thanks beforehand for any help.


    SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


    I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

    The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

    Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

    I have user IP instead of host name in the report server url.

    Please help.



    SSRS 2008 R2 and Sharepoint 2010 - performance problems


    Hi all,

    I'm currently in a DWH project using SSRS 2008 R2 x64 in Sharepoint Integrated mode along with Sharepoint 2010, and we're seeing massive performance problems even though traffic on the server is at a bare minimum. We're in development with a maximum of a few users online at any given time and the server itself isn't doing a whole lot...cpu is usually < 20%. We have timed the database queries and 90% of them are taking less than a second to execute while reports takes anywhere from 5 to 30 seconds to load (some heavier reports can occasionally take a lot longer). I am simply unable to get anything to load in less than 5 seconds, even the simples grid from a SELECT TOP 5 * FROM table query takes this long.

    The server setup is suboptimal as SQL Server, Reporting Services and Sharepoint are all running on the same virtual machine but with the minimal amount of traffic we have this shouldn't really be a problem. The server is a Win 2008 x64 Datacenter with 4 CPU's and 16GB RAM.

    A standard sharepoint page that gets data from the database is returned in milliseconds...why doesn't reporting services do the same? What can I do to increase performance?


    CAML Query for display Top n records in sharepoint 2010


    Hi friends,

    I have added the Content Query web part in my publishing page for displaying data from list.

    Now i want to use additional filter option from content query web part.

    pls tell me wht query i should write for returning Top n Records from list.

    also pls tell me whole caml query format dat i need to put in custom value or query option in additional filter option in Content Query Web Part

    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