{"id":8104,"date":"2014-06-26T05:51:26","date_gmt":"2014-06-26T05:51:26","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=8104"},"modified":"2014-06-26T05:51:26","modified_gmt":"2014-06-26T05:51:26","slug":"sage-crm-database-maintenance","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/","title":{"rendered":"Sage CRM Database Maintenance"},"content":{"rendered":"

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance.
\nNew Stuff:<\/strong><\/em><\/span> Confirm if your Sage CRM system has actually expired<\/a>
\nThere are many ways to enhance the performance of Sage CRM application\u2019s Database but listing out few of them as we came across while dealing with our clients.
\n1.Reduce size of Escalation Table :<\/b>
\nIf you are using Escalation functionality over the years then there is more chance to contain large number of data in this table. If you notice carefully, you will see escalations records which have been already triggered from the system. So it\u2019s better to delete these records which are not in use.
\n2.Reduce size of TableScriptsLogs Table :<\/b>
\nAs name suggest this table contains Logs for Table Script which we have configured on any entity. If this logs are not useful, straightway delete such records as it will definitely help you out to reduce size of the table and ultimately to reduce size of the database.
\n3. Database Archival :<\/b>
\nArchival is one of the best options to optimize your database. As we know tables like Company, Person, Cases, Communications contain large number of data.\u00a0 Refer below few steps to perform database archival.
\nA. Create another staging database with the same table structure mentioned in Sage CRM database.
\nB. Write store procedures to migrate data from production database to staging database.
\nC. Check and cross verify data which you have migrated in staging database.
\nD. Delete data from the table of production database.
\nE. If archived data is required in system, new tabs can be added in order to search in archived data whenever required.
\n4.Remove Unused Indexes :<\/b>
\nCustomized Sage CRM database may have lot of unused indexes created on standard entities. Sometimes unusual indexing can also slow down the performance of the database. We can check and remove unused indexes. Usually if no database rocket science is implemented it\u2019s always better to keep the indexes that come out of the box J.
\n5.Remove Unused Tables :<\/b>
\nNow when we use word customization it is possible that your sage CRM database contains tables which are not in use for your current CRM. Deleting such tables will definitely help you to improve database performance.
\n6. Add Necessary Indexes :<\/b>
\nYou need to check and identify most often used tables in your database. You can also go to more detailed level and find most often fired queries. We must design indexes based on what fields are used in where clause and order by clauses. Execution plan in SQL queries also helps in this analysis.
\nAlso Read:<\/strong><\/em><\/span>
\n1) Few points to Enhance Performance of your SageCRM<\/a>
\n2) Steps to be remembered while moving Sage CRM database from one server to another<\/a>
\n3) External database connectivity<\/a>
\n4) Cannot open database requested by the login. The login failed.<\/a>
\n5) How to identify and backup correct Sage CRM Database<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[102,140,230,310,312,332,393],"tags":[921,1559,1883,1890,2010,2296,2405],"class_list":["post-8104","post","type-post","status-publish","format-standard","hentry","category-database-sage-crm","category-escalations","category-maintenance","category-records","category-reduce","category-sage-crm","category-tables","tag-database","tag-maintenance","tag-records","tag-reduce","tag-sage-crm","tag-size","tag-tables"],"yoast_head":"\nSage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-26T05:51:26+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\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.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/\",\"name\":\"Sage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2014-06-26T05:51:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage CRM Database Maintenance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/","og_locale":"en_US","og_type":"article","og_title":"Sage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-06-26T05:51:26+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/","name":"Sage CRM Database Maintenance - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2014-06-26T05:51:26+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/26\/sage-crm-database-maintenance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Sage CRM Database Maintenance"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=8104"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8104\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=8104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=8104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=8104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}