How To Throttle How Many Message Are Pulled From MSMQ



TODO:

You have an MSMQ that is wired to a WCF service.  You want to throttle how many messages are processed, so that you can better control the system resources.  To do so, you need to change the config file for your WCF...and add the following entries.

 

SOLUTION:

<behaviors>
 <serviceBehaviors>
  <behavior name="DefaultThrottlingBehavior">
   <serviceThrottling maxConcurrentCalls="jQuery15207601982052437961_1377884886132?"
          maxConcurrentSessions="???"
          maxConcurrentInstances="???" />
  </behavior>
 </serviceBehaviors>
</behaviors>

 

NOTES:

Replace the ??? with the values you want.  It may take some trial and error to see what settings work best.

How To Throttle How Many Message Are Pulled From MSMQ



TODO:

You have an MSMQ that is wired to a WCF service.  You want to throttle how many messages are processed, so that you can better control the system resources.  To do so, you need to change the config file for your WCF...and add the following entries.

 

SOLUTION:

<behaviors>
 <serviceBehaviors>
  <behavior name="DefaultThrottlingBehavior">
   <serviceThrottling maxConcurrentCalls="xxx"
          maxConcurrentSessions="xxx"
          maxConcurrentInstances="xxx" />
  </behavior>
 </serviceBehaviors>
</behaviors>

 

NOTES:

Replace the xxx with the values you want.  It may take some trial and error to see what settings work best.

How To Throttle How Many Message Are Pulled From MSMQ



TODO:

You have an MSMQ that is wired to a WCF service.  You want to throttle how many messages are processed, so that you can better control the system resources.  To do so, you need to change the config file for your WCF...and add the following entries.

 

SOLUTION:

<behaviors>
 <serviceBehaviors>
  <behavior name="DefaultThrottlingBehavior">
   <serviceThrottling maxConcurrentCalls="jQuery15207601982052437961_1377884886134?"
          maxConcurrentSessions="???"
          maxConcurrentInstances="???" />
  </behavior>
 </serviceBehaviors>
</behaviors>

 

NOTES:

Replace the ??? with the values you want.  It may take some trial and error to see what settings work best.

How To Throttle How Many Message Are Pulled From MSMQ



TODO:

You have an MSMQ that is wired to a WCF service.  You want to throttle how many messages are processed, so that you can better control the system resources.  To do so, you need to change the config file for your WCF...and add the following entries.

 

SOLUTION:

<behaviors>
 <serviceBehaviors>
  <behavior name="DefaultThrottlingBehavior">
   <serviceThrottling maxConcurrentCalls="jQuery15207601982052437961_1377884886133?"
          maxConcurrentSessions="???"
          maxConcurrentInstances="???" />
  </behavior>
 </serviceBehaviors>
</behaviors>

 

NOTES:

Replace the ??? with the values you want.  It may take some trial and error to see what settings work best.

How To Throttle How Many Message Are Pulled From MSMQ



TODO:

You have an MSMQ that is wired to a WCF service.  You want to throttle how many messages are processed, so that you can better control the system resources.  To do so, you need to change the config file for your WCF...and add the following entries.

 

SOLUTION:

<behaviors>
 <serviceBehaviors>
  <behavior name="DefaultThrottlingBehavior">
   <serviceThrottling maxConcurrentCalls="xxx"
          maxConcurrentSessions="xxx"
          maxConcurrentInstances="xxx" />
  </behavior>
 </serviceBehaviors>
</behaviors>

 

NOTES:

Replace the 'xxx' with the values you want.  It may take some trial and error to see what settings work best.

Where Are The SharePoint Server 2013 Client Components SDK Dlls Installed



TODO:

You installed the SharePoint Server 2013 Client Components SDK but do not know where the Dlls are to reference in your project.


SOLUTION:

They are installed at:  C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI

 

NOTES:

There are no notes on this topic.

How To Un-Install A Service From The Command Line In Windows



TODO:

Have you ever installed a service you built, and want to un-install it via command line?

 

SOLUTION:

  • Open a Visual Studio Command Window
  • Navigate to your EXE folder of the service.
  • Execute the following command:
    • C:\Windows\Microsoft.NET\Framework\v4.0.30319\installutil /u .\YourService.exe


NOTES:

This assume .Net version 4

How To Install A Service From The Command Line In Windows



TODO:

Have you ever built a service and wanted to install it?

 

SOLUTION:

  • Open a Visual Studio Command Window
  • Navigate to your EXE folder of the service.
  • Execute the following command:
    • C:\Windows\Microsoft.NET\Framework\v4.0.30319\installutil .\YourService.exe


NOTES:

This assume .Net version 4

How To Create An Index Using T-SQL



TODO:

Have you ever wanted to create an index using T-SQL.  Below is simple syntax to do just that.

 

SOLUTION:

CREATE INDEX idx_SomeTable_SomeId ON SomeTable(Some_Id)

 

NOTES:

There are no notes on this topic.

How To Add A Default Constraint To An Existing Column Using T-SQL



TODO:

Have you ever wanted to update a column to have a default constraint?

 

SOLUTION:

ALTER TABLE MyTable ADD CONSTRAINT DF_MyTable_IsTest DEFAULT 0 FOR IsTest

 

NOTES:

The T-SQL above, will add a default constraint, that will default the column 'IsTest' to 0