System Administration

Mscorsvw.exe high CPU usage on Windows Server 2012

No Comments

I sometimes really hate Windows. When you do obligatory updates sometimes it takes hours for operating system to settle down and stop using CPU and memory like crazy.

One of these processes are mscorsvw.exe and ngen.exe which do some .NET assemblies optimization. I read about a lot of angry posts about these processes and that it takes hours “to optimize” and during these hours your server and services on it are suffering (and you need to be clever when finding explanations to your clients).

Follow these steps:

  1. Navigate to the following location in Windows Explorer: C:\Windows\Microsoft.NET\Framework\v4.0.30319
  2. Run an elevated command prompt and change the current directory to the following directory
  3. Type ngen.exe executequeueditems, and press ENTER
  4. Wait until you receive the following message at the command prompt: All compilation targets are up to date.

This annoying processes stopped but now TiWorker.exe is taking his time and eating the CPU and Memory and it looks like it will take 3-4 hours. Yikes! I really hate Windows programmers for this hidden background CPU and Memory eaters.

Continue Reading

System Administration

Can not connect to Remote Desktop Connection in Windows Server 2012R2

No Comments

I faced today strange problem that I could not connect to Windows server through Remote Desktop Connection. When I click “Connect” it disconnect me immediately. Restarting the server didn’t helped.

Here is the simple trick how you can connect…

  1. Open RDC dialog and click on Show Options
  2. Go to Advanced tab  and choose under If server authentication fails option Connect and don’t warn me
    remote-desktop-connection
  3. You are now successfully connected after pressing the Connect button

Glad to hear if this saved you day. You can Tweet this solution so help someone else.

Continue Reading

Leisure and Pleasure

Tuscany in Autumn

No Comments

Ever been in Tuscany? If not, you must go there. Amazing landscapes and old mediaeval towns. At the top of it is always adorable Italian food and wines and climate is super mild during the whole year.

Gladiator movie is also filmed in some of these locations and I created few wide prints for my office from these image I took…

01 02 03 04 04b 07 08 Tuscany001 Tuscany055 Tuscany119 Tuscany124

Continue Reading

Technologies

Duplicate emails in Thunderbird

No Comments

If for some reason you are getting multiple duplicated emails in Thunderbird and can not fix that this is the recipe:

  1. Close Thunderbird
  2. Go to you email directory – you can find the path in your email Account settings
  3. Delete the popstate.dat file
  4. Start Thunderbird and check for new mail
Continue Reading

Databases

MySQL importing from dump file error 1118 – Row size too large

No Comments

Hi,

If you have faced a problem when importing your data to MySQL from a large file and it said:
ERROR 1118 (42000) at line xxx: Row size too large (> 8126)

This is a known bug for MySQL versions 5.6.20.0, 5.6.21.0 and I noticed that I didn’t have this problem at version 5.6.24.

In order to make it work also on MySQL 5.6.21.0 edit your “my.ini” configuration file and increase the innodb log size like this:
innodb_log_file_size = 256M
Hope it solves you the problem, like it helped me, one beer is always welcomed :-).

Best
Alex

Continue Reading

Programming

Entity Framework in .NET and MySQL tinymce(1) problem

No Comments

You know at tinymce(1) field in MySQL database will be converted to boolean type in C#. Sometimes you don’t want this because you just want to read the integer value from MySQL in this field (it can be any from 0-255 if unsigned or -127-127 if signed) – one byte.

In order to do so you need to do two things:

  1. Add TreatTinyAsBoolean=false to your connection string
  2. Edit the database edmx file and in SSDL content section change bool to tinyint, and in CSDL content section change Boolean into SByte.

Be careful if you update edmx file because changes you have made will be lost. This is the bad thing about this, but it is working solution.

Continue Reading

System Administration

How to free space on Disk C

No Comments

There are a lot of system stuff that just eat important space in Windows on disk C (if you have SSD and smaller C partition you don’t want to run out of space).

The best way is to create a junction (symbolic link) and to move some big folder to another partition (you need to have one first).

By doing this Windows will be fooled because you will get the same path but it will be shortcut (pointer) to another real location.

To do this move completely chosen folder to another partition and create symbolic link like this:

mklink /j c:\windows\MyMovedFolder d:\MyMovedStuff\MyMovedFolde

Continue Reading

Leisure and Pleasure

Ever been to Corsica?

No Comments

Summer vacation is coming in a few months. Ever been in Corsica? You should go to see it if you didn’t.

It is a beautiful island with amazing beaches, villages and mountains. Ajaccio, born place of Napoleon, has the best city beach I have seen in my life. Usually you try to avoid them.

The best beach on island is Capo di Feno. Don’t miss to visit Bonifacio.

Here are some photos…

04 07 23 01 02

Continue Reading

Thoughts

Finding the passion

No Comments

You need to be in the centre of these circles.
Ikigai is a Japanese concept meaning “a reason to get up in the morning”, that is, a reason to enjoy life.

ikigai-passion-mission

(Source: found somewhere in Facebook posts)

Continue Reading