Access your Pro+ Content below.
Four tips on boosting SQL Server scalability
This article is part of the SQL Server Insider issue of March 2011, Vol. 5
Scaling out a SQL Server environment across multiple systems can be a difficult and complicated project, involving partitioned databases, federation and more. So, when it comes to SQL Server scalability, most organizations prefer to scale individual systems up as much as possible before trying to tackle the out option. Here are four tips for making the scale-up process easier and more effective. Maximize SQL Server performance components. Every server’s performance comes down to four basic components: memory, disk storage, network adapters and CPU. Your first step will be to maximize all four of these components in an existing server. Start with memory – it can have the biggest impact and it’s usually the most easily expanded piece of a server. There is just one limitation: On servers running a 32-bit version of Windows, there’s no reason to have more than 4 GB of total RAM installed, because the operating system can’t make use of more than that. On 64-bit machines running 64-bit versions of Windows and SQL Server, install as ...
Access this PRO+ Content for Free!
Features in this issue
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?
Microsoft PowerPivot is designed to give BI capabilities to users who lack IT’s technical know-how. The first step is importing SQL Server data, and you have to know your options.
SQL Server scalability is high on the list of system properties, and scaling up is easier than scaling out. Follow these four tips and you’ll be on your way to optimum performance.