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 SQL DB Size  3

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s