You are here: silicon.com > Resources > White Papers > Data Management > Data Infrastructure > Database Management

SQL Server 2000 Performance Tuning - Finding the Right Balance of Indexes - Level 200

Overview In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many patches that yield gains, finding the improvements that give the greatest gain with the least impact on your current systems is a must. In SQL Server there is no other area in the product where you can get better performance gains than with indexes. In this webcast we will look at what indexes are, why they are beneficial, when they can become a burden and how to find the right balance of indexes for performance. This session will demonstrate quite a few recommendations, and a number of concepts - including index maintenance and numerous tips on how to get better performance without being an indexing and internals expert.

Further White Paper Details
Publisher	Microsoft
Live Date	19th June 2004 20:00 BST
Format	Webcast
Topics	Database Management

Did you find this white paper useful? 0 out of 1 users found this white paper useful

Green IT: Reducing your Carbon Footprint with Citrix

Publisher:
Citrix Systems

Protecting virtual macchines: the "best of Vmworld" approach

Publisher:
Citrix Systems

Security Beyond Corporate Boundaries: Using Citrix Application Delivery to Protect Corporate Information Anywhere Business Happens

Publisher:
Citrix Systems

The End of Application Deployment: Virtualised Applications Streamline, Secure and Manage Your Business

Publisher:
Citrix Systems

Accelerating Microsoft Windows Vista Migrations with Citrix XenApp

Publisher:
Citrix Systems

The Bloor Perspective: IBM's big blues, Citrix's ASP success, and boo.com's deepening crisis

In the early days of the dot-com goldrush, it was commonly believed that the retail sector would be one of the greatest gold-bearing areas. Citrix gains from the ASP boom * So what is IBM doing to redress the balance?

Channel:
Comment & Analysis

Shares surge as WorldCom doldrums clear

The index climbed over 105 points, or 2.3 per cent, to 4,646.2 by 07:25 (BST), but fell in later trading to stand 92.70 points up at 4,633.30. The FTSE surged 100 points in early trading this morning on the back of Nasdaq gains.

Channel:
Telecoms

Devil's Advocate: Fortune telling spam

Although there may be further gains, those are likely to evaporate in a subsequent downturn. If it is on the way up, you have probably already missed the best gains. That is, to sell shares you do not own on the assumption that you will be able to...

Channel:
Comment & Analysis

16 Xeons prove sweet for IBM server

Although the benchmark results can be somewhat inflated through careful tuning and the use of unusual storage systems on the part of manufacturers, a good score can't be achieved without a good system.

Channel:
Servers
Tags:
tpc-c,
benchmark,
xeon,
ibm

Shareholders take a swipe at Sun

Sun, whose stock under-performed those of competitors such as Dell and key indexes such as the S&P 500, has been struggling to turn its business around and push its lackluster share price beyond the $3 to $4 range, where it has traded for most of...

Mozilla releases Firefox 3 beta

Those changes "put foundations in place for major performance tuning which have resulted in speed increases in beta 1 and will show further gains in future beta releases". Although Microsoft's Internet Explorer remains the dominant web browser, the...

Live Webcast: Telecoms 2.0 - Where is telecoms heading?

In this webcast, our panel of experts will review where we are with next generation telecoms in the UK, working through the concept of 'Telecoms 2.0': - Realising the potential of Next Generation Networks - why it isn't just about the technology? - What attributes should firms be looking for in their telco partner? - Is the relationship between telco provider and customer changing? - What things need to happen to make next generation services a reality? - You say you want the supplier to change. Do you want to change too? - What is Telecoms 2.0?

Publisher:
ZDNet UK

Telecom 2.0: Mind over matter

ntl:Telewest Business believes that the role of the telco is evolving. Gone are the days when it was enough to simply focus on circuits and minutes, customers now need a far higher degree of interaction and look for suppliers who will talk business solutions with them.

Publisher:
ntl:Telewest Business

IBM Information Server Change Data Capture

In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in.

Publisher:
IBM

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview of server consolidation concepts and techniques and provides guidance on methodologies. It also looks at the potential cost savings associated with server consolidation and offers information on how organizations can sustain the advantage they have gained by consolidating their servers.

Publisher:
IBM

Also on silicon.com

Site Navigation:

SQL Server 2000 Performance Tuning - Finding the Right Balance of Indexes - Level 200

Quick Sitemap Links:

About Us

Search

Blogs

Verticals

Advertising Features

CNET Networks in Europe

CNET Networks in the United States

CNET Networks in Asia Pacific