Windows Performance

Wiggle it just a little bit– Keeping your computer awake and avoiding timeouts

Posted on Updated on

We have been there so many times: You’re working on one PC, then suddenly, the screen dims on your other PC and you get locked out. Not to mention if you use IM programs it can show you away quite frequently. As an IT admin it’s hard enough trying to get multiple things done without having to log in an out or move the mouse every so often.

What could be the cause? The usual suspects are either due to a Domain policy or because Windows power-saving / screensaver settings kick in.

The up and downside — If you are lucky enough have non-domain client or a relaxed domain policy you could adjust Windows’ power and screen saver settings. The down side is you most likely want those settings if you’re running a laptop to keep battery life at a maximum. There is nothing worse than traveling with a dead battery, except maybe a flight delay. Additionally, if you are on a domain there might be a policy not allowing you to change these settings. If only you could have a monkey in your office to wiggle the mouse every now and then.

Possible Solution? If your domain policies allow then you might try a software solution like: Jiggler

Mouse Jiggler is just a tiny app and as needed will “wiggle” your mouse icon “just a little bit”. Okay, if you haven’t got the reference yet then you need to get up to speed on your early 90’s hip hop.

After the app starts you’ll notice your pointer start to, wiggle and jiggle just a little bit. If this movement keeps Windows active. If the movement isn’t pleasant then enable the Zen Jiggle option, which does the “jiggling” behind the scenes. I prefer to see it “wiggle it just a little bit” as a reminder that it’s active. Finally push the down arrow on the app to minimize the program.

It’s as simple as that, happy computing and if you’ve found other tools to help with this please post up!

Quick ways to check disk alignment with ESXi and Windows VM’s

Posted on Updated on

There are two simple checks a virtual infrastructure (VI) admin should be doing to ensure ESXi Datastores and the Windows VM’s are properly aligned. If either are misaligned then performance issues will follow. Though I’m not going to get into the whys and how’s of alignment issues I will show you how to quickly check.

1 – ESXi Datastores (DS)

By default if the VI admin formats the DS with vCenter Server or directly connected to a host via the VI Client the starting sector will be 2048. A starting sector of 2048 will satisfy nearly all of the storage vendors out there, however 2048 starting sector should be validated with your storage vendor.

If the VI Admin chose to format the DS via a script then they should choose a starting sector of 2048 or what the storage vendor recommends

Example — partedUtil setptbl \$disk gpt “1 2048…..” More info here on partedUtil

Here is a simple command to check your “Start Sector”.   SSH or Direct console into a host that has DSs you want to check and run this command.

~ # esxcli storage core device partition list

esxistartingsector

 

Some note about this –

RED Box – Is the local boot disk, so its starting sector will be 64, this is okay it’s just a ESXi Boot disk

Yellow, Green, and Blue – Are all VSAN Disks and all have a starting sector of 2048   << This is what I’m looking for, I want to make sure all DS disks start at 2048, if not they could experience performance issues.

 

2 – Windows VM Check

Windows checks are pretty easy too, the starting sector offset should be 2048. Note the screenshot below shows the Partition starting offset of 1,048,576, also note it’s in labeled in bytes not sectors. To find the starting sector just divide the Partition Starting Offset by the Bytes per Sector.   Simple math tells us its right — 1048576/512 = 2048 Sector. If your Partition Starting offset is anything other than 1,048,576 Bytes or 2048 Sectors then the VM is not aligned and will need adjusted.

From a Command Prompt, type in ‘msinfo32.exe’ to bring up this screen, navigate as shown below, and note your Partition Starting Offset.

windowsstartingsector

 


Network port diagram for vSphere 5.x – Poster

Posted on Updated on

 

This is by far and away my favorite VMware Poster and I use it as a reference quite often.

Benefits –

  • Clear representation of all the TCP/IP Ports needed by VMware Products and their dependences
  • PDF has a very clear diagram that can be printed on to a large format
  • PDF Diagram has reference numbers that correlate to further slides for more information

You can find the PDF Here >>http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2054806

PIC of the Reference Link –

