Archive for May, 2009

SQL finally supported in VM world!

Tuesday, May 19th, 2009

Well this “SQL Server Support Policy for Failover Clustering and Virtualization gets an update…” has made my day! Microsoft now officially supports running SQL Server in a virtual machine environment. The minor gotcha (which I think is frankly fair) is that is has to run on Windows 2008.

# Guest Failover Clustering is supported for SQL Server 2005 and SQL Server 2008 in a virtual machine for Windows Server 2008 with Hyper-V, Microsoft Hyper-V Server 2008, and SVVP certified configurations provided both of the following requirements are met:

* The Operating System running in the virtual machine (the “Guest Operating System”) is Windows Server 2008 or higher
* The virtualization environment meets the requirements of Windows 2008 Failover Clustering as documented at The Microsoft Support Policy for Windows Server 2008 Failover Clusters.

Guest Failover Clustering is when you create a SQL Server failover cluster inside a virtual machine where the nodes are running as a virtual machine. A non-SVVP configuration that meets these requirements will receive support from Microsoft CSS per the policies documented in

897615 (http://support.microsoft.com/kb/897615/) Support policy for Microsoft software running in non-Microsoft hardware virtualization software

Very cool, the Data Center guys are going to love this one!

Gareth

How to get commandline parameters from running tasks

Monday, May 18th, 2009

I had an interesting issue earlier today. I had an issue where there were a large number of run away / zombie processes that were being spawned under the generic ‘cscript.exe’ process. This was a problem as I didnt actually know what the script was actually running. Obviously I needed to get the command lines being passed into it cscript to determine what and where the culprit actually was. While this is trivial under Windows 2008, its not so obvious/simple under Windows 2003 or XP – and apparently my Google mojo failed me as it took much longer to find than it really should have done!

The simple answer is that tlist.exe is your friend. The only problem is that Microsoft (in its infinite wisdom) has removed all references as to where you can actually get this handy dandy tool. The command line reference can be found at this MSDN site TList commands, but also no download links – that would have been far too easy.

I eventually found this hidden gem in the Microsoft Debugging Tools For Windows site. From here download the “Install Debugging Tools for Windows 32-bit Version” or 64 bit version and that will install a copy of TList onto your machine. Mine was installed into this handy location “C:\Program Files\Debugging Tools for Windows (x86)\” and still there is no reference to the Tlist utility in the start menu.

So if you now have the tool its pretty easy to use:

  • tlist -m *fire* = Lists all processes have have the name fire in them
  • tlist -m cscript.exe -c = Lists all the command lines for all cscript processes

    Update


Since then I’ve found the other ways to do this:

WMIC /OUTPUT:C:\ProcessList.txt PROCESS get Caption,Commandline,Processid

See http://windowsxp.mvps.org/listproc.htm for more details.

And the truly nice thing about this one is that it comes installed by default :-) , granted its not obvious – but it is available.

Hope this helps someone out there,

Gareth

Microsoft TFS team looking for guidance on TFS customization

Monday, May 18th, 2009

If you are a TFS guru and want to get your thoughts into Microsoft now is the time. Kathryn Elliott’s Blog is requesting feedback on what documentation have you (or would you) have found useful.

As for the my take, the best scenario to me would be a set of well defined use case stories that would explore certain requirements. Written as ‘chapters’ that customization specialists can learn from and help implement simple scenarios through to complex integration.

For example a software company scenario that I would think is relatively common is:

Software house wants to migrate from a home grown tracking system to TFS, and expects to get significant value out of the system. What steps are necessary to get the ‘value’ concepts out of the old system and into the new. Care should also be taken to point out that TFS approach is different, but likely better than the older system. People just need to recognize the old way isnt always the right way.

Having a scenario like this in a chapter form would allow the simple “Add a field”, through to changing the workflows to integrating the whole CI process through to software delivery.

I have good hopes if this is approached in a similar way to NerdDinner.

I’m hoping it is going to be good :-) ,

Gareth

Hyper-V and the future of HA scalability

Tuesday, May 12th, 2009

Things definitely seem to be coming thick and fast. Microsoft has added more features to Windows 2008 R2, specifically the ability to support 64 logical processors. This number of processors was considered to only be available in highly specialized platforms 3 years ago, it seems we are now going to a new definition of scalability! As a result this new OS appears to directly attack the concept of Windows not being a viable VM platform. Remember Windows 2008 didn’t actually come out that long ago, but if we have a look at the history of logical processor support for Hyper-V (this was taken from the above link):

* Server 2008 Hyper-V 16 LP Support
* Server 2008 Hyper-V +update (KB95670) 24 LP Support
* Server 2008 R2 Hyper-V Original POR 32 LP Support
* Server 2008 R2 Hyper-V RC/RTM 64 LP Support!

Stunning difference! It definitely seems VMWare has awoken the slumbering giant. This in conjunction with Live Migration – I have to say things are starting to look good as a developer :-) , roll on Windows 2008 RC2!

I have to say I’m really looking forward to this release, I think IT shops will start to push developers into smaller scalable instances of the VMs. Exactly (as it appears) Microsoft is doing with the embedded XP mode within Windows 7.

And don’t forget that R2 is a pure 64 bit OS, so this is really a milestone release – and it could be argued R2 is an understatement!

Gareth