• Adam Thurgar

Datacentre architecture - SSIS, SSAS & SSRS


I worked on a project for a very large financial organisation that effectively was building a private cloud SQL Server infrastructure. The end design was that you could got to a service portal and request a SQL Server, with options for a few different versions, licensing was not an issue due to their licensing agreement with Microsoft. You could choose small, medium, large or custom and then the environment where it would be built (dev ,test, QA or production etc). But then we had to make other architectural decisions about what to do with the other SQL Server components such as SSIS, SSAS and SSRS. The project owner made the decision that the database engine would be separate from any other components. This was a way of ensuring that something like SSIS didn't compete with the database engine for resources. We then needed separate builds for each component. The decision was then made that each component would have its own VM. This significantly increased the VM farm, but did make for easier deployment (and patching) and was more flexible than having multiple components on the one server. A very scaled out architecture that kept everything in different silos.


2 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t