SQL Server

SQL Timeouts and Warnings

On CRM servers, in the Event Viewer you might see warnings similar to the following logged against the MSCRMPlatform source with Event ID 17972

"Query execution time of 84.5 seconds exceeded the threshold of 10 seconds: Thread: 91; Database: CRM Database; Server: SQL Server; Query: query/stored procedure"

Unable to validate SQL Server Reporting Services Report Server installation

When trying to install the SSRS Data Connector you may encounter the error:
"Unable to validate SQL Server Reporting Services Report Server installation".
There are many reasons why this might happen but I came across a rather obscure one where a 32-bit SQL Server was installed on a 64-bit Windows server. It seems that this combination is not supported as per this article:

SQL Server Reporting Services and Report Builder Versions

Each version of Report Builder may only be used with the corresponding version of SQL Server Reporting Services as per the table.  

Installing CRM 4.0 on SQL Server 2008

CRM 4.0 can be installed on SQL Server 2008.

Refer to http://support.microsoft.com/kb/957053 for more details and specific workarounds that may be needed.


Supported SQL Server Editions for CRM 4.0

Microsoft Dynamics CRM 4.0 is supported with the following SQL Server Editions:

Reorganizing and Rebuilding Indexes

From time to time it may be prudent to review index fragementation on the CRM database. High levels of fragmentation may impact on performance. Fragmented indexes can be sorted out by reorganizing or rebuilding.

This Microsoft article explains the options http://msdn.microsoft.com/en-us/library/ms189858.aspx.

Subscribe to SQL Server