aug 13 anders jeppesen blog Microsoft CRM Microsoft CRM 2011 Scribe scripts T-SQL

Check for missing index on SQL database

To get an indicator on the missing index’s on your SQL you can use the script below. It’s taken from this the MS BlogURL: http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx SELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure, ‘CREATE INDEX [missing_index_’ + CONVERT (varchar, mig.index_group_handle) + ‘_’ + CONVERT (varchar, mid.index_handle) + ‘_’ + LEFT (PARSENAME(mid.statement,…

Read more

aug 13 Ingen kategorier

Microsoft CRM 2011 deadlocks and SQL isolation level

If you have issue with generic errors and deadlocks  in CRM when you try and push data into the system with multithreads and where you have plugins doing heavy calculations you might need to enable snapshot isolation on the SQL server. It’s not documentet in the CRM documents as this is related to the SQL…

Read more

aug 7 Ingen kategorier

Trigger workflow with Scribe and CRM 2011

Triggerworkflow Note: This object is not available in the Adapter for Dynamics CRM 4.x, it is a new feature with the Adapter for Dynamics CRM 2011. You can create workflow processes within Dynamics CRM. Using the triggerworkflow adapter object you can execute both on-demand and child workflow processes from a DTS file. To use this…

Read more

aug 4 Ingen kategorier

Get TOP 100 on T-SQL and DB2

I’ve had a issue sometime ago on how to get TOP 100 from a DB2 database….I needed to push records into the MSMQ so my Scribe integration could pick it up – I didn’t want to flood the MSMQ system by running it without a select limit as I had more than 1.800.000 records and…

Read more

jun 20 blog

Slow BizTalk Server Administration Console

If the response time is high when working in the console it might be because the TCP/IP protocol not is enabled on the SQL server and the BizTalk Console then is using Named Pipes instead. So fixing this is quite simple, just open the Sql Server Configuration Manager and find the “SQL Server Network Configuration”…

Read more

mar 27 blog

MSMQ Powershell

I’ve got this powershell from my colleague Chris Jones it’s an easy way of moving messages between the queues on the server: # Load required dll [Reflection.Assembly]::LoadWithPartialName(“System.Messaging”) #Set Up Queues $qFrom = new-object System.Messaging.MessageQueue “.private$AccountSuccess” $qTo = new-object System.Messaging.MessageQueue  “.private$ScribeIn” $i = 1 # counter do {          $qTo.send( $qFrom.Receive())          $i++ } while ($i…

Read more

jan 30 Ingen kategorier

Want to optimize SSRS report execution

If you set this value in your SQL statement: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED BEGIN TRANSACTION   And this in the end: COMMIT TRANSACTION You should see that your reports run ~30% faster   Forexample: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED BEGIN TRANSACTION SELECT * FROM DUMMYRECORDS COMMIT TRANSACTION        

Read more

jan 27 blog T-SQL

T-SQL Script to Check / repaire a SQL database

Hi, I needed  to repaire a CRM database today and found this script handy: Change the database mode to single user: EXEC sp_dboption ‘DynamicsHML_MSCRM’, ‘single user’, ‘true’ And when done set it back with this: EXEC sp_dboption ‘DynamicsHML_MSCRM’, ‘single user’, ‘false’   Make a check of the database, this will output errors if any: DBCC…

Read more

jan 23 Ingen kategorier

Microsoft CRM 2011 tracert with powershell

For start tracert: Add-PSSnapin Microsoft.Crm.PowerShell $trace = Get-CrmSetting TraceSettings $trace.Enabled = 1 Set-CrmSetting $trace For stop tracert: Add-PSSnapin Microsoft.Crm.PowerShell $trace = Get-CrmSetting TraceSettings $trace.Enabled = 1 Set-CrmSetting $trace Output files will be in the installation folder of crm in the tracert folder.

Read more

jan 23 Microsoft CRM 2011

Microsoft CRM 2011 Maintenance Job Editor

Nice tool to take care of the default maintenance job in CRM http://crmjobeditor.codeplex.com Thanks to http://www.codeplex.com/site/users/view/seanmcne  

Read more