{"id":538,"date":"2011-08-22T10:31:00","date_gmt":"2011-08-22T10:31:00","guid":{"rendered":"\/blogs\/paul\/post\/SharePoint-in-a-SQL-Server-environment.aspx"},"modified":"2017-04-13T09:50:49","modified_gmt":"2017-04-13T16:50:49","slug":"sharepoint-in-a-sql-server-environment","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/","title":{"rendered":"SharePoint in a SQL Server environment"},"content":{"rendered":"<p>\n<font face=\"verdana,geneva\" size=\"2\">A few weeks back I kicked off a <\/font><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-do-you-have-sharepoint-in-your-sql-environment\/\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">survey<\/font><\/a><font face=\"verdana,geneva\" size=\"2\"> asking whether you have SharePoint in your SQL Server environment at all. Here are the results: <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">&nbsp;<img decoding=\"async\" src=\"\/blogs\/paul\/wp-content\/uploads\/2011\/8\/moss.jpg\" alt=\"\" \/><\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">The &quot;Other&quot; responses were:<\/font>\n<\/p>\n<ul>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">3 x &quot;Not now but&nbsp;I did in a previous role.&quot;<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">3 x &quot;Yes, but the dbas do not manage their servers.&quot;<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">2 x &quot;SharePoint 2007 and 2010.&quot;<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;My environment no but it&#39;s included in an MES environment.&quot;<\/font>\n\t<\/div>\n<\/li>\n<\/ul>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">Almost 75% of respondents have some form of SharePoint in their environment. Although I don&#39;t think is a statistically valid representation of the installed SQL Server user base, I think it confirms what I&#39;ve been thinking &#8211; there&#39;s a *lot* of SharePoint out there. Remember that this is just a survey of people who read my blog &#8211; primarily SQL Server professionals &#8211; there is a huge amount more SharePoint installations where there is *no* SQL Server professional involved.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">The reason that it&#39;s interesting whether SharePoint is involved in your SQL Server environment is that it can have an impact on your regular maintenance and your HA\/DR strategy. Ordinarily you&#39;d want to treat a SQL Server instance that&#39;s running SharePoint just like any other back-end SQL Server for an application, but SharePoint imposes some restrictions on you.<\/font>\n<\/p>\n<ul>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">It has it&#39;s own maintenance jobs which run regularly, which means you either need to exclude that instance from your standardized maintenance setup, or disable the SharePoint jobs completely and run your own, taking into account the SharePoint guidelines.<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">There&#39;s more than one database required for SharePoint to work properly, which means that database mirroring or log shipping as HA\/DR providers becomes extremely tricky. I usually recommend failover clustering with SAN replication for HA\/DR to avoid complicated failover logic. Backup and restore can become more complicated too &#8211; especially when using an off-database LOB storage layer like RBS.<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">You can&#39;t create additional filegroups in the large content databases and you can&#39;t use partitioning (except for the Web Analytics service), which means taking advantage of filegroup piecemeal restore and partial database availability is not possible.<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">Auto-create statistics needs to be disabled for SharePoint, whereas in most situations you want it enabled &#8211; a departure from your standardized setup.<\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">MAXDOP=1 is strongly recommended &#8211; again a departure from your standardized setup.<\/font>\n\t<\/div>\n<\/li>\n<\/ul>\n<p>\n<font size=\"2\">Some of this guidance is unfortunate, and shows that SharePoint&#39;s use of SQL Server is not as optimal as it could be, but a<\/font><font face=\"verdana,geneva\" size=\"2\">ll of this means that&nbsp;you need to treat a SQL Server instance that underpins SharePoint differently from your other SQL Servers.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">You can read more about SQL Server configuration and maintenance when using SharePoint at:<\/font>\n<\/p>\n<ul>\n<li>\n<div>\n\t<a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/cc298801.aspx\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)<\/font><\/a>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/cc262731.aspx\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">Database maintenance for SharePoint Server 2010<\/font><\/a>\n\t<\/div>\n<\/li>\n<\/ul>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">Enjoy!<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\"><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results: &nbsp; The &quot;Other&quot; responses were: 3 x &quot;Not now but&nbsp;I did in a previous role.&quot; 3 x &quot;Yes, but the dbas do not manage their servers.&quot; 2 x &quot;SharePoint 2007 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,80,91],"tags":[],"class_list":["post-538","post","type-post","status-publish","format-standard","hentry","category-database-maintenance","category-sharepoint","category-surveys"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SharePoint in a SQL Server environment - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SharePoint in a SQL Server environment - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results: &nbsp; The &quot;Other&quot; responses were: 3 x &quot;Not now but&nbsp;I did in a previous role.&quot; 3 x &quot;Yes, but the dbas do not manage their servers.&quot; 2 x &quot;SharePoint 2007 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-22T10:31:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:50:49+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/\",\"name\":\"SharePoint in a SQL Server environment - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2011-08-22T10:31:00+00:00\",\"dateModified\":\"2017-04-13T16:50:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SharePoint in a SQL Server environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SharePoint in a SQL Server environment - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/","og_locale":"en_US","og_type":"article","og_title":"SharePoint in a SQL Server environment - Paul S. Randal","og_description":"A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results: &nbsp; The &quot;Other&quot; responses were: 3 x &quot;Not now but&nbsp;I did in a previous role.&quot; 3 x &quot;Yes, but the dbas do not manage their servers.&quot; 2 x &quot;SharePoint 2007 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/","og_site_name":"Paul S. Randal","article_published_time":"2011-08-22T10:31:00+00:00","article_modified_time":"2017-04-13T16:50:49+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/","name":"SharePoint in a SQL Server environment - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2011-08-22T10:31:00+00:00","dateModified":"2017-04-13T16:50:49+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sharepoint-in-a-sql-server-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"SharePoint in a SQL Server environment"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=538"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/538\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}