Tag Info

Hot answers tagged

8

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

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 ...


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 ...


4

MS suggests 24gb for a dev environment with all services running (10gb for minimal services with Visual Studio) http://technet.microsoft.com/en-us/library/cc262485.aspx#hwforwebserver


4

You might also take into account that the initially required storage capacity will grow over time. Having to split your "catch-all" SiteCollection later on won't be fun, so my recommendation is to start with several SiteCollections and have room for growth


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

READ COMMITTED SNAPSHOT ISOLATION is not supported by SharePoint. Review the presentation below by Lisa Gardner from the PASS Summit back in 2012 for more details. http://blogs.msdn.com/cfs-filesystemfile.ashx/__key/communityserver-components-postattachments/00-10-36-86-42/SQLNSharePoint_5F00_Frienemies.pptx


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 ...


2

Have you check the following: The recovery model for the content database (a SQL Server setting) is set to full by default. Search indexing, if it kicks in, consumes resources that you might need on your WFEs and SQL servers for processing the migration of files Anti-virus software, if it is scanning every document that is uploaded, or is scanning the ...


1

Check to see if you Distributed Cache service is working fine and has all the Default Cache items available. From SP 2013 Management Console, run below commands: Use-CacheCluster Get-CacheHost Get-Cache At this stage if the console shows empty cache list, then you might have lost the cache for some reason. To recreate them try the below: Get the farm ...


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

There aren't any tools built-in for making artificial loads on the SharePoint servers. You would need to use or create a tool for making requests against SharePoint. You can, however, use Performance Monitor in Windows to monitor specific performance metrics from SharePoint. Start with http://technet.microsoft.com/en-us/library/ff758658(v=office.15).aspx ...


1

Even though question is about improving the performance of the query and that has been answered by @GavinB, I want to point out that if you know the url of the list then a better way to get the list is SPWeb.GetList instead of SPWeb.Lists in terms of performance. SPWeb.Lists("name") using (SPSite site = new SPSite(strSite)) { using (SPWeb web = ...


1

It depends on your Setup. but I suggest you to use web.Lists.TryGetList[User_List] instead of web.Lists[User_List] . web.Lists[User_List] throws a null reference error if the list is not there


1

There is no 'correct' time. The execution time will vary depending on your environment specs etc. That code looks pretty good at a helicopter level. Things that might help improve performance there are all related to the query that you compose. First of all make sure that all the filtering columns in the query are indexed, this will help a lot. The next ...


1

Anecdotally I have experienced this too and I believe it to be an issue with WebDAV. Each file you want to copy over via explorer issues about 5-7 http requests as witnessed via Fiddler. In our case people were trying to copy over thousands of very small files, all 5k or less, and because of all the http traffic going back and forth, it slowed the transfer ...


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

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 don't think there is any point in splitting up the libraries given your use case if they all share the same content type and metadata. But how big are these files? Are you taking into account SharePoint's maximum recommended content database size of 200GB?


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 ...


1

The best way to find what is causing the issue with performance is using SPMonitor scope . If you know the webpart which is causing the problem , put all the method calls under the SPMonitor scope for particular webpart. you will come to know what method is taking time in developer dashboard . Further put monitor scope for everyline of code . There might be ...


1

With a Guid of the list you should use SPList list = sPwebObject.Lists.Cast<SPList>().FirstOrDefault(l => l.ID == yourGuidHere) if (list != null) { .. } or if (sPwebObject.Lists.Cast<SPList>().Any(l => l.ID == yourGuidHere)) { .. } With a Title of the list you should use SPList list = sPwebObject.Lists.TryGetList(yourTitleHere); if ...



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