Monthly Archives: April 2013

Can’t connect to a local server using the Hyper-V Manager

Can’t connect to a local server using the Hyper-V Manager

I was trying to connect to a local (i.e. on the same domain) Hyper-V server for the first time from my laptop, using the Hyper-V Manager (which is included in the RSAT tools), and received the following error regarding permissions:   The solution in this instance was actually very simple, given that i’d installed the Hyper-V server using relatively default settings before joining it to the domain, by default only local and domain administrators have …

Continue reading →

Clearing/Deleting MSSQL Server wait statistics (performance troubleshooting)

Clearing/Deleting MSSQL Server wait statistics (performance troubleshooting)

Troubleshooting SQL Server performance issues is a huge subject, but I often start by analysing the wait (sys.dm_os_wait_stats) and virtual file statistics (sys.dm_io_virtual_file_stats) in parallel. If the performance issues are not blocking, then it is always a good idea to clear the wait statistics and then let server run for a set period (Hour, Day, Week) giving you a good set of data to work with. Wait stats are cleared by running: DBCC SQLPERF(‘sys.dm_os_wait_stats’, CLEAR) However …

Continue reading →

Resizing a VirtualBox VHD or VDI file on Mac OS X

Resizing a VirtualBox VHD or VDI file on Mac OS X

I recently created a Windows 8 VM using VirtualBox on my iMac and misjudged how much space I would need, however not being an experienced VirtualBox user I didn’t realise you wouldn’t be able to increase the VM size from within the GUI. After a quick google session I also found that the advice on resizing VirtualBox VMs was very Windows-centric, so I thought i’d post step-by-step instructions for all you Mac VirtualBox users our …

Continue reading →