Home
About Us
Advertise
Printable version
Why SharePoint admins need a say in storage
By Rob Bloemendal
September 12, 2013 —
(Page 1 of 2)
Sharing information and collaborating on work has increased productivity as well as fostered creativity. As SharePoint deployments grow with the business, application managers have more data to maintain. But it also poses a challenge to the storage admin who suffers from performance degradation as well as increased acquisition costs. Both impede the benefits of the organization’s collaboration and the value of the document-management solution.
There are five common challenges that application managers face due to SharePoint running sub-optimally on traditional storage subsystems. I’m writing to tell you the suffering can end for application, storage and database administrators.
1. Size of the database
The size of the content database has always been a challenge for SharePoint application managers. It used to be 200GB, and now with SharePoint 2012, it can go up to 4TB. This 4TB scale-up gives a completely different approach to the required storage perspective.
The recommended number of IOPS for performance is 2 IOPS per GB. So this means that for a 4TB content database the storage system needs to deliver 8,000 IOPS per content database. This would mean that for 200TB in a SharePoint farm, you need to have 400,000 IOPS. What kind of impact does this have on your application performance? Better yet, how quickly can the data be retrieved and delivered to the end user? These are important questions to consider in avoiding an unhappy user experience with the phenomenal growth of the storage consumption and the user connectivity.
2. DBCC consistency checks
The main reason to use bigger databases is the reduction of servers and SQL Server licenses. The size of a content database has a negative impact on the database consistency check. The data integrity of the SQL Server needs to be regularly checked. The bigger the database size, the longer it takes.
This is a maintenance task and cannot be run during production hours. Four terabytes is 20x the previous size of the content database. If the previous consistency checks took one hour, will that be 40 hours for a 4TB environment? How will that impact the other maintenance requirements, like backup? It will only leave eight hours in the weekend to get that in order.
3. Index and statistics defragmentation
When the database is indeed growing up to 4TB per content database, it is also clear that the index and statistics defragmentation will take longer. The index has about 20% of the content database as a sizing rule. This means that the defragmentation needs to happen on 800GB rather than on 40GB. This will have a major impact on the amount of time for performing this task. And it cannot be scheduled like the consistency checks; this will occur randomly at the point that SharePoint finds it necessary. The end result is that it will have an impact on the user experience for all the databases running from the same SQL Server.
Next Page
Pages
1
2
Share this link:
https://sptechweb.com/link/64098
Related Articles
Customizing SharePoint Online Using SharePoint Designer, Part 1
Once you get a handle on SharePoint Online, the question becomes: How can I modify it to suit my needs. First of two parts.
Kodak helps SPTechCon attendees better manage their most valuable documents using Microsoft SharePoint
Experts at the Kodak booth will help attendees optimize SharePoint and automate workflows that process valuable documents
RAMP unveils beta of RAMP for SharePoint Online at SPTechCon Boston
Solution leverages RAMP’s MediaCloud platform to provide secure, cloud-based video management within Microsoft
Add comment
Name*
Email*
Country
United States
Canada
Afghanistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua & Barbuda
Antilles, Netherlands
Arabia, Saudi
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas, The
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Brazil
British Virgin Islands
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Cook Islands
Costa Rica
Cote D'Ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor (Timor-Leste)
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands (Malvinas)
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
Gabon
Gambia, the
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guinea, Equatorial
Guyana
Haiti
Holland (see Netherlands)
Honduras
Hong Kong, (China)
Hungary
Iceland
India
Indonesia
Iran, Islamic Republic of
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Korea (North)
Korea (South)
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macao, (China)
Macedonia, TFYR
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia, Federated States of
Moldova, Republic of
Monaco
Mongolia
Montenegro
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Palestinian Territory
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russia (Russian Federation)
Rwanda
Saint Helena
Saint Kitts and Nevis
Saint Lucia
Saint Pierre and Miquelon
Saint Vincent and the Grenadines
Samoa
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia & Montenegro
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Taiwan
Tajikistan
Tanzania, United Republic of
Thailand
Timor-Leste (East Timor)
Togo
Tokelau
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
Uruguay
Uzbekistan
Vanuatu
Vatican City State (Holy See)
Venezuela
VietNam
Virgin Islands, British
Virgin Islands, U.S.
Wallis and Futuna
Western Sahara
Yemen
Zambia
Zanzibar
Zimbabwe
[Not specified]
Compose