check table usage of Dynamics CRM in SQL Server

1. OPEN Query analyzer of SQL Server
2. OPEN MS CRM database

Run the query like this

exec sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?’”

It will show you all table statistics with index size, row size etc ……

This entry was posted in MS Dynamic CRM 2011. Bookmark the permalink.

11 Responses to check table usage of Dynamics CRM in SQL Server

  1. What would we all do devoid of the marvellous concepts you share on this site? Who has the endurance to deal with important topics in the interests of common subscribers like me? My spouse and i and my girlfriends are very blessed to have your website among the types we usually visit. Hopefully you know how significantly we appreciate your efforts! Best wishes from us all.

  2. What would we all do minus the excellent tips you discuss on this site? Who comes with the endurance to deal with crucial topics just for common visitors like me? My spouse and i and my girlfriends are very delighted to have your blog among the types we frequently visit. Hopefully you know how significantly we appreciate your hard work! Best wishes through us all.

  3. I couldn’t have asked for a more rewarding blog. You are ever present to present excellent advice, going straight to the point for convenient understanding of your target audience. You’re undoubtedly a terrific expert in this matter. Many thanks for being there for folks like me.

  4. We really appreciate your site post. You will find a multitude of approaches we could put it to really good use with a minimum of effort in time and resources. Thank you very much regarding helping have the post answer many concerns we have got before now.

  5. It is really rare to come across an experienced person in whom you will surely have some confidence. In the world today, nobody truly cares about showing others the way out in this matter. How happy I am to have found a real wonderful website as this. It truly is people like you who make a real difference these days through the concepts they discuss.

  6. micro nichos says:

    It was a real pleasure discovering your site this morning. I came here now hoping to learn something new. And I was not upset. Your ideas with new methods on this topic were enlightening and an excellent help to me and my spouse. Thank you for creating time to write out these things as well as for sharing your mind.

  7. The suggestions you contributed here are incredibly valuable. Rrt had been such a fun surprise to have that awaiting me immediately i woke up today. They are generally to the point and simple to interpret. Thanks for your time for the clever ideas you’ve got shared here.

  8. I couldn’t have really asked for a better blog. You’re always at hand to give excellent guidance, going directly to the point for convenient understanding of your site visitors. You’re really a terrific pro in this subject matter. Thanks a lot for currently being there for folks like me.

  9. Thanks a lot for your time and efforts to have decided to put these things together on this site. Mary and i also very much liked your insight through the articles over certain things. I understand that you have many demands on your own schedule and so the fact that you actually took the maximum amount of time like you did to steer people just like us through this article is actually highly liked.

  10. What would most people do devoid of the brilliant ideas you write about on this blog? Who has got the patience to deal with vital topics just for common subscribers like me? My partner and i and my friends are very happy to have your blog among the kinds we frequently visit. We hope you know how much we appreciate your effort! Best wishes through us all.

  11. I cannot thank you fully for the blogposts on your website. I know you placed a lot of time and effort into all of them and truly hope you know how considerably I appreciate it. I hope I can do the same for another individual at some point.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>