There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or ...

Capacity planning, especially when done for SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL ...

How much server memory is enough, and for how long? Brien works through the math as part of his ongoing hardware refresh. I have been giving a lot of thought recently to the subject of system capacity ...

i have a project that differs from previous architectures sufficiently that i'm hoping input from this board might be useful.<BR><BR>i know how to generate capacity planning equations for web servers ...

Microsoft wants SQL Server to scale new heights, and it is hoping an add-on code-named Kilimanjaro will help. Due out in the first half of 2010, Kilimanjaro improves SQL Server 2008 with a series of ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...