Browse by Tags

All Tags » Consolidation (RSS)

Transferring aliases from Sql Server Configuration manager between machines

Ever since I have been working with Named Sql Instances using static ports, it has been a pain. Connection strings need to be recoded to include the port syntax: <ServerName>[\InstanceName],<Port> <IP Address>[\InstanceName],<Port>...
Posted by blakmk

Memory Impact of file copy on Windows Server 2008

While figuring out a consolidation strategy for Sql Server, I was concearned that the memory issues ( http://blog.mischel.com/2008/10/14/copying-large-files-on-windows/ ) affecting large file copies would also effect Sql server backups to a cifs location...

Sql Server Consolidation and Configuration Part 1 CPU

So i only seem to get inspired when im totally immersing myself in a project. Having been busy for a while with a few projects requiring me to either consolidate or upgrade servers to 2008 and 2008 R2, I finally decided to put my resistance aside and...

Consolidation, capacity planning and the art of asking questions

I was recently asked to investigate a performance issue with a Sql server that had gradually started to die. Performance was dire and connectivity had become sporadic and services were reguarly stopping and needed to be restarted. The event log was littered...