Part of a PIC of the Port Diagram

VMware Guest Operating System Installation Guide gets an Online Facelift

Posted on Updated on

At some point in your VMware administrator career you discover you need information around the correct settings to deploy a VM properly.

You find that you need to answer questions like –

What is the supported network adapter for my Guest OS?

Are Paravirtualization adapters supported for my Guest OS?

Can I do Hot memory add?

A few years ago the default standard was the Guest Operating System Installation Guide.

It gave you all the information you needed to setup the virtual hardware or confirm what recommend virtual hardware should be by the OS Type.

Recently the compatibility and OS installation guides have come online and they can lead you to best practices around settings and KB’s too.

In this blog post I’m going to step you through how to find basic information around a Windows 2008 server.

Start here – http://partnerweb.vmware.com/GOSIG/home.html#other

This link will take you to the Guest Operating System Installation Guide.

Select your OS – In this case I choose Windows 2008 Server


Here are the base install instructions for the Guest OS, note at the bottom the KB Articles and Guest OS Compatibility Guide.

The Guest OS Compatibility Guide can tell you what network drivers etc are support for the guest OS..


Click here to go to the VMware Compatibility Guide, Select your OS Family, OS Type and choose Update & Review…

Then select your ESX / ESXi version to see the details…


Here are the results…  Also from this page you can choose a different product like ESXi 5.0U1 or other…


Thank you Computer Gods for your divine intervention and BIOS Settings

Posted on Updated on

I’ve been in IT for over 20 years now and in my time I’ve seen some crazy stuff like –

  • Grass growing in a Unisys Green Screen terminal that was sent in for repair by a Lumber yard
  • A Goofy screen saver on a IBM PS/2 running OS/2 kept bringing down Token Ring till we found it

But this friend is one of the more weird issues I’ve come across….

This all started last March 2012. I bought some more RAM and a pair of 2TB Hitachi HD’s for my Workstation 8 PC. I needed to expand my system and Newegg had a great deal on them. I imaged up my existing Windows 7 OS and pushed it down to the new HD. When the system booted I noticed that is was running very slow. I figured this to be an issue with the image process. So I decided to install from Windows 7 from scratch but I ran into various installation issues and slowness problems. I put my old Samsung HD back in my system and it booted fine. When I plugged the new Hitachi HD in the system as a second HD via SATA or USB the problems started again, basically it was decreased performance, programs not loading, and choppy video. I repeated these same steps with the 2nd Hitachi HD that I bought and it had the same issues.

A bit perplexed at this point I figure I have a pair of bad HD’s or bad HD BIOS. Newegg would not take back the HD’s, so I start working with Hitachi. I tried a firmware HD update, I RMA both HD’s and I still have the same issue. Hitachi sends me different model but slower HD and it works fine. So now I know there is something up with this model of HD.

I start working with Gigabyte – Same deal as Hitachi BIOS Update, RMA for a new System board Revision (Now I’m at a Rev 1.3) and I still have the same issue. I send an HD to Gigabyte in California and they cannot reproduce the problem. I’ll spare you all the details but trust me I try every combination I can think of. At this point I’m now at this for 5 Months, I still cannot use my new HD, and then I discover the following…

I put in a PCI (Not PCIe) VGA video card into my system and it works…

and then it hit me – “I wonder if this is some weird HDMI Video HD conflict problem”

I asked Gigabyte if disabling onboard HDMI video might help.

They were unsure but I try it anyway and sure enough I found the solution!

It was like the computer gods had finally shone down on me from above – halle-freaking-lujah…..

 

 

 

Here are the overall symptoms….

Windows 7 x64 Enterprise or Professional installer fails to load or complete the installation process

If the installation completes, mouse movements are choppy, the system locks up or will not boot

Attaching the Hitachi HD to a booted system via USB the system will start to exhibit performance issues.

Here is what I found out….

Any Combination of the following products will result in a failure…. Change any one out and it works!

1 x Gigabyte Z68XP-UD3 (Rev 1.0 and 1.3)

1 x Hitachi GST Deskstar 5K3000 HDS5C3020ALA632

