Tag Info

Hot answers tagged

6

You should reduce it, and your farm will get benefit from it. Their is no impact rather you will get performance improvement. NodeRunner.exe is resource hungry process. their 3 step process: Use Set-SPEnterpriseSearchService -PerformanceLevel Reduced to reduce the CPU impact the search service Modify the C:\Program Files\Microsoft Office ...


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


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

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

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


1

As per MSFT the limit of items in a Library (including folder) is 30M, that's mean if you have the 1 folder in your document library that can contain upto 30M items. But real Catch is the List View Threshold, which is 5000 items per view( you can change it on prem). So if your library having more than 5K items then you have to filter the items in a way that ...


1

There is no set configuration to guarantee performance. It all varies on how SharePoint is being used. I recommend you read through the Capacity Planning articles and test results and recommendations so you can get a set up that works well for you. If you have trouble going through all the literature, I'm sure you can find a Partner in your area to help you ...


1

The issue is most likely with SQL - which is the source of 95% of all SharePoint performance problems. If you want to see what is actually happening, you can go medium level and run some PerfMon counters and it will tell you where the latency is. If you want more detail you can run SQL profiler which will tell you which operations are actually your bottle ...


1

by default the level is set to maximum when you install the sharepoint search service, Thats because on a live service you expect it to be fast with optimum hardware to support it with the correct topology to break the load from the search service! setting it to reduced is the correct way go about it: on dev machine: 1) Set-SPEnterpriseSearchService ...


1

You need to schedule this only once provided the IIS is not getting resetted regularly. Schedule it in such a way that it run after any IIS RESET operation. Basically what the wakeup script does is, it initiates a HTTP request to the sites/site collections which goes through IIS. Once IIS gets a request it caches information so further visit to the same ...


1

I finally found a safe way to do it. http://msdn.microsoft.com/en-us/library/microsoft.office.server.objectcache.spcacheconfig.aspx


1

The LINQ tools are very handy for developers, but they were never guaranteed to perform better than ugly CAML code or be more resilient to user changes (hint: they rely on display names that may change), for that matter. Look into ULS logs (Set-SPLogLevel -Trace Verbose) for answers in the Database category. Moreover, I assume you're doing this from a ...


1

The following excerpt describes official Microsoft recommendation for 3-tier: This architecture introduces the breakdown of the topology into three tiers:(...) A medium farm deployment is useful to serve environments that have the following: Several service applications distributed across multiple servers. A typical set of features might ...


1

It is highly depend upon on the usage of the SharePoint. Total Number of User, Unique Users and Active User per day How many request per day How many Web Applications How much the Content , Number Of items (Document) how much crawl items? Upload Limit what kind of Service Application, Search, UPA, MMS, Excel etc? Fault Tolerance( 100% up time). If you ...


1

The Question contains a workable solution to make List Attachments clickable. But it isn't feasible when loading dozens of columns and rows, the performance is noticeably affected. Instead, the link should be generated on demand, when the user clicks. Here is a modification on the above code to make it work. This shaved about 3.5 seconds of my loading and ...


1

Firebug displays the total response time of a page incl. the time when the onload event was fired within the summary row at the bottom of the network requests inside its Net panel.


1

one way you can work around this is to use the lightning conductor webpart. it runs on an elevated account which will not look at the threshold. needless to say, this needs to be used with caution, but the built in cache features helps reduce performance impact another approach is to use content iterator SharePoint Server provides a new API, ...


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

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

We have found the solution. After a lot of scoping, we narrowed it down to a web application. I then went on, finding out which site within that web application was the culprit. It turned out to be a single site collection in which over 500k MSG items were stored. These folks (one specific department) are using SharePoint as a mail storage system, because ...


1

The timer job for purging workflows only deletes workflows and workflow associations, it does not touch the workflow history list. This was better documented for SharePoint 2010, but the behavior seems to be the same in SharePoint 2007. You can safely delete items pertaining to completed workflows from the workflow history list, but only if you're certain ...


1

I made also a good warmup script. He works with all supported versions 2007, 2010 and 2013. This script checks prerequisites for a good warmup. Try it and give me feedback ! https://spswakeup.codeplex.com/ SPSWakeUp is a PowerShell script tool to warm up all site collection in your SharePoint environment. It's compatible with all supported versions for ...


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



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