{"id":886,"date":"2024-11-22T08:00:00","date_gmt":"2024-11-22T13:00:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=886"},"modified":"2024-11-21T23:21:41","modified_gmt":"2024-11-22T04:21:41","slug":"optimize-sql-server-workloads-vs-hardware-upgrade","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=886","title":{"rendered":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>When your SQL Server isn&#8217;t performing as expected, it&#8217;s tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it&#8217;s worth taking a step back to see if optimization can address the issues.<\/p>\n<p>Performance problems can stem from various sources. Sometimes, hardware genuinely is the bottleneck. Other times, inefficient queries, missing indexes, or misconfigurations are the real culprits. So how do you figure out which path to take?<\/p>\n<h2>Recognizing the Signs of Performance Issues<\/h2>\n<p>First, let&#8217;s identify some common symptoms that indicate your SQL Server might be struggling:<\/p>\n<ul>\n<li><strong>Slow Application Responses:<\/strong> Users experience lag or freezing when using applications.<\/li>\n<li><strong>Long-Running Queries:<\/strong> Reports or queries take much longer than they used to.<\/li>\n<li><strong>High CPU Usage:<\/strong> The server&#8217;s CPU is consistently running at high levels, sometimes near 100%.<\/li>\n<li><strong>Memory Shortages:<\/strong> Low available memory leading to excessive paging to disk.<\/li>\n<li><strong>Disk Bottlenecks:<\/strong> Slow read and write operations causing delays in data access.<\/li>\n<li><strong>Contention Problems:<\/strong> Increased locking, blocking, or deadlocks affecting users.<\/li>\n<\/ul>\n<p>Understanding these symptoms helps narrow down where the problems might be originating.<\/p>\n<h2>Gathering Essential Data<\/h2>\n<p>Before making any decisions, it&#8217;s crucial to collect data to understand what&#8217;s happening under the hood.<\/p>\n<h3>Using Performance Monitor<\/h3>\n<p>Windows Performance Monitor (PerfMon) is a valuable tool for tracking system performance metrics:<\/p>\n<ul>\n<li><strong>CPU Usage:<\/strong> Monitor <code>% Processor Time<\/code> to see how much processing power is being used.<\/li>\n<li><strong>Available Memory:<\/strong> Check <code>Available MBytes<\/code> to determine how much physical memory is free.<\/li>\n<li><strong>Disk Performance:<\/strong> Look at <code>Avg. Disk sec\/Read<\/code> and <code>Avg. Disk sec\/Write<\/code> for disk latency.<\/li>\n<li><strong>Network Utilization:<\/strong> Ensure the network isn&#8217;t becoming a bottleneck.<\/li>\n<\/ul>\n<h3>Exploring SQL Server Metrics<\/h3>\n<p>SQL Server provides dynamic management views (DMVs) that offer insights into its internal operations:<\/p>\n<ul>\n<li><strong>Query Statistics:<\/strong> <code>sys.dm_exec_query_stats<\/code> helps identify resource-intensive queries.<\/li>\n<li><strong>Wait Statistics:<\/strong> <code>sys.dm_os_wait_stats<\/code> shows what SQL Server threads are waiting on, which can pinpoint bottlenecks.<\/li>\n<li><strong>Index Usage:<\/strong> <code>sys.dm_db_index_usage_stats<\/code> reveals how indexes are being used and if any are missing.<\/li>\n<\/ul>\n<h3>Analyzing Wait Types<\/h3>\n<p>Wait statistics can indicate where SQL Server is experiencing delays:<\/p>\n<ul>\n<li><strong>CPU Waits:<\/strong> Processes are waiting for CPU time.<\/li>\n<li><strong>I\/O Waits:<\/strong> Delays due to disk operations.<\/li>\n<li><strong>Memory Waits:<\/strong> Waiting for memory resources.<\/li>\n<li><strong>Lock Waits:<\/strong> Contention between transactions causing waits.<\/li>\n<\/ul>\n<h2>Interpreting the Data<\/h2>\n<p>With the collected data, you can start to determine whether hardware limitations or workload inefficiencies are causing the performance issues.<\/p>\n<h3>Signs Pointing to Hardware Limitations<\/h3>\n<ul>\n<li><strong>Consistent High CPU Usage:<\/strong> If the CPU is maxed out even during normal operations, hardware might be the issue.<\/li>\n<li><strong>Memory Shortages:<\/strong> Frequent paging due to low memory suggests more RAM could help.<\/li>\n<li><strong>Disk Latency:<\/strong> Slow disk read\/write times despite optimized queries point to storage bottlenecks.<\/li>\n<\/ul>\n<h3>Indicators of Optimization Opportunities<\/h3>\n<ul>\n<li><strong>Inefficient Queries:<\/strong> Resource-heavy queries due to poor design.<\/li>\n<li><strong>Missing or Fragmented Indexes:<\/strong> Causing full table scans and increasing I\/O and CPU usage.<\/li>\n<li><strong>Outdated Statistics:<\/strong> Leading to inefficient execution plans.<\/li>\n<li><strong>Concurrency Issues:<\/strong> Excessive locking or blocking that could be mitigated with optimization.<\/li>\n<\/ul>\n<h2>Deciding on Optimization or Hardware Upgrades<\/h2>\n<p>So, should you focus on optimizing your SQL Server or is it time to upgrade your hardware? Here&#8217;s how to make that decision.<\/p>\n<h3>When Optimization Is the Best First Step<\/h3>\n<p>If your analysis points to inefficiencies in queries, indexing, or configurations, optimization should be your initial focus. Optimizing can:<\/p>\n<ul>\n<li><strong>Improve Performance Quickly:<\/strong> Tweaking queries and indexes can yield immediate results.<\/li>\n<li><strong>Save Costs:<\/strong> Avoid unnecessary spending on hardware.<\/li>\n<li><strong>Enhance Scalability:<\/strong> An optimized system handles growth better.<\/li>\n<\/ul>\n<h4>Steps for Optimization<\/h4>\n<ol>\n<li><strong>Identify Heavy Queries:<\/strong> Use DMVs to find queries consuming the most resources.<\/li>\n<li><strong>Examine Execution Plans:<\/strong> Look for inefficient operations like table scans or missing index warnings.<\/li>\n<li><strong>Optimize Queries:<\/strong> Rewrite queries for efficiency, using set-based operations when possible.<\/li>\n<li><strong>Improve Indexing:<\/strong> Add necessary indexes, remove unused ones, and maintain existing indexes.<\/li>\n<li><strong>Update Statistics:<\/strong> Ensure SQL Server has current data distribution statistics.<\/li>\n<li><strong>Adjust Configuration Settings:<\/strong> Fine-tune settings like <code>max degree of parallelism<\/code> and memory allocations.<\/li>\n<\/ol>\n<h3>When Upgrading Hardware Makes Sense<\/h3>\n<p>If you&#8217;ve optimized as much as possible but still face performance issues, or if your hardware is simply outdated, it might be time to consider an upgrade.<\/p>\n<h4>Hardware Upgrade Considerations<\/h4>\n<ul>\n<li><strong>CPU Enhancements:<\/strong> More cores or faster processors can help handle more transactions and complex queries.<\/li>\n<li><strong>Memory Expansion:<\/strong> Increasing RAM allows for better caching, reducing disk I\/O.<\/li>\n<li><strong>Storage Solutions:<\/strong> Upgrading to solid-state drives (SSDs) can significantly improve disk performance.<\/li>\n<li><strong>Network Improvements:<\/strong> A better network infrastructure benefits systems with heavy data transfers.<\/li>\n<\/ul>\n<h2>A Balanced Approach<\/h2>\n<p>Often, a combination of optimization and hardware upgrades provides the best results. Start with optimization to get the most out of your current setup. If performance issues persist, or if you&#8217;re planning for future growth, then look into hardware enhancements.<\/p>\n<h2>Conclusion<\/h2>\n<p>Determining whether to optimize your SQL Server workloads or invest in hardware upgrades involves careful analysis. By collecting and interpreting performance data, you can make an informed decision that benefits both your organization&#8217;s efficiency and budget.<\/p>\n<p>Remember, optimization should usually be your first step\u2014it can provide significant improvements without the cost of new hardware. However, don&#8217;t hesitate to invest in hardware upgrades when they&#8217;re justified, especially to support future growth.<\/p>\n<p>Regular monitoring and proactive maintenance are key to keeping your SQL Server running smoothly. By staying on top of performance and addressing issues as they arise, you can ensure that your systems continue to meet the demands of your organization.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When your SQL Server isn&#8217;t performing as expected, it&#8217;s tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it&#8217;s worth taking a step back to see if optimization can address the issues.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[104,12,324,5,91,44,73],"tags":[385,360,382,388,384,39,386,383,387,52],"class_list":["post-886","post","type-post","status-publish","format-standard","hentry","category-indexing","category-internals","category-locking","category-performance","category-query-optimization","category-statistics","category-troubleshooting","tag-database-bottlenecks","tag-database-optimization","tag-hardware-upgrades","tag-it-infrastructure","tag-performance-monitoring","tag-performance-tuning","tag-server-performance-analysis","tag-sql-server-dmvs","tag-sql-server-metrics","tag-sql-server-performance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"When your SQL Server isn&#039;t performing as expected, it&#039;s tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it&#039;s worth taking a step back to see if optimization can address the issues.\" \/>\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.sqltabletalk.com\/?p=886\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"When your SQL Server isn&#039;t performing as expected, it&#039;s tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it&#039;s worth taking a step back to see if optimization can address the issues.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=886\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-22T13:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\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.sqltabletalk.com\/?p=886#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=886\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware\",\"datePublished\":\"2024-11-22T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=886\"},\"wordCount\":885,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"Database Bottlenecks\",\"Database Optimization\",\"Hardware Upgrades\",\"IT Infrastructure\",\"Performance Monitoring\",\"performance tuning\",\"Server Performance Analysis\",\"SQL Server DMVs\",\"SQL Server Metrics\",\"SQL Server performance\"],\"articleSection\":[\"Indexing\",\"Internals\",\"Locking\",\"Performance\",\"Query Optimization\",\"Statistics\",\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=886#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=886\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=886\",\"name\":\"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-11-22T13:00:00+00:00\",\"description\":\"When your SQL Server isn't performing as expected, it's tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it's worth taking a step back to see if optimization can address the issues.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=886#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=886\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=886#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk","description":"When your SQL Server isn't performing as expected, it's tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it's worth taking a step back to see if optimization can address the issues.","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.sqltabletalk.com\/?p=886","og_locale":"en_US","og_type":"article","og_title":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk","og_description":"When your SQL Server isn't performing as expected, it's tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it's worth taking a step back to see if optimization can address the issues.","og_url":"https:\/\/www.sqltabletalk.com\/?p=886","og_site_name":"SQL Table Talk","article_published_time":"2024-11-22T13:00:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=886#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=886"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware","datePublished":"2024-11-22T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=886"},"wordCount":885,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["Database Bottlenecks","Database Optimization","Hardware Upgrades","IT Infrastructure","Performance Monitoring","performance tuning","Server Performance Analysis","SQL Server DMVs","SQL Server Metrics","SQL Server performance"],"articleSection":["Indexing","Internals","Locking","Performance","Query Optimization","Statistics","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=886#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=886","url":"https:\/\/www.sqltabletalk.com\/?p=886","name":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-11-22T13:00:00+00:00","description":"When your SQL Server isn't performing as expected, it's tempting to think that upgrading hardware is the quick fix. More CPUs, extra memory, faster disks\u2014they all sound like solutions that should solve the problem. But before you start investing in new equipment, it's worth taking a step back to see if optimization can address the issues.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=886#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=886"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=886#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Determining When to Optimize SQL Server Workloads Versus Upgrading Hardware"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=886"}],"version-history":[{"count":1,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/886\/revisions"}],"predecessor-version":[{"id":889,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/886\/revisions\/889"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}