1 x PCIe Video Card with HDMI Output (I tried the following card with the same Results – ZOTAC ZT-40604-10L GeForce GT 430 and EVGA – GeForce GT 610)

Here is the solution to making them work together….

BIOS under Advanced BIOS Settings – Change On Board VGA to ‘Enable if No Ext PEG’

This simple setting disabled the on board HDMI Video and resolved the conflicts with the products not working together.

Summary….

I got to meet some really talented engineers at Hitachi and Gigabyte. All were friendly and worked with me to solve my issue. One person Danny from Gigabyte was the most responsive and talented MoBo engineer I’ve meet. Even though in the end I found my own solution, I wouldn’t have made it there without some of their expert guidance!

Never assume Windows 2008 is Aligned out of the box

Posted on Updated on

I hear this topic come up from MANY and I mean MANY VMware folk. When I say VMware folk, I mean just about every person who interfaces with the product – Yes it’s that many

I believe it is a common misconception that Windows 2008 is aligned out of the box.

*The crowd goes silent as a distance ‘Ahh..’ and ‘No’ silently streams through the audience*

I also believe that Windows 2008 has a better chance of being aligned out of the box then most – But Don’t Trust it.

Still don’t believe me? Then read this from the horse’s mouth…

http://msdn.microsoft.com/en-us/library/dd758814(v=sql.100).aspx  << Look for the topic “Partition Alignment in Windows Operating Systems”

From the above Microsoft link about alignment –

Partition Alignment in Windows Operating Systems

The way partition alignment works depends on the version of Windows being used and the version in which the partition alignment was created. The following sections describe how partition alignment works in Windows Server 2008, the Windows Vista® operating system, and Windows Server 2003 and earlier.

Windows Server 2008 and Windows Vista: New Partitions

In Windows Vista as well as Windows Server 2008, partition alignment is usually performed by default. The default for disks larger than 4 GB is 1 MB; the setting is configurable and is found in the registry at the following location:

HKLM\SYSTEM\CurrentControlSet\Services\VDS\Alignment

However, if OEM setups are delivered (for example, with recovery partitions), even fresh installations of Windows Server 2008 having partitions with undesirable partition starting offsets have been observed.

Whatever the operating system, confirm that new partitions are properly aligned.

I’m guessing at this point you still have doubt… But wait here’s more proof… I’ve seen misalignment in production environments… *No Way – Yes Way*

https://vmexplorer.com/2011/03/11/vm-check-alignment-tool/

Do you believe now?

If so maybe the best approach to this topic is to start stating “Windows 2008 is a better aligned OS but it needs to be checked just like ever Windows OS out there.”

Windows 2003 – Page Faults (Soft and Hard)

Posted on Updated on

Here is one way you can determine if your server is doing soft or hard Page faults.

Hard vs. Soft

Hard Page faults indicate the server is going to the Hard Disk to retrieve needed data and place it in RAM.

Soft Page faults indicate it is going to RAM or Cache to get the data it needs. This is a normal for most programs

Performance Monitor

Setup Windows performance monitor with the following…

SOFT Page Faults = Cache Faults/sec & Page Faults/sec

Hard Page Faults = Page Reads/sec & Avg. Disk Sec/Read

As you can see from this screen shot this server isn’t doing any hard page faults.

If you notice consistent hard page faults, this could be by design, or you need to add RAM to the server or allocate appropriate RAM to the application.  Either way, I’d recommend consulting with the application owner or company who created the application for proper guidance.

Reference…

http://blogs.technet.com/b/askperf/archive/2008/06/10/the-basics-of-page-faults.aspx

SQL Server Performance Issues

Posted on Updated on

This is an on going post that I am updating as it progresses… the issue start in early July of 2010 – Present date…

The Issue..

Recently I was working on a MS SQL 2000 Server and it was having some performance issues. Users were reporting random slowness and disconnects. Three other servers would feed this server SQL based data and a MS SQL 2008 Reporting server would occasionally connect and retrieve data for reporting services. Keep in mind this is non-clustered production server and the business needs to have up 24/7, and rebooting it is close to impossible.  Hence this drove some of our decisions…

