Articles about European Sharepoint Hosting Service
Posts tagged cheap sharepoint 2013
European SharePoint 2013 Hosting :: SharePoint 2013 Content Databases and the AllUserData Table
Jul 19th
I believe that some of you never realize that something’s changed of the content database in SharePoint 2013. Is that correct? As you know, AllUserData table has changed. See this:
First of all, what’s happened to columns [nvarchar1], [nvarchar2] (skip a few) [nvarchar64]? How about [int1] to [int16]?
They’ve all been combined into a fragment of Xml, and stored in a single column [tp_ColumnSet].
Let’s zoom in and have a look at one of those Column Sets:
That’s interesting.
Wide List Issues
Firstly, this means “wide lists” are going to be potentially faster than under 2010. A “wide list” in SharePoint 2010 was one that had so many columns that it would cause an INSERT or UPDATE statement to affect more than 8000 bytes of row data.
To work around the problem, when SP2010 works out the column you’re about to add to a list could cause more than 8000 bytes to be written, it would instead create an additional row to hold the new columns. SharePoint used the [tp_RowOrdinal] column to number each of the rows accordingly for a wide list.
We expect SQL Server to start table locking the AllUserData table as the number of row locks approaches 5000. Wide list behaviour would potentially cause SQL Server to have locky behaviour at one-half as many rows (or one-third, or one-quarter – depending upon how many list columns and therefore SQL rows).
Now it’s all stored in one big column, that particular problem is going to go away.
However, the [tp_RowOrdinal] column still exists in the SharePoint 2013 content database, and I’m not sure why.
SharePoint 2013 Content Databases and Sparse Columns
SQL 2008, 2008R2 and SQL 2012 all support “sparse columns” and “column sets“. These are SQL technologies that allows a row to grow beyond the usual 8K-per-row limit (up to 2GB of data when expressed as Xml). Under the hood, the AllUserData table still has [nvarchar1] through to [nvarchar64] and beyond! In fact there are 262 nvarchars, 1000 bits, 550 datetimes, 550 floats, 750 ints, 262 ntexts, 262 sql_variants, 350 uniqueidentifiers and 2 geographies (in a pear tree). (Thank you to Lior Gal for pointing me in the right direction!)
See the MSDN reference article on SharePoint 2013 AllUserData table design here: http://msdn.microsoft.com/en-us/library/hh625524.aspx.
But why didn’t these show up in SQL Management Studio? This is behaviour by designer to prevent poor performance when selecting form wide tables.
AllUserData Performance Issues in SharePoint 2013
Three general observations:
- For list sizes below 5000 SQL rows, lists that don’t use SharePoint indexed columns will probably be slower.
- For lists greater than 5000 SQL rows, unless we’re using SharePoint column indices in our query, SharePoint list throttling should kick in, and terminate the query before it gets started.
- For most list use cases, it is still massively important to use SharePoint column indices. But if you do decide to switch off throttling for a list, performance should be faster than under SharePoint 2007.
So, in summary: even in SharePoint 2013, make sure you have suitable indexed columns.
5 FAQs about SharePoint in the Cloud Environment – HostForLIFE.eu
Dec 26th
Whether you call it hosted SharePoint or SharePoint in the cloud, you need to be aware of this growing trend in the SharePoint arena. HostForLIFE.eu, as the premier European ASP.NET and Windows SharePoint Hosting provider, has offered SharePoint Service on a Cloud Server.
HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Our service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and many top European countries. Click here for more information
Here are some FAQs to get you started.
1. What is the cloud?
“The cloud” is a trendy catch phrase that means different things to different people. Wikipedia’s basic definition is useful: “Cloud computing is Internet-based computing, whereby shared resources, software, and information are provided to computers and other devices on demand, like the electricity grid.” DevPro Connections magazine author Tim Huckaby further demystifies the cloud: “It’s an economic model in its infancy.”
2. What is the payment model?
One model involves paying for what you used (i.e., a utility). Another model involves paying for what you say you’ll use (i.e., a subscription).
3. How is Microsoft involved in hosted SharePoint?
Business Productivity Online Services (BPOS) is a suite of Microsoft products delivered as a subscription service. Within that suite is SharePoint Online. You can get it as a dedicated solution, where you’re the sole party using the service, or you can get it as a multi-tenant solution, where you share the SharePoint service with many other companies.
4. Who is looking at a hosted strategy?
EMC analyst Matthew Roberts says small and medium-sized businesses: “They just don’t have the budget to deploy and manage SharePoint because they might need a developer skill set, an admin skill set—plus there are issues of upkeep, archiving, replication.” Although large companies are exploring the space, he says, many are choosing a hybrid approach, “putting commodity teams to SharePoint Online, but the apps and data associated with them are on-premises.”
BPOS in particular has proven attractive to large organizations, according to Rob Koplowitz, principal analyst in content and collaboration with Forrester Research. He cites large, multi-national pharmaceutical companies that have been early adopters.
5. What are the pros and cons of hosted SharePoint?
For every concern voiced about hosted SharePoint, such as security, someone else can offer a counter argument, from cost savings to easier management to business continuity in the face of outages or disasters. Ultimately it depends, as most decisions in IT do, on the needs and particular situation of an organization. As food for thought, here are what some industry experts told us:
Pros: “I actually like it because it forces you to build very clean applications by the rules,” says Dave Chennault, an MCTS in SharePoint and BPA. (See his article in the November issue of SharePointPro Connections magazine, coming out the last week in October, “POV: IT Pro,” about hosted SharePoint considerations.) BPOS “is supportable by anyone who knows SharePoint and frees you from custom code and being shackled to the developer who wrote the custom code.”
“A lot of organizations are still fairly early in deployment of SharePoint so you can start with that dynamic of ‘can someone else do this for me?’ In that regard, it might be more simple to move to the cloud,” says Rob Koplowitz.
Cons: “There are a few reasons why you might not want to use a ‘cloud’—some technical (like BPOS does not allow you to easily add third-party applications to your SharePoint environment) but most around governance, security, and compliance,” says Kevin Laahs, a strategist with HP. “You are basically handing over your service to someone else—are you sure they will take as good care of your service as you would yourself?”
About HostForLIFE.eu
HostForLIFE.eu was established to cater to an under-served market in the hosting industry; web hosting for customers who want excellent service. This is why HostForLIFE continues to prosper throughout the web hosting industry’s maturation process.
HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Our service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and many top European countries.
As a leading small to mid-sized business web hosting provider, we strive to offer the most technologically advanced hosting solutions available to our customers across the world. Security, reliability, and performance are at the core of our hosting operations to ensure each site and/or application hosted on our servers is highly secured and performs at optimum level. Unlike other web hosting companies, we do not overload our servers.
We believe in our customers — customers are at the core of what we do! And as such, all of our R&D efforts are done with voice of the customer in mind; our support team is courteous and friendly and will do whatever it takes to assist and resolve your support tickets
