Partition Alignment for SQL Server in Windows 2008.

Default Partition offset with Windows Server 2008 is 1024 KB. For systems from which high performance is required, it is essential to experiment with representative workloads and determine the validity of disk partition alignment for your environment. Our SQL Team requested for 64 Bit partition for better I/O performance on the data drives of the SQL servers.

Here is a template for using diskpart.exe to perform partition alignment, assign a drive letter, and format a partition.

Command Line Syntax
Diskpart
list disk
select disk <DiskNumber>
create partition primary align=<Offset_in_KB>
assign letter=<DriveLetter>
format fs=ntfs unit=64K label=”<label>” nowait

Here is an example in which the F: drive is created on disk 3, aligned with an offset of 1,024 KB, and formatted with a file allocation unit (cluster) size of 64 KB.
Command Line Syntax
C:\>diskpart
Microsoft DiskPart version 6.0.6001
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: ASPIRINGGEEK
DISKPART> list disk
Disk ### Status Size Free Dyn GPT
——– ———- ——- ——- — —
Disk 0 Online 186 GB 0 B
Disk 1 Online 100 GB 0 B
Disk 2 Online 120 GB 0 B
Disk 3 Online 150 GB 150 GB
DISKPART> select disk 3
Disk 3 is now the selected disk.
DISKPART> create partition primary align=1024
DiskPart succeeded in creating the specified partition.
DISKPART> assign letter=F
DiskPart successfully assigned the drive letter or mount point.
DISKPART> format fs=ntfs unit=64K label=”MyFastDisk” nowait

 

Thanks,
Winteladmin

Rejoin a computer to domain without restart

We have been in the situation where we find that the Windows Server has its security relationship with the domain failed. In the past we had to remove the computer from the domain and then join it back again to reestablish the relationship.

This involved two reboots (one to leave, one to join). If it was a server that took a while to boot, the process could take so long.

However, I recently came across an article today which mention a PowerShell command to rejoin a computer to the domain without restarting it

Test-ComputerSecureChannel is one of those cool little PowerShell cmdlets that doesn’t get the recognition it deserves. Running the cmdlet by itself checks whether the relationship with the domain controller is still good. If it comes back True then everything is okay. If it comes back False then the relationship needs to be fixed.

Using Test-ComputerSecureChannel with the –credential –Repair options allows you to repair the relationship with the domain without any restarts. You run the command, sign out and then can sign in with your domain credentials. For example, to repair the relationship with the WINDOWSITPRO domain, issue the command:

Test-ComputerSecureChannel –credential domain\Administrator –Repair

When signed on as a local administrator.

Test-ComputerSecureChannel has been around since Windows Server 2008 R2.

VMware VCA Certification Voucher Free!

Recently VMware announced the new certification track – VMware Certified Associate (VCA).

The certification is available for multiple tracks: VCA-Cloud, VCA-WM and VCA-DCV.

This certification fits in below the normal VCP exam.

Highlights of VCA.

1. Doesn’t need an exam center can be taken online from home/office.

2. Requirement is of common internet browser.

3. Has got free eLearning preparation materials.

4. There are currently three VCA certifications available à VCA-Cloud, VCA-WM and VCA-DCV.

5. It’s officially VMware certified!

As an introduction offer VMware is giving you 50% discount on the exam.

However, we now have an offer to make it 100% discount using an additional exam voucher “VCA13GKN” (*Valid for very Limited period).

 

Reference and more information visit: VMware Certified Associate

 

Thanks,

WintelAdmin

IMJPMIG.exe 100% CPU utilization.

Recently, found that that one of the server was continuously running with 100% CPU utilization and imjpmig.exe was one which was impacting the server performance. Imjpmig.exe belongs to the Microsoft Input Method Editor. It is used to simplify the input of Asian characters. Hence, this was not essential for the server and therefore disabled this process from the start up using “MSCONFIG”. Server was back on normal performance.

Thanks,
WintelAdmin.com

 

Creating Floppy Image to use along with Windows Setup and HP ILO.

There are number of occasions were we still have dependency over floppy, I recently had two occasion were I needed floppy image necessary.

1. During troubleshoot of Windows 2000 server, needed creating floppy image to add SCSI drivers using F6 on OS repair.

2. Similarly, needed to updated NIC drivers for a physical machines using the virtual floppy.