What we know about the server…

  1. Server is a HP DL380 G5 server, Single Socket Quad Core Xeon 5160, 4GB RAM (4x 1GB Sticks) , 2 x 36GB SAS 10K Drives (C Drive) , 5 x 146GB SAS 10K Drives (D Drive)
  2. OS is Windows 2003 SP2
  3. SQL Enterprise Edition 2000 SP 4
  4. HP Management Tools are installed
  5. C: Drive is 33GB / 14GB Free  and is ~ 75% Fragmented
  6. D: Drive is 410GB / 172GB Free and is ~100% Fragmented
  7. SQL is taking 1.7GB of RAM as of 07/28/2010
  8. SQL is taking 5 to 20% of the CPU
  9. 980MB of RAM is average Free Space

 

Items we tried… (Keep in mind the order we could attempt analysis was partially based on the business)

  • Basic analysis – No issues found, memory okay, disk okay, etc..
  • Checked Network connections (cable, switch), and Error Logs – Found HP NIC was reporting disconnects since 2008
    •  Reseated and tested cables, okay no issues
    • Updated with MS Updates and rebooted
    • Updated firmware (HP FW 9.00), Software Drivers (PSP 8.40), and Rebooted
    • Noted that PSP8.40 NIC driver was dated update Driver manually to latest
    • After updates users reported no change still slow
  • Found the TCP Off Load Chimney issue (kb/942861)  but we decided to explore other options first
  • Monitored the server via Task Manager / Process Explorer, Nothing definitive found
  • Vendor Ran the SQL Profiler Program to determine issues, Nothing definitive found
  • Vendor believed that Hard Page Faults were the issue based on Task Manager Reports. I used the link below with Performance Monitor & Process Explorer to prove the server was not paging to disk.
  • Noted the SQL Data disk and Boot Disk were fragmented
  • Noted that SQL Maintenance was never run
  • Noted that the /3GB Switch could be implemented & vendor concurred it is being used in other locations without issue
  • Implemented the TCP Off Load Chimney and the /3GB, users reported improvements
  • Contacted HP about the issue with Windows 2003 SP2, NC373i, and the TCP OffLoad issue
    • HP Confirms NIC driver is up today
    • HP would like to run HPS Reports, I ran/emailed them the reports
    • HP Responds, Nothing definitive found in the HPS Reports
    • HP will escalate to their network team for further analysis

Still to do…

  • Database Maintenance & De-fragment hard disks

Summary so far..

It does appear that specific types of NIC controllers are having issues after the Windows 2003 SP2 update with the TCP Offload feature.  Even updated drivers and firmware at this time don’t fix this. In-fact we even had one P2V VM that was having the same issue (I still need to look at this one)

Helpful Links….

Defrag Link –

http://technet.microsoft.com/en-us/library/cc966523.aspx

SysInternals Links –

http://technet.microsoft.com/en-us/sysinternals/bb963887.aspx

Basic of Page Faults –

http://blogs.technet.com/b/askperf/archive/2008/06/10/the-basics-of-page-faults.aspx

The effect of TCP Chimney off load –

http://blogs.technet.com/b/networking/archive/2008/11/14/the-effect-of-tcp-chimney-offload-on-viewing-network-traffic.aspx

Symantec In-depth explanation of TCP Chimney off load – (a great read)

http://seer.entsupport.symantec.com/docs/290098.htm

SQL Profiler

http://msdn.microsoft.com/en-us/library/aa173918(SQL.80).aspx

Memory Management – Demystifying /3GB

http://blogs.technet.com/b/askperf/archive/2007/03/23/memory-management-demystifying-3gb.aspx

Error message when an application connects to SQL Server on a server that is running Windows Server 2003: “General Network error,” “Communication link failure,” or “A transport-level error”

http://support.microsoft.com/kb/942861

An update to turn off default SNP features is available for Windows Server 2003-based and Small Business Server 2003-based computers

http://support.microsoft.com/kb/948496