SQL Server Fragmentation Explained
This technical whitepaper will help you understand SQL Server fragmentation and the performance benefits you can gain on your SQL Servers by continuously monitoring and managing index fragmentation. The following is a summary of the key topics covered in this paper:
•The difference between disk and SQL Server internal and external fragmentation
•How fragmentation affects performance
•The mechanics behind performance robbing data voids
•The pros and cons of various approaches to managing fragmentation
•How SQL defrag manager provides a better, more efficient and easier approach to solving fragmentation problems in SQL Server
•How to judge the improvements gained by defragmenting your server
|
11/18/2009
|
15 Minute Guide to Building Efficient Infrastructures for Microsoft SharePoint Server
Read the guide to learn how to build efficient infrastructures for
Microsoft SharePoint Server environments-whether physical or
virtual-using our deep application experience, strong portfolio of
expert services, industry-leading technologies, and proven solutions
|
11/10/2009
|
The High-Performance DBA
The database administrator’s job continues to grow more challenging as they are called upon to confront new platforms, increasing complexity, more data, and less help. To meet these challenges, the DBA must put a strategy in place across all databases, regardless of platform, that focuses on areas that contribute the most to high availability and performance, including:
• Storage Management
• Performance Management
• Capacity Management
This paper outlines techniques you can use to streamline and automate the management of these critical areas so you can deliver high databases performance and availability.
|
11/4/2009
|
Performance Optimization: Extending the IT Infrastructure
Due to time, money, and resource limitations it is often no longer feasible to rewrite, re-architect, or even replace under-performing applications and databases that are core to running the business. Performance optimization is the key ingredient in the struggle to stretch an invested IT dollar to its absolute limit. This whitepaper show you how to take a three step approach to prevent, find, and fix performance issues that can occur at any stage of the development lifecycle.
|
11/4/2009
|
Virtual Architecture for Microsoft SharePoint Server
People use information to drive business outcomes. These outcomes include developing customer relationships, driving innovation, and improving operations to facilitate collaboration. These objectives need to be archived by developing the most flexible, cost-effective infrastructure possible.
Your organization uses Microsoft Office SharePoint Server 2007 to facilitate collaboration, provide content management features, implement business processes, and supply access to information that is essential to organizational goals and processes. But deploying Microsoft SharePoint is only part of the answer. It can lead to distributed farms with direct-attached storage resulting in increased cost and management complexity as well as underutilized assets. So what is the solution?
|
10/23/2009
|
The 6 Key Points of SharePoint Infrastructure Planning
SharePoint products and technologies have readily found a place within the business environments of many organizations. SharePoint provides an ideal platform for business collaboration and other functions, therefore, it is becoming a critical tool that must be properly architected, maintained, and designed to be easily expanded. A large number of businesses and organizations are considering either deployment of new SharePoint environments or expansion of existing environments and they first need to consider design criteria for the platform.
|
10/23/2009
|
A Comparison of Disk-Based Data Protection Techniques
Balancing the need for availability and performance of the application with the need to capture and store backup copies of the data, many organizations are having to re-evaluate their data protection strategies and invest in new technologies that help reduce the time taken to both backup and recover key applications. At the heart of most data protection systems is the backup, which for years focused on tape as the primary destination for an organization’s data, but now more companies are using disk as the initial (and sometimes final) location on which to store copies of their business-critical information. This short paper takes a look at the factors that companies need to consider when selecting disk based-data protection solutions.
|
10/5/2009
|
Increasing Reliability and Availability in a Virtualized SQL Server Environment
A major component of your virtualized SQL Server environment will likely be availability and recoverability. Consolidation allows you to configure your systems to support these, and also helps to standardize the environment, making recovery more straightforward. By choosing the right physical servers and the right configurations in support of those applications, there are significant benefits to be realized by virtualizing your SQL environment. There are, however, some pitfalls to putting this type of solution in place. This paper will provide you some best practices and key success stories that you can use in designing and implementing your own virtualized SQL environment.
|
9/11/2009
|
