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


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

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


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


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

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

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

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

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

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



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