Disable fair sharing in Windows Server

The post below will show how to disable fair sharing of CPU, disk and network in Windows Server 2012/2012R2. The post relies on information found in here and here.
It’s possible to disable it directly in the Windows Registry with the program RegEdit.exe or using PowerShell commands. Both approaches will be shown.
Disclaimer: Do a backup of Windows Registry in RegEdit.exe (File -> Export, remember to choose Export Range = All) before doing these changes!

It’s possible to disable fair sharing of the CPU using Regedit.exe. You have to change the value EnableCPUQuota from 1 to 0 (zero). NB! You change it by double-clicking on EnableCpuQuota. This value can be found in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Quota Systemreg1

It’s possible to disable fair sharing of the disk using Regedit.exe. You have to change the value EnableFairShare from 1 to 0 (zero). This value can be found in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TSFairShare\Disk

reg2

It’s possible to disable fair sharing of the network using Regedit.exe. You have to change the value EnableFairShare from 1 to 0 (zero). This value can be found in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TSFairShare\NetFS

reg3

It is also possible to do this through PowerShell where you write the command below

This will give you a list of the settings for terminalservices as shown below. You are interested in EnableDFSS, EnableDiskFSS and EnableNetworkFSS. For some reason EnableNetworkFSS is not set here.

PSFairShare

To disable CPU fair sharing in PowerShell you write.

To disable disk fair sharing in PowerShell you write.

To disable network fair sharing in PowerShell you write.

Test network connection with ping

With the ping command it is possible to test a network connection

ping <HOST> -t –l 1000

Example ping 8.8.8.8 –t –l 1000 (8.8.8.8 is Googles public DNS-server)

If you run it from a command prompt in windows, it will look as below. The option -t will force the ping command to run until you stop it. It’s possible to stop it by pressing Ctrl-C on the keyboard. The -l option tells ping how many bytes to send with each ping, in this case it’s a 1000 bytes.pingIf you want the result of the test to be sent to a file you can send it to a file using the command below.

ping 8.8.8.8 –t –l 1000 > MyTestFile.txt

When the test is done you can look for Request Timeout in the output.

Quote macrovariables e.g. for an IN SQL-statement

The code below lets you qoute the contant of a macrovariables e.g. to be used in an IN SQL-statement.

The macrovariable InStatement will contain ‘age’,’height’,’weight’. And can then be used in an IN SQL-statement.

Security Token was not recognized by the IssuerNameRegistry

When you try to connect to a provider with a certificate, you can get the message below e.g. in your Windows Event Viewer under Application.

The issuer of the Security Token was not recognized by the IssuerNameRegistry. To accept Security Tokens from this issuer, configure the IssuerNameRegistry to return a valid name for this issuer.

If you are using the thumbprint of the certificate in the web.config everything might seem to be correct. But the problem can be that you copied the thumbprint from the certificate. When you copy the thumbprint from the certificate you get an extra “invisible” stop-character (shown with yellow below) included in the copy and the pasting to the web.config. Don’t copy the thumbprint from the certificate. Just type it in manually.

Certificat

Getting information about your SAS-installation

Below is a couple of commands that can be used to get information about your SAS-installation.

The Setinit-command will give you information about the SAS-products that your SAS-installation is licensed for.

The Product_status-command will give you information about the SAS-products installed on your system.
Keep in mind that there could be a difference between what’s licensed on your system and what’s actually installed.
The commands above will only give you information about the products installed for base-SAS. If you want information about what other SAS-products is installed on you system, then you can get this SAS-program from SAS and run it on your system.

Runas user on other domain

The command below will let you run a program as another user on another domain.

If you want to run SQL Server Management Studio 2014 you would use the command below.