CRM and the SQL Best Practices Analyzer

Source – http://blogs.msdn.com/b/emeadcrmsupport/archive/2010/07/02/crm-and-the-sql-best-practices-analyzer.aspx

One of the most important components Microsoft Dynamics CRM relies on is Microsoft SQL Server.

Issues or slowdowns on SQL Server directly affect the behavior of Dynamics CRM, so it is important to keep the SQL Server healthy.

  • Have you ensured that you are following Microsoft’s best practices?
  • Is your database configured for an optimal performance?
  • Is your SQL Server experiencing issues you are not aware of?

For SQL Server 2005, Microsoft’s SQL Server Best Practices Analyzer automatically validates all of this and much more.

The outcome is a detailed report with a list of all the issues, warnings and best practices recommendations.

For each of these items, there is a link to a detailed resolution.

This easy to install and use tool can be downloaded here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

For SQL Server 2008, since it now uses Policy-based Management, there is no ready-to-use tool that you can download and run.

But, it is easy enough to implement it with SQL Server Management Studio and well documented in the following tutorial:

http://msdn.microsoft.com/en-us/library/ee342165(v=SQL.100).aspx

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

%d bloggers like this: