I recently had an perfect scenario that required a bit of automation. In short, we needed to complete some weird performance monitoring across an entire Hyper-V cluster that consisted of a large number of nodes. In order to get the data into a platform to analyse and report on the data within a reasonable amount […]
Over the past few weeks I have been involved in a major SQL cluster roll-out and as such got my hands dirty with getting SQL 2008 R2 clusters built. With the release of SQL Server 2012 I decided I might just was well contrast the two builds for the fun of it. As it turns […]
When using any SQL Server 2008 or later version there is a possibility of getting the following error: Element not found. (Exception from HRESULT: 0x80070490) – SQL Server 2008 R2 This appears right after feature selection (with the installer failing – or the installer hangs). There are no specific logs that provide adequate information as […]
This morning when applying SQL Server 2008 R2 SP1 i came across the following error during the installation “Check File In Use” page: The ‘WmiPrvSE.exe’ process is not controlled by the update wizard. You have to manually stop this process to avoid a computer restart. There where two theads being identified by the SQL […]
One of the primary requirements for a proper Microsoft SQL Server environment is MSDTC (Microsoft Distributed Transaction Coordinator). When installing a SQL Server clustered environment it is required to add this clustered resource before installing you SQL Server instances. To procedure to do this: To start the Failover Cluster Management program, click Start, Programs, Administrative Tools, and then click Failover Cluster Management. […]
