Wednesday, 28 August 2019

Monday, 26 August 2019

Delete entries from RabbitMQ queue

Using GUI

Enable RabbitMQ Management through command

C:\Program Files\RabbitMQ Server\rabbitmq_server-3.7.14\sbin>rabbitmq-plugins enable rabbitmq_management

Log in to http://localhost:15672 with default credentials as guest/guest , scroll down and click on purge.


Using CLI

Download rabbitmqadmin from http://localhost:15672/cli/ and use it

python rabbitmqadmin purge queue name=queue2

Sunday, 25 August 2019

Windows Update throws error

As Administrator, on command line run the following commands

net stop wuauserv

net stop cryptSvc

net stop bits

net stop msiserver

ren C:\Windows\SoftwareDistribution SoftwareDistribution.old

ren C:\Windows\System32\catroot2 catroot2.old

net start wuauserv

net start cryptSvc

net start bits

net start msiserver

 If wuauserv gives message of Cannot restart, stopping - kill its PID and it will auto restart.


Sunday, 18 August 2019

On Windows Server 2016 Datacenter make unresponsive Software Center work

Use the Powershell command Invoke-WmiMethod -Namespace root\CCM -Class SMS_Client -Name SetClientProvisioningMode -ArgumentList $false

This takes out of Provision Mode the System Configuration Configuration Management Client which is used to install organization intranet provided updates through Software Centre.

The Provision Mode is the mode in which previous updates or upgrades were being installed. The client might be stuck in the mode owing to error in updates/upgrades.

Friday, 16 August 2019

On Windows Server 2016 Datacenter, increase password validity

Open gpedit.msc and configure Computer Configuration > Windows Settings > Security Settings > Password Policy > Maximum password age

Monday, 29 July 2019

.Net Core WebAPI(port 5000) vs NodeJS REST API(port 5001) with JWT and summing 80,00,000+ records in Postgres using SuperBenchmarker

C:\Users\acer>sb -u "http://localhost:5001/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:45:34 PM
[Press C to stop the test]
10      (RPS: 1.3)
---------------Finished!----------------
Finished at 29-Jul-19 6:45:42 PM (took 00:00:07.6098379)
Status 200:    10

RPS: 1.2 (requests/second)
Max: 5598ms
Min: 4047ms
Avg: 4820.4ms

  50%   below 5201ms
  60%   below 5204ms
  70%   below 5450ms
  80%   below 5538ms
  90%   below 5598ms
  95%   below 5598ms
  98%   below 5598ms
  99%   below 5598ms
99.9%   below 5598ms

C:\Users\acer>sb -u "http://localhost:5001/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:45:51 PM
[Press C to stop the test]
10      (RPS: 1.8)
---------------Finished!----------------
Finished at 29-Jul-19 6:45:57 PM (took 00:00:05.6254558)
Status 200:    10

RPS: 1.5 (requests/second)
Max: 5548ms
Min: 3636ms
Avg: 4719.2ms

  50%   below 5309ms
  60%   below 5389ms
  70%   below 5418ms
  80%   below 5494ms
  90%   below 5548ms
  95%   below 5548ms
  98%   below 5548ms
  99%   below 5548ms
99.9%   below 5548ms

C:\Users\acer>sb -u "http://localhost:5001/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:46:02 PM
[Press C to stop the test]
10      (RPS: 1.7)
---------------Finished!----------------
Finished at 29-Jul-19 6:46:08 PM (took 00:00:05.9260760)
Status 200:    10

RPS: 1.4 (requests/second)
Max: 5822ms
Min: 3305ms
Avg: 4762.7ms

  50%   below 5531ms
  60%   below 5639ms
  70%   below 5662ms
  80%   below 5715ms
  90%   below 5822ms
  95%   below 5822ms
  98%   below 5822ms
  99%   below 5822ms
99.9%   below 5822ms

C:\Users\acer>sb -u "http://localhost:5000/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:50:24 PM
[Press C to stop the test]
10      (RPS: 1.8)
---------------Finished!----------------
Finished at 29-Jul-19 6:50:30 PM (took 00:00:05.7516721)
Status 200:    10

RPS: 1.5 (requests/second)
Max: 5562ms
Min: 3387ms
Avg: 4550.7ms

  50%   below 4989ms
  60%   below 5248ms
  70%   below 5419ms
  80%   below 5426ms
  90%   below 5562ms
  95%   below 5562ms
  98%   below 5562ms
  99%   below 5562ms
99.9%   below 5562ms

C:\Users\acer>sb -u "http://localhost:5000/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:50:35 PM
[Press C to stop the test]
10      (RPS: 2.4)
---------------Finished!----------------
Finished at 29-Jul-19 6:50:39 PM (took 00:00:04.3411816)
Status 200:    10

RPS: 1.9 (requests/second)
Max: 3952ms
Min: 3270ms
Avg: 3510ms

  50%   below 3424ms
  60%   below 3599ms
  70%   below 3629ms
  80%   below 3921ms
  90%   below 3952ms
  95%   below 3952ms
  98%   below 3952ms
  99%   below 3952ms
99.9%   below 3952ms

C:\Users\acer>sb -u "http://localhost:5000/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:50:44 PM
[Press C to stop the test]
10      (RPS: 2.5)
---------------Finished!----------------
Finished at 29-Jul-19 6:50:48 PM (took 00:00:03.9996376)
Status 200:    10

RPS: 2 (requests/second)
Max: 3874ms
Min: 2666ms
Avg: 3276.2ms

  50%   below 3256ms
  60%   below 3293ms
  70%   below 3304ms
  80%   below 3796ms
  90%   below 3874ms
  95%   below 3874ms
  98%   below 3874ms
  99%   below 3874ms
99.9%   below 3874ms

C:\Users\acer>sb -u "http://localhost:5000/api/owner/" -c 10 -n 10 -t "D:\Work\benchmark\template.txt"
Starting at 29-Jul-19 6:50:51 PM
[Press C to stop the test]
10      (RPS: 2.5)
---------------Finished!----------------
Finished at 29-Jul-19 6:50:55 PM (took 00:00:04.0113735)
Status 200:    10

RPS: 2 (requests/second)
Max: 3530ms
Min: 3035ms
Avg: 3179.6ms