CRM and the SQL Best Practices Analyzer
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:
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:
https://msdn.microsoft.com/en-us/library/ee342165(v=SQL.100).aspx
Greetings,
Yoann Nesme