.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

Server Performance

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :SharePoint
Hello, I'm looking for some feedback regarding Sharepoint and server performance. 

I don't know if this is something integrated into Sharepoint or would have to be handled elsewhere but : 

I have a project that involves improving collaboration between two groups in two countries, the current problem is "speed". As it stands, there is a document drop off point in one country and the main complaint is how slow it is from time to time in sharing documents. 

Does Sharepoint have any sort of synchronization tools that have the ability to sync the content to both countries and manage changes appropriately?

I would like to use Sharepoint for other reasons but my primary goal is to find a solution to handle the performance of collaboration.


A computer once beat me at chess, but it was no match for me at kick boxing. - Emo Philips

View Complete Post

More Related Resource Links

SQL Server Performance

Improving .NET Application Performance and Scalability
SQL: Scale Up vs. Scale Out
Stored Procedures
Execution Plans
Deployment Considerations

SQL Server: Uncover Hidden Data to Optimize Application Performance


SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.

Ian Stirk

MSDN Magazine January 2008

IIS 6.0: New Features Improve Your Web Server's Performance, Reliability, and Scalability


As the Web evolves, so does the role that Internet servers play. The Internet has seen the growth of e-commerce, B2B business, collaboration, streaming and other new media, and these new applications require new features to meet increasingly complex needs. Microsoft Internet Information Services (IIS) has many of the features today's mature Web sites need. This article outlines the features in the upcoming version 6.0 and discusses how they promote better scalability, reliability, and performance. Features such as Remote administration, caching, and metabase improvements, as well as custom isolation and security enhancements, make IIS 6.0 the Web server of the future.

George Shepherd

MSDN Magazine March 2002

ATL Server and Visual Studio .NET: Developing High-Performance Web Applications Gets Easier


When developing high-performance applications for the Web, developers often must choose between performance and ease of development. With ATL Server, new with Visual Studio .NET, developers get the best of both worlds. ATL Server uses a tag replacement engine written in C++, provides a simple programming model, and promotes enhanced performance and easy debugging. This article presents an overview of the ATL Server architecture, then creates a basic ATL Server project. It then goes on to explain processing SRF files, HTTP streams, forms, cookies, and header files. Managing session state is also discussed, along with file uploads and performance monitoring.

Shaun McAravey and Ben Hickman

MSDN Magazine October 2000

Designing and Developing High-Performance SharePoint Server 2007 Publishing Sites

Learn about the Web Content Management features in SharePoint Server 2007 that enable organizations to deploy Internet-facing publishing sites, and considerations for developers and designers when designing and building high-performance publishing sites.

SQL Server 2005 Performance Dashboard Reports user context

HI, We are planning on installing the Dashboard reports. But we'd like to know if the Dashboard is run under admin user or the login user who runs the Dashboard reports? Thanks! Kong

MDX query using linked server - performance question

Hi, I'm having a strange performance behavior. When I’m running a mdx query on management studio, it runs for 10 minutes (its mainly calc members on a large cube) When I run the same query via linked server and openquery, it runs for 20 minutes. Is the SQL from some reason does a parsing or running the query twice? The server is sql2008 UP1 on 64bit. and the "allow in process" is checked. its the default in sql2008 Thanks in advance, Yoav  

SQL Server - Performance Collection

Hello: i have question in regards to collection sets when done in file format CSV for more than 4-5 days. usally when done for more than 3-4 days & Perfmon CSV file open in Excel is very misleading when viewed in graphical format. for e.g. when i see in graph format for processor time done for 4-5 days it shows like 90% usage but when doing AVERAGE for same counter show like 10-15%. is there better way to display same info in a correct graphical format. I am not interested in 3rd party tool & i know they can provide more accurate information. i am looking for defaults that comes with Microsoft. Any help is appreciated. Thanks  

Slow performance when searching in "any part of field" of a SQL Server database using a Microsoft Ac

