SharePoint 2010 performance relies heavily on database performance. SharePoint performs many queries on databases to process each page request. Most of the time the design focus tends to fall more towards the SharePoint application server architecture. Database Server and network performance are one of the major factors dictating the overall performance of the SharePoint applications. When the SharePoint database grows above 100 GB it begins to impact performance issues related to the Database server.SharePoint Content DataBaseContent Databases need to be set up carefully to attain the maximum performance. We need to take different performance issues into consideration.
Gather storage and SQL Server space and I/O requirements
Raid Levels of SQL Serevr
SQLIO Disk Subsystem Benchmark ToolMemoryMemory needs to be managed wisely for better performance. When the SQL Server starts, it dynamically determines how much memory to allocate based on how much memory the operating system and other applications are currently using. If there is substantial memory pressure like PLE is consistently below 350 (50 -200 which is very low) then the memory needs to be bumped for the performance of the application. Fine tuning the following configuration settings of SQL server will help in improving the performance.
min server memory (min value 0)
max server memory (min value 16MB)
max worker threads
index create memory
min memory per query16GB Memory Memory Setup
Server Memory Options
Optimizing Server Performance Using Memory Configuration Options
How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
Hardware and software requirementsProcessor
64-bit, four cores for small deployments
64-bit, eight cores for medium deployments
RAM
8 GB for small deployments
16 GB for medium deployments
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: