How big is the CRM database?

How big is the CRM database?

As consultants, we often perform an analysis of CRM systems belonging to prospects or customers, perhaps because they have performance issues, they want to upgrade, or we need to understand more about their current implementations.
If the CRM is on-premises, it is useful to find out about which out-of-the-box CRM entities are used, custom entities if any, number of records, and size of tables. You can find out all about this easily through few clicks and without having to write any T-SQL.
  1. Logon to SQL Server Management Studio
  2. Right-click on the CRM database (e.g. sandbox_CRM), then select Reports > Standard Reports > Disk Usage by Table
  3. A report will be loaded in a new tab. This may take a couple of minutes depending on the overall size of the database.
  4. You can interact with the report then by sorting the desired columns, however my recommendation is to export this to Excel and perform further manipulation in Excel. To export, right click on the report, and select Export > Excel
    SQL DB Size 1
    SQL DB Size 2

Comments

Post a Comment

Popular posts from this blog

Asp.net- Encrypt and Decrypt connection strings in web.config file

Image
In this article I will explain how to encrypt or decrypt connectionStrings in web.config file using asp.net. If we are using applications in our internal servers with security then it’s ok if we deploy our applications in shared host environment then we have chance to arise security problems to avoid these problems asp.net 2.0 provided built in protected configuration model functionality to encrypt or decrypt few sections of web.config file those are RSAProtectedConfigurationProvider :   This is default provider and uses the RSA public key encryption algorithm to encrypt and decrypt data. DataProtectionConfgurationProvider : This provider uses windows data protection application programming interface to encrypt and decrypt the data. The encrypting and decrypting of connection strings in web.config file will do by using aspnet_regiis.exe  command line tool and  code behind . First Method : First we will do encryption and decryption using  aspnet_regiis.exe  comman
Read more

CRM Automate build Solution using Powershell commands

In CRM if there is any solution movement from other enviornment like DEV,PROD,STG we use to export the solution and import the solution to the respective environment by logging into MS Dynamics CRM. This will tends to extra effort to do manually for developers or release managers. So what if release user or test user can build and deploy the Solution deployment without CRM intervention(CRM loggin in) We need to do some automate build and deployment. In this article i write about how Import/Export solution automate to the various environment without intervention of logging into MS Dynamics CRM. XRM CI Framework,this is one tool use to automate the build in CRM       Below link is for download the XRM CI Framework https://xrmciframework.codeplex.com/releases/view/125516 Download and extract the ZIP file . First HelloWorld example “WhoAmIRequest” 1.Open "Powershell" and "Run as a Administrator" 2.Navigate to Extrac
Read more

Access the fields on Quick View Form – Dynamics CRM 2015

Image
Quick view forms in Dynamics CRM 2013 allow you to display all the related entity information. Is there a way to retrieve the field value on Quick View Form using JavaScript without additional OData call to the associated entity? The answer is Yes and here is the sample of the form and JavaScript:   Here is the Following steps to get the value from the QuickView form     Sample Quick Form     Eg: We need to get the attribute value called AccountNumber from QuickForm Step 1: Open the Customization->Entity->Form     Step 2:  Double click the customer pane window to see the properties and note the quickformname,and related entity name.Click Edit.       Step 3:   Our goal is to get the attribute name of AccountNumber.   After Click Edit the following dialog box with Field Properties and note down the attribute name Code: below is the format //QuickFormname_QuickFormname_EntityName_AttributeName if(Xrm.Page.getControl('customerpane_q
Read more