There are a lot of commercial programs out there that will create a .img file from other files on your file system, but I had a tough time finding a free floppy image creation package. I was lucky to find and succeed with a tool named BFI (Build Floppy Image). It’s a very easy command line tool that’s free. You would be able to download the file from here -> BFI’s home page.

For example, If you want to create a floppy image as Floppyimg with the files located at c:\Drivers. Syntax would be:

Syntax: bfi -f=[Location to store image with image name] [source file location]
Ex: bfi -f=c:\floppyimg.img c:\Drivers\

You have now successfully created a new floppy disk image!

Thanks,

Winteladmin.

Fixing Remote Desktop (Unnecessary pop-up)

 

Microsoft Remote Desktop is a great tool for connecting to any windows machine on remote. Sometimes, when you are in need of working on many different machines, you get irritated by annoying pop-up like asking username and password before connecting to the server and annoying remote identity pop-up. This needs our manual intervention and sometime delays our task. Hence, found a suitable option to disable these pop-ups. It’s very simple, please follow the below steps:
1. Close all remote desktop connections and exit the remote desktop client.
2. Click Start, click Run, type notepad, and then click OK.
3. On the File menu, click Open.
4. In the Files of type list, click All Files.
5. In the File name box enter Default.rdp (The full path to this file would be similar to the following: C:\Users\<your username>\Documents\Default.rdp)
6. At the bottom of the Default.rdp file, add the following text:
enablecredsspsupport:i:0
authentication level:i:0
7. Save the file and exit notepad.
8. You should no longer be prompted to enter credentials before connecting to remote desktops and confirm that you do indeed intend to connect.

Thanks,
WintelAdmin.com

How to reset blade slot in HP C7000?

What you can do is to SSH into the chassis via the OA address/ip and then, issue the following command to reset the specific blade. Just insert the bay number of the blade that you would need to.

reset server <bay #>

This command is almost equivalent to completely removing the server and reinserting back. When you issue this command, ILO will also get disrupted for few seconds.

Thanks,
WintelAdmin

 

Celebrating 3 Years

It all started back on June, 2010. over the last three years, this has been a wonderful platform to share the knowledge with wonderful people out there. Thanks for all your likes, comments, suggestions and support.

Special thanks to SpeedHost Support Team,  for invaluable support during crisis, maybe six months back when the site got complete crashed.

Thanks,
WintelAdminStepped into 4th.

Physical to VM Conversion working slow using VMware converter.


Recently, I was doing a hot P2V of Windows 2003 server from HP Hardware to a virtual machine. It was bad experience that the data transfer was slow of about 64 KB/s showing 7 days remaining.

Many times, the task was cancelled and re-initiated, however with no success. tried disabling McAfee and backup services.

Later, I found an VMware KB article on disabling the SSL which fixed my issue with the data transfer of about 7-8 MB/s.

Please follow the below steps to disable SSL:-

1 – Locate “converter-worker.xml” on a machine on which the VMware Converter is installed and open in a text editor.
2 – Locate the tag pair<useSsl></useSsl>. It is located inside the<nfc>tag and has a value oftrue.
3 – Change the SSL Key <useSsl> true </useSsl> to false (“<useSsl>false</useSsl>”).
4 – Save and close the file.
5 – Restart “VMware vCenter Converter Standalone Worker” service.

Tips:
“converter-worker.xml” This file is location in the following locations
Windows Vista, Windows 7, Windows 2008 %ALLUSERSPROFILE%\VMware\VMware vCenter Converter Standalone
Windows XP, Windows 2003, Windows 2000 %ALLUSERSPROFILE%\Application Data\VMware\VMware vCenter Converter Standalone

Thanks,

WintelAdmin

Source:  kb.vmware.com/kb/2020517. Thanks to VMware Knowledge Base.

 

How to check SID on windows 2008?

NewSid is officially not supported by Microsoft anymore. There are chances where you get stuck up during cloning, have multiple machines with same SID. How do you find the existing SID? Its simple. This can be achieved using free tool from Sysinternals called PsGetSid.

First you have to download PsGetSid from PsGetSid download page. Then extract it from the archive PsTools on your machine. You should see PsGetSid among the exe files available in the folder.

Execute the command PsGetSid and you should get the output.

Utility download link:
http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx

Thanks,
WintelAdmin