{"id":554,"date":"2011-07-06T04:26:00","date_gmt":"2011-07-06T04:26:00","guid":{"rendered":"\/blogs\/paul\/post\/Survey-results-on-rebooting.aspx"},"modified":"2017-04-13T11:41:18","modified_gmt":"2017-04-13T18:41:18","slug":"survey-results-on-rebooting-is-it-good-or-bad","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/","title":{"rendered":"Survey results on rebooting &#8211; is it good or bad?"},"content":{"rendered":"<p>\n<font face=\"verdana,geneva\" size=\"2\">About a month ago I kicked off a survey around regularly rebooting SQL Server (see <\/font><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-do-you-regularly-reboot-sql-server\/\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">here<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">). There is much debate about rebooting SQL Server (or Windows Server hosting SQL Server), regularly or even at all so I&#39;ve been looking forward to the results.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">My view is that there are circumstances where rebooting, even regularly, is acceptable &#8211; but you have to have a good reason to do it because of the downsides of restarting the SQL Server process. These downsides include:<\/font>\n<\/p>\n<ul>\n<li><font face=\"verdana,geneva\" size=\"2\">The buffer pool goes completely cold. Warming up again requires reading (potentially a lot of) data back into memory, after allocating that memory from Windows.<\/font><\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">All query plans are lost and will need to be compiled again.<\/font><\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">All information about the state of SQL Server, used to give DMV output, is lost.<\/font><\/li>\n<\/ul>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">In other words, the steady-state for the production workload is lost and has to be attained again.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">As you&#39;ll see from the results, the most common reason for a regular reboot is part of the Windows\/SQL patching process, but there are plenty of reasons cited that are NOT valid in my opinion, and some others that are.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">&nbsp;<img decoding=\"async\" src=\"\/blogs\/paul\/wp-content\/uploads\/2011\/7\/reboot1.jpg\" alt=\"\" \/> <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">The &quot;Other&quot; responses are: <\/font>\n<\/p>\n<ul>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">101 x (paraphrasing) &quot;After windows\/SQL\/firmware updates that require a reboot.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">30 X (paraphrasing) &quot;Quarterly.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">10 x &quot;Only if any problems occur or any maintenance activity scheduled in off hours.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">5 x &quot;Only if I&#39;ve observed some resource contention after some time. Usually a result of not being able to implement the solution and having to work around the problem.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">4 x &quot;Every two months.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;I normally go 360+ days between reboots. And then it&#39;s just for giggles. No indication it is needed or required.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;I would like to do it monthly but my boss doesn&#39;t support it.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;Yes, every two weeks.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;Yes, twice a week.&quot; <\/font>\n\t<\/div>\n<\/li>\n<\/ul>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">&nbsp;<img decoding=\"async\" src=\"\/blogs\/paul\/wp-content\/uploads\/2011\/7\/reboot2.jpg\" alt=\"\" \/> <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">The &quot;Other&quot; responses are (I&#39;ve commented on those in <strong>bold<\/strong>): <\/font>\n<\/p>\n<ul>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">74 x (paraphrasing) &quot;MS security patches &#8211; manually installed after testing them on duplicate system.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">67&nbsp;x (paraphrasing) &quot;As part of the monthly&nbsp;MS patching.&quot; <\/font>\n\t<\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">17 x (paraphrasing) &quot;No regular reboots.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">9 x &quot;We reboot our&nbsp;SQL servers about twice a year average for updates or other issues.&quot;<\/font><\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">6 x &quot;As required for patching activities and only after ensuring that the potential for patching has been reduced by eliminating non-required components and programs.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">4 x &quot;After patch installation or maintenance such as password updates to test cluster failover.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">3 x &quot;Process unkilled and some memory problems.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">2&nbsp;x (paraphrasing)&nbsp;&quot;<strong>Because the business demands it, for no valid reason<\/strong>.&quot;<\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">You need to work out why that process was put in place. My guess is that it&#39;s based on historical requirements to do so on older operating systems, or because of bugs, and it&#39;s just stuck. Very likely the process can be removed if the reboot schedule is very frequent (e.g. daily or weekly).<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>I have issues with a CLR process<\/strong>.&quot; <\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">Then try to fix that process\/code rather than resorting to a reboot.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">1 x &quot;I&#39;ve been told that certain errors won&#39;t be reported by Windows without a reboot.&quot; <\/font><\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;Last rebooted about 50 days ago &#8211; only reboot when necessary (patches).&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>Microsoft Insists<\/strong>.&quot; <\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">I don&#39;t buy this one, unless it&#39;s to work around a specific bug that will be patched at some point.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>Nightly reboots of a specific SQL Server are required by the vendor whose app it supports<\/strong>.&quot;<\/font>\n<ul>\n<li><font face=\"verdana,geneva\" size=\"2\">This is badly messed up and you need to push back on the vendor. My guess here is that they have a leaky application (i.e. memory leaks) and this is their solution.<\/font><\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>Non Windows app memory leaks<\/strong>.&quot;<\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">Again, try to fix the memory leaks rather than resorting to rebooting.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>Our application becomes unstable otherwise<\/strong>.&quot;<\/font>\n<ul>\n<li><font face=\"verdana,geneva\" size=\"2\">Fix the application&#8230;<\/font><\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;Regular test of clusters AND SQL Server performance degrades without restart.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>Save power, turn it off at night<\/strong>.&quot; <\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">This is interesting and one I haven&#39;t considered before. Are you sure the gain in power saving is worth the downsides I mention at the start of the post?<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;SQL Server connection time out error.&quot; <\/font>\n\t<\/div>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>VMware Snapshot<\/strong>.&quot; <\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">This I don&#39;t know about (that&#39;s why I employ Jonathan :-), but I&#39;d be surprised if this process requires the server to be rebooted.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>We do full server backups weekly. we briefly shut SQL, copy c drive where&nbsp;OS and SQL software live &#8211; paging file etc. then bring&nbsp;SQL up and finish server full backup. This takes approx 5 min per week<\/strong>.&quot; <\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">This is messed up. SQL Server and Windows can both be backed up without having to be shut down.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t<font face=\"verdana,geneva\" size=\"2\">1 x &quot;<strong>We have a weekly Maintenance window and it keeps the event logs manageable<\/strong>.&quot;<\/font>\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<font face=\"verdana,geneva\" size=\"2\">This is messed up. Windows and SQL logs can be cycled without rebooting.<\/font>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">Quite interesting results.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">There have been many problems of the years which have required regular reboots to clear, but these are *mostly* gone with the advent of Windows Server 2008\/2008 R2. I think there are three main reasons which still are valid for rebooting regularly:<\/font>\n<\/p>\n<ol>\n<li><font face=\"verdana,geneva\" size=\"2\">As part of Windows\/SQL\/firmware patch installs.<\/font><\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">To test failover procedures.<\/font><\/li>\n<li><font face=\"verdana,geneva\" size=\"2\">To work around a Windows or SQL bug.<\/font><\/li>\n<\/ol>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">As an example of #3, there&#39;s a problem still in Windows Server 2008 with the file cache taking up all the memory, depending on which APIs are used to call it (see <\/font><a href=\"https:\/\/support.microsoft.com\/en-us\/help\/976618\/you-experience-performance-issues-in-applications-and-services-when-the-system-file-cache-consumes-most-of-the-physical-ram\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">KB 976618<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">). And what about the various SQL Server memory leak bugs over the years (e.g. <\/font><a href=\"https:\/\/support.microsoft.com\/en-us\/help\/959007\/fix-error-message-when-you-use-sql-server-service-broker-in-sql-server-2005-failed-virtual-allocate-bytes-fail-virtual-reserve-589824\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">KB 959007<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">).<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">There are plenty of other symptoms that can be &quot;fixed&quot; with a server reboot. A great example of this is plan cache bloat from lots of plans for ad-hoc SQL queries. This can eat away at the memory available for the buffer pool to store data and cause the server performance to grind down (see Kimberly&#39;s post <\/font><a href=\"http:\/\/www.sqlskills.com\/blogs\/kimberly\/plan-cache-adhoc-workloads-and-clearing-the-single-use-plan-cache-bloat\/\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">Plan cache, adhoc workloads and clearing the single-use plan cache bloat<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">). And what about buffer pool memory being wasted by massive index fragmentation, resulting in poor performance (see my post <\/font><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/performance-issues-from-wasted-buffer-pool-memory\/\" target=\"_blank\"><font face=\"verdana,geneva\" size=\"2\">Performance issues from wasted buffer pool memory<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">). Or any of the reasons in bold above that mention and application instability, memory leak, or issue?<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">For these problems, rebooting the server is addressing the symptom of the problem, not the root-cause. We&#39;ve had several clients in the last month where massive performance problems were being &quot;solved&quot; by failing over to the other cluster node, and they turned out to be caused from not having Lock Pages In Memory set (see <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/918483\/how-to-reduce-paging-of-buffer-pool-memory-in-the-64-bit-version-of-sql-server\" target=\"_blank\">KB 918483<\/a>, and take care to note all the Windows bugs it explains that can cause working set trimming too). They were addressing the symptom without researching the cause.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\"><font size=\"2\"><strong>Bottom line<\/strong>: if you&#39;re regularly rebooting Windows\/SQL Server, make sure it&#39;s for a good reason and not just because someone thinks it&#39;s a good thing to do or it&#39;s the chosen way to fix a problem that should be fixed in some other way.<\/font><\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">And don&#39;t immediately assume that someone who does reboot Windows\/SQL Server regularly is an idiot &#8211; they may have a very good reason, or may just be ignorant&#8230; (see <\/font><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/ignorance-is-not-stupidity\/\"><font face=\"verdana,geneva\" size=\"2\">Ignorance is not stupidity<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">).<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">Thoughts?<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>About a month ago I kicked off a survey around regularly rebooting SQL Server (see here). There is much debate about rebooting SQL Server (or Windows Server hosting SQL Server), regularly or even at all so I&#39;ve been looking forward to the results. My view is that there are circumstances where rebooting, even regularly, is [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,91],"tags":[],"class_list":["post-554","post","type-post","status-publish","format-standard","hentry","category-general","category-surveys"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Survey results on rebooting - is it good or bad? - 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\/survey-results-on-rebooting-is-it-good-or-bad\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Survey results on rebooting - is it good or bad? - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"About a month ago I kicked off a survey around regularly rebooting SQL Server (see here). There is much debate about rebooting SQL Server (or Windows Server hosting SQL Server), regularly or even at all so I&#039;ve been looking forward to the results. My view is that there are circumstances where rebooting, even regularly, is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2011-07-06T04:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T18:41:18+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=\"6 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\/survey-results-on-rebooting-is-it-good-or-bad\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/\",\"name\":\"Survey results on rebooting - is it good or bad? - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2011-07-06T04:26:00+00:00\",\"dateModified\":\"2017-04-13T18:41:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Survey results on rebooting &#8211; is it good or bad?\"}]},{\"@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":"Survey results on rebooting - is it good or bad? - 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\/survey-results-on-rebooting-is-it-good-or-bad\/","og_locale":"en_US","og_type":"article","og_title":"Survey results on rebooting - is it good or bad? - Paul S. Randal","og_description":"About a month ago I kicked off a survey around regularly rebooting SQL Server (see here). There is much debate about rebooting SQL Server (or Windows Server hosting SQL Server), regularly or even at all so I&#39;ve been looking forward to the results. My view is that there are circumstances where rebooting, even regularly, is [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/","og_site_name":"Paul S. Randal","article_published_time":"2011-07-06T04:26:00+00:00","article_modified_time":"2017-04-13T18:41:18+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/","name":"Survey results on rebooting - is it good or bad? - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2011-07-06T04:26:00+00:00","dateModified":"2017-04-13T18:41:18+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-results-on-rebooting-is-it-good-or-bad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Survey results on rebooting &#8211; is it good or bad?"}]},{"@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\/554","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=554"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/554\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}