We have just migrated our back end database from Access to MS SQL Server 2008 R2. We have noticed better performance on our searches - unless we select to search in "any part of field" in Access (with Access' built-in search function - we use a mix of Access 2003 and 2007). This takes nearly 20 seconds to find the result, whereas before the migration it was taking 5-7 seconds (compared to instant results we now experience when searching for whole fields). The main fields we search are not large - usually just two words. Obviously it is better to search for a whole or start of a field, but this is not always possible. The contractor that assisted us in this project has told us that this "is just the way SQL works with Access". Is this really true? I find it hard to believe two MS products would have such a big issue between them. I presumed using SQL with an Access front end would be a common setup, which is why I thought this must be a problem with our setup. Is there any way to fix this speed issue?

Performance Monitor Counters To View How "Busy" A SQL Server Is

What are some good performance monitor counters to look at, when trying to figure out how "busy" our SQL 2008 server is? We were told to look at: SQLServer: SQL Statistics: Batch Requests/Sec and SQLServer: Databases: Transaction/Sec . Any other critical ones? Is there a counter to get the number of  selects, updates, and deletes independently per second? Thanks.

How to calculate a SQL Server performance of a query based upon table schema, table size, and availa

Hi What is the best way to calculate (without actual access to a SQL Server) the processing speed of a query (self-inner-join) based upon table schema, table size, and hardware (CPU, RAM, Drives)? ThanksThanks Jeff in Seattle

SQL Server 2008 performance: Decision to spend budget to upgrade to enterprise edition

Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

SQL server poor performance - Urgent help

I have a windows 2003 Server Processor 880, 2.40GHz and 8Gb RamIts 64 bit  - SQL 2005It is on a SAN with Raid 5 on disksThere is one 50gb database mainly being used.The Server CPU is constantly up and down and Maxing out every few mins.There are runnable processes running and numerous suspended.Running Sp_who2 doesn't give much info and often shows no blocking or anything noticeable.Users are getting timeouts and not able to use the system.I looked at the memory allocation it was ;The Results were;name minimum maximum config_value run_valuemax server memory (MB) 16 2147483647 2147483647 2147483647name minimum maximum config_value run_valuemin server memory (MB) 0 2147483647 0 0 I have updated this and amended BOTH to be 6500, being max and min but not certain this is right.I can see in task manager in the performance window that it's using at 8gb, but if you look at the processes tab sqlserver.exe is only using 149 858k. I do not understand why sqlserver.exe is NOT using the available memory ? For example I ran DBCC checkdb and the only user on the server as it's out of hours and this task alone maxes out the CPU.I am also about to rebuild indexes and complete some other maintenance tasks.I'm very puzzled that simple tasks are maxing out the CPU but no memory is being used. My company is unable to complete ANY work…..this is urgent please help.Thanks

Performance perspective of Lookup function in SQL Server 2008 R2

Hi, Recently I had presented a session on SSRS 2008 R2 enhancements. As part of that I explained about LOOKUP function and its way of working. There was a question while presenting this feature. From performance perspective, what are the advantages of LOOKUP function over conventional implementation of JOINING the lookup tables in stored procedure itself. I tried explaining that, it enables to make best utilization of resources in scaleout environment because the logic of JOIN evaluation has been shifted to Report Server than a database server. Some how the participants were not convinced. I would request experts to comment on this and help me in understanding whether my evaluation is correct or is there anything I am missing over here during my explanation. Please help.Phani Note: Please mark the post as answered if it answers your question.

SQL Server 2005 Analysis Services - Performance of Excel Pivot Tables

Hi, I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk. The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has only one processor (there are 8...) at 100%... Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes... Thanks in advance Hugo

The SQL Server performance counter 'Page Splits/sec' (instance 'N/A') of object 'SQLServer:Acce

I am getting these page split errors every 5 minutes I have tried everything reindexing rebuilding working with different fill factor values But nothing seems to effect this problem. The threshold is now set to 100 (what the max threshold number i can set the alert to ?) Also please let me know how to get rid of the pagesplit alerts. thanks
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