Deprecated Features in SharePoint 2019

When we discuss about new features comes up with new SharePoint version then there is also a list of features added to deprecated list. A deprecated feature is no longer being invested in by Microsoft and may be removed in future major releases of SharePoint Server with no additional notice. Below is the list of …

Continue reading ‘Deprecated Features in SharePoint 2019’ »

Last Option to Fix Database Corruption After a Backup Failure

SQL Database Corruption is the worst thing any SQL DBA or user faces. Corruption in SQL Server is caused due to number of reasons. The reasons could be the IO subsystem, storage subsystem, sudden shutdown etc.You can simply find out the reason of corruption in error logs or can recognize it by checking its symptoms. …

Continue reading ‘Last Option to Fix Database Corruption After a Backup Failure’ »

New Features in SharePoint 2019

The new SharePoint Server 2019 majorly focus on user experiences which is similar to SharePoint Online, and changes in content engagement which can support all browsers and devices (responsive) There are couple of new features added to SharePoint 2019, most of the users already experienced them on SharePoint online for some time now. Below is …

Continue reading ‘New Features in SharePoint 2019’ »

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server. SQL Max Memory= TotalPhysicalMemory – …

Continue reading ‘SharePoint Performance Issue- Set Memory Limits on SQL Server’ »

Best Practice: SQL Server settings before deploying SharePoint Server

Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server. SharePoint Server configures the required settings during provisioning and upgrade. Manually enabling auto-create statistics on a SharePoint database can significantly change the execution plan of a query. We recommend updating the …

Continue reading ‘Best Practice: SQL Server settings before deploying SharePoint Server’ »