{"id":3766,"date":"2014-05-08T06:26:00","date_gmt":"2014-05-08T04:26:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/"},"modified":"2014-05-08T06:26:00","modified_gmt":"2014-05-08T04:26:00","slug":"how-improve-sharepoint-performance-with-sql-server-settings","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/","title":{"rendered":"Improving your SharePoint performance using SQL Server settings (part 1)"},"content":{"rendered":"

\"\"<\/p>\n

SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases.
\nIn this article, I will propose a list of best practices in SQL Server settings aimed to reduce SharePoint performance issues.
\nThis article is inspired from the presentation Optimizing SQL Server for Speedy SharePoint by Sahil Malik held at the European SharePoint Conference 2014<\/a> in Barcelona.<\/p>\n

Autogrowth<\/h3>\n

Do not keep the default value which is 1 MB. We can illustrate with a simple example why this is a bad idea.
\nWhen a document of 5 MB is uploaded, it means there are 5 Autogrowth which are activated. In fact, there are 5 allocations of space which must slow your system.
\nMoreover, your uploaded document will be fragmented across your different data files. This configuration will decrease your performance a second time.
\nTo avoid performance issues and reduce fragmented data files, you should set the autogrowth value to a fixed number of megabytes.
\nMy recommendation is 1024 MB for data files and 256 MB for log files. But keep in mind, this is a global recommendation. In fact, the bigger the database, the bigger the growth increment should be.<\/p>\n

SQL Server disk cluster size<\/h3>\n

The default value of SQL Server is 4 KB. But in fact, it is nearly the worst value you can choose for this configuration!
\nGlobally, 64 KB is a safe value. Indeed, the server reads 64 KB at the time and can deliver larger chunks of data to the SQL Server database.<\/p>\n

TempDB Optimization<\/h3>\n

First, the TempDB recovery model should be set to simple. Indeed, this model automatically reclaims log space to keep space requirements small.
\nAlso, you should put your TempDB on the fastest disks you have, because TempDB is heavily used by SharePoint. Do not let SQL Server use this disk for any other needs, except TempDB utilization!
\nFurthermore, the total space of the TempDB data files should be 25% of the total space of your user databases. Not many DBAs realize how a TempDB is used by SharePoint and to what extent a TempDB can grow!<\/p>\n

Index Fragmentation<\/h3>\n

WSS_Content database, for example, is used to store site collection as well as lists and its tables are shared. Therefore, indexes are very important!
\nSo do not forget to manage the fragmentation of your databases.
\nMy recommendation is to perform a Reorganize when your fragmentation is between 10% and 30 % as well as a Rebuild index when your fragmentation is above 30%.
\nTake care about indexes with more than 1\u2019000 pages!<\/p>\n

Statistics<\/h3>\n

Do not enable Auto-Create Statistics on an SQL Server that supports SharePoint Server! Let SharePoint Server configure the required settings alone.
\nAuto-Create Statistics can significantly change the execution plan of a query from one instance of SQL Server to another.<\/p>\n

Therefore, do not enable Auto-Update Statistics and use instead SharePoint Auto-Update capability instead.<\/p>\n

SQL Server Memory Allocation<\/h3>\n

The default values of SQL Server for memory allocation are 0 MB for Minimum server memory and 2147483647 MB for Maximum server memory.
\nThe default value of the Maximum server memory is not optimized at all!
\nYou should set a custom value depending on the total amount of physical memory, the number of processors, and the number of cores.
\nTo calculate your SQL Max Memory, I suggest you to read this article<\/a>.<\/p>\n

Recycle Bin<\/h3>\n

Be aware that items in the recycle Bin may affect the performance.
\nMoreover, after a certain limit of days or after a deletion, these items are moved to a second stage recycle bin that may also affect your performance.
\nAs a result, you have to manage your recycle bin\u00a0depending on your needs to ensure that the size of your recycle bin will not continue to grow out of control.<\/p>\n

MAXDOP<\/h3>\n

The default value of your MAXDOP is 0. But for better performance, you should make sure that a single SQL Server process serves each request.
\nTherefore, you must set MAXDOP to 1.<\/p>\n

Fill Factor<\/h3>\n

The default value is 0, which is equal to 100. It means that you do not provide space for index expansion.
\nBut when a new row is added to a full index page, the Database Engine make a reorganization called Page Split.
\nPage Split can take time to perform, and can cause fragmentation increasing I\/O operations.
\nI recommend to set a Fill Factor value of 80. It means that 20 % of each-level page will be left empty.
\nTherefore, you can support growth and reduce fragmentation.<\/p>\n

Instant File initialization<\/h3>\n

This feature, when enabled, allows SQL Server to initialize database files instantly, without physically zeroing out each and every 8K page in the file.
\nTherefore, depending on the size of files you have, you can save a lots of time.<\/p>\n

Conclusion<\/h3>\n

The default settings of the content database in SQL Server are pretty bad and far from what we really need. You should always opt for a pre-allocate size strategy and not rely on autogrowth.
\nMonitoring your databases for space and growth to avoid bad surprises is very important.
\nAlso, do not forget to modify your model database for size allocation rules.
\nAns if you do not want to suffer from bad performances, do not use the Auto-Shrink capability.<\/p>\n","protected":false},"excerpt":{"rendered":"

SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases. In this article, I will propose a list of best practices in SQL Server settings aimed to reduce SharePoint performance issues. This article is inspired from the presentation Optimizing SQL Server for […]<\/p>\n","protected":false},"author":14,"featured_media":3762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[461,462,49,212,51],"type_dbi":[],"class_list":["post-3766","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-best-practices","tag-european-sharepoint-conference","tag-microsoft","tag-sharepoint","tag-sql-server"],"acf":[],"yoast_head":"\nImproving your SharePoint performance using SQL Server settings (part 1) - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.\" \/>\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.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improving your SharePoint performance using SQL Server settings (part 1)\" \/>\n<meta property=\"og:description\" content=\"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-08T04:26:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"260\" \/>\n\t<meta property=\"og:image:height\" content=\"260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Improving your SharePoint performance using SQL Server settings (part 1)\",\"datePublished\":\"2014-05-08T04:26:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/\"},\"wordCount\":860,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_EUSP.jpg\",\"keywords\":[\"Best Practices\",\"European SharePoint Conference\",\"Microsoft\",\"SharePoint\",\"SQL Server\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/\",\"name\":\"Improving your SharePoint performance using SQL Server settings (part 1) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_EUSP.jpg\",\"datePublished\":\"2014-05-08T04:26:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_EUSP.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_EUSP.jpg\",\"width\":260,\"height\":260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-improve-sharepoint-performance-with-sql-server-settings\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Improving your SharePoint performance using SQL Server settings (part 1)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \\\/ Banking, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/nathan-courtine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Improving your SharePoint performance using SQL Server settings (part 1) - dbi Blog","description":"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.","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.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/","og_locale":"en_US","og_type":"article","og_title":"Improving your SharePoint performance using SQL Server settings (part 1)","og_description":"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.","og_url":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/","og_site_name":"dbi Blog","article_published_time":"2014-05-08T04:26:00+00:00","og_image":[{"width":260,"height":260,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg","type":"image\/jpeg"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Improving your SharePoint performance using SQL Server settings (part 1)","datePublished":"2014-05-08T04:26:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/"},"wordCount":860,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg","keywords":["Best Practices","European SharePoint Conference","Microsoft","SharePoint","SQL Server"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/","url":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/","name":"Improving your SharePoint performance using SQL Server settings (part 1) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg","datePublished":"2014-05-08T04:26:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"How to improve your SharePoint performance using SQL Server settings. This is a list of best practices. Inspired by a presentation held by Sahil Malik at the European SharePoint Conference 2014.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_EUSP.jpg","width":260,"height":260},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-improve-sharepoint-performance-with-sql-server-settings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Improving your SharePoint performance using SQL Server settings (part 1)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3766"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3766\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3762"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3766"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}