Problem solve

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.

Hilary Cotter

Follow:

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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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 Management Products and Solutions

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Hilary Cotter

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

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

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

Mitel looking at life as a private entity

The unified comms player has accepted an offer that would see it go into private hands

The difference between profits and revenues

With numbers thrown around making revenue look like the main achievement Billy MacInnes turns his attention to profits

Ambitious Nuvias cuts ribbon on Woking HQ

The distributor has pointed to its move as being evidence of its growth ambitions across EMEA

SearchCloudProvider

Despite GDPR penalties, cloud partners note complacency among clients

Cloud firms work busily to align their businesses with Europe's data protection legislation, but many observe a lack of urgency ...

Hybrid cloud cost optimization an ongoing opportunity for partners

For all its virtues, the hybrid cloud model can create a number of cloud cost optimization and management headaches for customers...

Cloud for healthcare: What is the role of IT channel firms?

Healthcare providers are under greater pressure to pursue digital transformation this year. Learn how partners can aid cloud for ...

SearchSecurity

Akamai touts network perimeter security shifts, zero-trust model

As network perimeter security grows less practical, Akamai talks at RSA Conference about moving beyond firewalls to improve ...

Women in cybersecurity discuss hiring, advice and being mentors

A panel of women cybersecurity professionals at the RSA Conference discussed ways to find the best job candidates, the best ...

Government hacking tactics questioned at OURSA

The ACLU's Jennifer Granick took government hacking to task at the OURSA Conference this week, calling out mass surveillance ...

SearchStorage

Three multi-cloud deployment tactics that work

Use standardization, as well as a centralized management tool and independent monitoring tool, to deploy a multi-cloud ...

Morro Data adds replication, Azure Active Directory support

Startup Morro targets SMB customers with a CloudNAS 3.0 file storage update that adds replication capabilities and support for ...

SSDs vs. HDDs: When is all-flash storage overkill?

The SSD vs. HDD analysis isn't as simple as it looks. SSD prices are falling, and capacities increasing. But HDDs are still a ...

SearchNetworking

Top application delivery controllers offer range of options

The leading ADC vendors offer a broad range of physical and virtual appliances, with varying throughput levels and diverse ...

New Accedian SkyLIGHT PVX has root-cause analytics

Accedian Networks has launched its first product from the Performance Vision acquisition. SkyLIGHT PVX includes network ...

New CDN services give providers an edge in WAN marketplace

With enterprises moving workloads to public cloud, the CDN services market could see growth in security and performance services,...

SearchCloudComputing

Users demand more from containers in cloud

Technology is always advancing, but it needs to march in the direction that users want. Containers are maturing, but plenty of IT...

IaaS and PaaS blurred lines increase lock-in risks

There are three distinct cloud service categories: IaaS, PaaS and SaaS. However, IaaS and PaaS are getting a little too close, ...

Single pane of glass for multi-cloud management still elusive

Unified management for multi-cloud remains a work in progress. Vendors have yet to produce the perfect single-pane-of-glass tool ...

SearchDataManagement

GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

GDPR rules can spur broader steps to protect sensitive data

Companies need to make compliance with GDPR's requirements on managing personal data a priority, but they should also work to ...

Data integrity protection spurs greater security spending

As hacking, ransomware and malware attacks mount, companies place big data protection and integrity among the primary reasons for...

SearchBusinessAnalytics

Cambridge Analytica-Facebook case shows need for ethical data mining

Ethical data collection practices are becoming even more important, as cases like Cambridge Analytica's misuse of Facebook data ...

Rethinking analytics processes spurs enterprise innovation

By taking a fresh look at the makeup of their analytics organizations, enterprises can innovate their business models and take ...

Diversified data sets for analytics deliver top results

Analytics teams should focus on data diversity to ensure that their projects deliver the most meaningful insights -- but they ...

Related Resources

Dig Deeper on Database Management Products and Solutions

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.