Tag Info

Hot answers tagged

7

You're within the limitations of SharePoint (http://technet.microsoft.com/en-us/library/cc262787.aspx) in either scenario, which is good. Some of my thoughts As far as performance, I don't think you'll see much in way of improvement going from one DB to multiple DBs, unless you can move the DB files to different disk arrays. 100GB is a reasonable size for ...


6

I'd guess the culprit would be: SPFile file = web.Files[0]; This will load the entire collection into memory, even though you are only after a specific file. Use SPWeb.GetFile() instead. Edit Additionally, SharePoint 2007 and WSS 3.0 Dispose Patterns by Example provides an example of using the SPLimitedWebPartManager, that requires an explicit ...


4

My problem solved! Have look at: http://blog.blksthl.com/2013/05/15/sharepoint-2013-page-loads-takes-a-very-long-time/ turn off distributed cache: Site loading time with it off: site loading time with it on: !!! From 6.10 seconds down to 79 ms


4

SPWakeup WSS3.0/2007 - http://spwakeup.codeplex.com/ SharePoint 2010/2013 - https://spbestwarmup.codeplex.com/ SharePoint 2013 - http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=404 I've always used it every morning, right after resetting IIS. Just schedule a task scheduler to reset IIS, and then another task scheduler to run this script 2 minutes ...


3

Basically yes, that includes everything (blob storage). You can go over that limit, but there are some very specific requirements if you do. Take a look at the requirements in these links: http://technet.microsoft.com/en-us/library/cc262787%28office.14%29.aspx#ContentDB http://technet.microsoft.com/en-us/library/hh307867%28v=office.14%29.aspx Here ...


3

WHAT I PRESUME 1) you are working with custom js code 2) you are working with a custom page SOLUTION 1) don't use ScriptLink : If you register a .js file by adding a ScriptLink control to an .aspx page, the control registers all .js dependencies. To import the various "SP" namespaces, such as those listed at ECMAScript Object Model Reference, you ...


2

There are many ways to get your query optimized (for example in batches). My recommendation is to use some SPQuery object properties. Here goes an example SPQuery query = new SPQuery(); string view = "<FieldRef Name='Title'/><FieldRef Name='Field1'/><FieldRef Name='Field2'/>" query.ViewFields = view; query.ViewFieldsOnly = true; ...


2

Here are some helpful tips on how to troubleshoot: 1. Make sure you have downloaded the correct version of SharePoint Designer 2013. You can download it via the following link: http://www.microsoft.com/en-us/download/details.aspx?id=35491 2. Make sure you install and configure workflow for SharePoint Server 2013 correctly. You can refer to: ...


2

The BLOB cache should be flushed on all servers running the Foundation Web service. When FlushBlobCache($webApp), the flush will not be immediate. As for how to tell, you can simply see if the property "blobcacheflushcount" is incremented by 1, or is a new property (if you haven't flushed the cache before) to confirm the Flush Command is queued. Just run: ...


2

TEMPDB is a temporary database that contains all Temporary user objects such as: global or local temporary tables, table variables, cursors. It also includes internal objects created by the SQL Server Database Engine; For example, work tables to store intermediate results for spools or sorting. All the mechanism of row versions is being handled and managed ...


1

I'm no expert on Linq to SharePoint but it does have a long history of major performance issues. Here are some links that might point you towards an answer for your particular situation. The first link is probably the most useful as it shows how simple changes to a Linq query can cause significant delays in run time. The other two provide more than ...


1

In your comment you stated you would have 10-50 new subsites per day. This would probably not cause any major issues as long as you aren't running a process which creates a large amount all at once. I would also try to segment this across multiple site collections where appropriate. Note that a single site collection can only use a single content ...


1

Most common issues regarding the Slowness of pages due to sql server. Recently we experienced a big performance hit after upgrading farm to August CU 2013, at the end we come to know querry against All doc table taking 9 sec to execute.behind the scene something trigering from sharepoint and required new stats on AllDOc tables....MSFT still working on it to ...


1

There is many scripts available, some using with PowerShell, some with VB script and some using with the API. Its depend on you which one is best suitable for you. Another point to think before using any script, do you want to wake up only root level site or all sites in the web applications? Because now a days many PowerShell scrip basically go through all ...


1

As you say yourself, most of the files are SharePoint standard files, that will be downloaded when the user first hits SharePoint and then a cached version will be used. So in your case I think the Delta between a blank Community site and your modified one will be the best indication on if your modifications are "too heavy" (As a reference, the Portal ...


1

I experience performance issues with anything less that 16GB of RAM for my SP2013 development environments. 32GB would be even better if you have it. I have also noticed better performance (and this is the case with most Windows services running under Hyper-V) when I use only 1 CPU core (or possibly 2). Anything over that results in degraded performance ...


1

To help improve the performance of a large list or library, you can index up to 20 columns. In general, an index on a column enables you to quickly find the rows you want based on the values in that column, even when working with millions of items. When you combine indexes with filtered views, you can quickly retrieve the items you want. It ...


1

According to this article: http://technet.microsoft.com/en-us/library/hh144782(v=office.14).aspx It looks as though that may point to the service accounts such as search/content, and the web application pool accounts. Requests Per User This report displays the percentage of requests made by the most common user accounts. Some system accounts, ...


1

I encountered the same high CPU problems on our Workflow Manager server. However, on our server we had already installed the February 2013 Cumulative Update. The Workflow Manager event log was flooded with the following error message: Failed SQL command after 1 tries with error '229'. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE ...


1

I would hazard a guess that your SQL server is critically under-spec'd for your environment. Please ensure it has enough RAM on the server itself, and that the database engine is configured correctly for it's memory usage. As you haven't stated what version of SharePoint you are using, please locate the TechNet documentation for hardware and software ...



Only top voted, non community-wiki answers of a minimum length are eligible