SQL Server capacity planning

In order for SQL Server capacity planning to be affective, resellers must plan the hardware to last the life of the server.

Can you offer best practices for database capacity planning?

Database administrators (DBA) use capacity planning to predict the resources that a SQL Server will need over its lifetime, to provide optimal services for the applications using it.

Best practices include:

Ensuring the hardware is modular to permit hardware upgrades.
Ensuring that the server/hardware can be repurposed should the applications outgrow the existing hardware.
Ensuring that a representative load test is done on the hardware to study its performance characteristics.
Ensuring that the hardware selected will be powerful enough to support and take advantages of new features and requirements of SQL Server and application upgrades.

This was last published in May 2007

Dig Deeper on Database software management

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Hilary Cotter

When should a client use XP SP3 rather than upgrading to Vista or another OS?

Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ... Continue Reading

Why would I recommend Oracle VM to a client instead of Hyper-V or VMware?

Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM. Continue Reading

Why should service providers pay attention to SOA?

SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our IT Channel experts

View all IT Channel questions and answers

MicroscopeUK

Channel delivers solid growth for Lenovo

Firm aiming to build on the momentum of its last fiscal year with the channel playing a key role in delivering the growth

Lenovo joining the DaaS party

Vendor on the brink of rolling out an offering that channel partners can take out the SME customers

Myths around SD-WAN holding back wider adoption

Cogeco Peer 1 finds that customers are putting off deployment because of some concerns that could be addressed by the channel

SearchSecurity

Stellar Cyber launches Starlight 3.1 for AI threat detection

Stellar Cyber, a security analytics vendor, launched Starlight 3.1 as its first unified security analytics platform, using AI and...

IPsec vs. SSL VPN: Comparing speed, security risks and technology

IPsec VPNs and SSL VPNs both encrypt network data, but they do it differently. Learn about the differences and how to determine ...

Why user identity management is a security essential

Who's on your network and accessing your data? IT security teams must be able to answer these questions. A strong identity ...

SearchStorage

5 multi-cloud use cases for better storage

Use cases for multi-cloud storage proliferate as the technology becomes mainstream. Consider the technology for backup, ...

Put your multi-cloud storage knowledge to the test

Do you know what you need to about multi-cloud and storage? Use our quiz to find out about the technology's basics, as well as ...

New Qumulo all-flash and hybrid arrays equipped with NVMe

The Qumulo all-flash P-184T packs 184 TB of NVMe storage in 2U. The vendor also launched the C-168T hybrid and K-168 Active ...

SearchNetworking

CloudGenix SD-WAN platform open for developers

The CloudGenix SD-WAN is open for developers. The vendor has launched a developer program and tool set for integrating ...

What networking analysts are saying about Cisco's future

Has Cisco outgrown networking? One industry insider seems to think so. Plus, other analysts size up Cisco's future around ...

What is edge computing, and how can you get started?

Edge computing is forcing IT teams to rethink legacy architectures. In this guide, explore what edge computing is, its pros and ...

SearchCloudComputing

Oracle layoffs hit Dyn team's sales, marketing staffs

Oracle Dyn cuts sales and marketing jobs as Oracle plans to end some Dyn services in 2020. The layoffs come amid other Oracle ...

Evaluate the Azure serverless tools to ease deployment anxiety

So you want to build a serverless application on Microsoft Azure? Explore the tools and features that support those apps and ...

Debunk 10 common public cloud myths

A range of public cloud misconceptions -- including those related to security and cost -- give enterprise adopters the wrong idea...

SearchDataManagement

Immuta Automated Data Governance Platform comes to AWS

Immuta's Automated Data Governance Platform, providing data visibility, accessibility and protection, is now available as a ...

Building leaner, meaner BI data sources

As business intelligence analysis and reporting platforms become increasingly important in the enterprise, so does the data that ...

A comparison of open source, real-time data streaming platforms

With so many real-time data streaming tools, how do you know which is right for your organization? Experts compare Spark ...

SearchBusinessAnalytics

Power BI update firms up Microsoft analytics market

With its latest update to Power BI, Microsoft showed its commitment to its business intelligence platform and maintained its ...

MicroStrategy product development advances after Voice.com sale

Analytics and BI vendor MicroStrategy sells the Voice.com domain name and moves forward with product R&D in a competitive market ...

Social media analytics applications live and die by the data

This handbook provides insight and advice on how to use analytics to get information on customer sentiment and marketing ...

Dig Deeper on Database software management

Related Q&A from Hilary Cotter

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.