Windows Sever gets hang in "Preparing to configure Windows. Do not turn off your computer" state during the reboot.

Issue:

You may experience that Windows server take long time to reboot after windows update. (approx 1 Hour wait). Ping was working fine, but RDP was not working. If you have acces to the console on the server below text was getting displayed. 
"Preparing to configure Windows. Do not turn off your computer." if you don't have the access to the console you can check Windows module installer service status using Microsoft Management Console(mmc) by remote connecting to same domain server.

  Symptoms: 

 

Sollution:

You can solve the issue by killing the Windows module installer process.If we hardboot server , there was chance of windows OS crash. For this we have to use some third party tool call "System Lizard Remote Process Explore".

• Confirm the service name and path of Windows module installer  from properties of the service.

•  Install System Lizard Remote Process Explore in same domain server which previously had access to hanged server. (you can use server which you use to check the remote service )

• Run "Add computer Wizard" to add your server.
   

• Connect to the hanged server.

•  Kill the TrustedInstaller.exe process.

• Now your server is rebooting. if you can view the console you can view as follows.

Continue reading

Microsoft SQL(MSSQL) use all system memory.

Issue:

MSSQL Server will consume as much memory as you will allow it. By default, that number would encompass 100% of your numerical memory on your machine. That's why you're seeing what you're seeing. For an example if you give MSSQL Server 24 GB of memory, then SQL Server will do its best to use 24 GB of memory. Then you have MSSQL Server and the OS battling for resources, and it'll always result in poor performance.

Symptoms:

Resolution:

You can solve this issue by configuring MSSQL server maximum memory usage. When you set the max server memory configuration limit, you are limiting how much MSSQL Server can allocate for the buffer pool (virtually where it stores data pages and the procedure cache).

Note : check your MSSQL version and its maximum supporting memory before do the configuration.

• First we need to connect to the database so we can modify it. To do this launch MSSQL management studio express and log in to it.

•   Right click over the “top level” of the tree and select properties.

• You will now see the properties section. Select memory , you will see its at 2,147,483,647 MB (Default), restrict it to whatever memory you want it to use.

Continue reading