Database Cluster CPU choice.

Hi all,
We are considering hardware upgrade.Can SQL Server 2005 Enterprise and
Standard Edition fully take advantage of the Quad Core architecture ?. Quad
Core Intel Xeon X5355 is top of the range. Dual Core 5160 is another choice
worth considering. At the current prices,which one would be a more cost
effective choice.
Regards,
http://www.intel.com/performance/server/xeon/database.htm
I don't know how well SQL2005 would take advantage of Quad Cores, I have not
had a chance to conduct my tests yet. But I'm curious as to what systems
(servers) and how many sockets you have in mind.
Linchi
"Sezgin" wrote:

> Hi all,
> We are considering hardware upgrade.Can SQL Server 2005 Enterprise and
> Standard Edition fully take advantage of the Quad Core architecture ?. Quad
> Core Intel Xeon X5355 is top of the range. Dual Core 5160 is another choice
> worth considering. At the current prices,which one would be a more cost
> effective choice.
> Regards,
> http://www.intel.com/performance/server/xeon/database.htm
>
>
|||This is a pretty general processor architecture question.
Can SS2K and SS2K5 make use of Intel's Hyper-Threading and either Intel's or
AMD's multi-core technologies? Yes, they can. The OS presents any/all of
these as logical processors to SQL Server. However, both provide NUMA
awareness, and SS2K5 provides NUMA optimization for those process
architectures that provide it. This is critical because only Intel's
Itanium and AMD's x64 processor architectures provide this capability.
Each processor architecture provides its own pros and cons depending on the
workload characteristics. As such, a deep understanding of your systems
workload requirements and each processor's architectural capabilities is
necessary before any recommendation could be made.
The fact is that for single-threaded workloads, a single-socket cpu with a
larger on-die cache and higher clock rate will outperform all other
technologies.
Now, when you start talking about multi-tasking as in desktop/workstation
scenarios or multi-threading applications as in server DBMS or high-end
gaming systems, multi-core/multi-socket presents real multi-tasking and
parallel computing opportunities that are just not possible with sing
processor solutions, no matter how fast.
Whether you use Hyper-Threading technology, multi-core, or a combination of
the two, you can not match the power of SMP multi-socket. Even in the link
that you provided, Intel reports a 50% to 80% improvement of the Quad-Core
over the previous generation Dual-Core products. Wait a minute! It just
doubled the number of cores, but only obtained, at best, an 80% performance
improvement? If you were to double the number of sockets, you would double
the amount of power, and, unfortunately, you would double your cost and
energy consumption as well. This is the advantage multi-core provides over
SMP scalability, not to mention that most software vendors only require you
to license the sockets, not the cores nor the Hyper-Threads.
However, straight SMP architecture also hits a scalability limit: as you add
additional processors to the system (sockets), you increase the amount of
overhead required to manage thread context switches and the associated
memory to cpu loading. Once you get above 8-way solutions, the SMP
controller and cpus start to spend more time moving data on and off the
processors as scheduling requests come in than they do running actual
requested work. Intel's Hyper-Threading Technology was an attempt to
alleviate this congestion. But there are drawbacks associated with its use
as well.
The advantage of Hyper-Threading is that two full thread contexts are loaded
to the CPU at a time. Why it works is based on the probability that the
next scheduled thread will be higher for the last signaled threads than the
others in the queue. In which case, the memory context has already been
loaded to the processor, and as such, reduces the latency inherent in SMP
overhead. However, if that assumption is false, as is the case most often
in OLTP DBMS solutions, the overhead of loading 2 contexts with every
scheduling request can actually double the SMP overhead. For DSS and some
OLAP DBMS solutions, very few context switches, relatively speaking, are
requested anyway; so, again the technology can actually increase the SMP
scheduling overhead.
Now, for multi-core solutions. As was stated above, although their per core
processing power is lower than a comparable multi-socket solution, so is the
electrical power and thermal requirements, in addition to the licensing
costs. The consideration here then is the implementation differences
between Intel's and AMD's solutions. To help explain these, a quick look at
the Itanium's solution and NUMA architecture can prove useful.
Besides the inherent benefits of the Itanium's EPIC instruction set, which
rivals and can exceed the processing capabilities of RISC-based solutions,
engineers had to contend with the SMP scaling problem. Although 8-way and
even 32-way SMP chipset architectures had been constructed, the complexity a
nd expense of these systems detoured their usage. To overcome this, 4-way
systems were deemed optimal and NUMA architectures were constructed by use
of "cell" construction.
The way it works is that each "cell" is a 4-way collection of SMP
processors. Cells are then interlinked through a technology similar to
AMD's Hyper-Transport memory bus solution. A NUMA (Non-Uniform Memory
Architecture) attempts to localize memory allocations and usage to each
cell, which avoids the "bridging" mechanisms used in standard SMP solutions,
and is much more efficient. As cells are interlinked, although memory
across cells and processors can be requested, the latency induced by such
calls reduces to the efficiency of the old SMP architectures. So, if
applications are written to be aware of this architecture, these interlink
calls can be minimized, memory requests and thread scheduling can be
optimized to maintain NUMA cell proximity, thereby scaling the overall
solution beyond the 4-way limitations and actually increase the memory bus
speeds. Unfortunately, for non-NUMA aware applications, this configuration
provides little memory optimization benefit. Although, the raw NUMA
configuration can be provided more cheaply than an equivalent straight SMP
one.
Keep in mind that NUMA is a macro-architecture implementation utilizing
multi-way processor sockets and 4-way per cell interlinks. Interestingly,
HP went a step further with their MX-2 technology utilizing two full CPUs on
a single PCB per-socket, thus scaling each NUMA-node (i.e., cell) to 8-way
SMP. These presented the first "macro-scale" multi-core solutions.
When it came time for real multi-core, AMD architected their solution with
the above understanding of memory transport and NUMA efficiency. From the
point of view of the OS, AMD multi-core processors behave very similarly to
NUMA solutions. On a single socket, incased in a single processor package,
two full cores where introduced, but in addition, a localized, large,
hyper-fast memory buffer. When SMP chipsets were constructed, these
on-socket memory buffers were interlinked, again in a NUMA style fashion,
through high speed interlinks, called Hyper-Transport.
Intel, on the other hand, to catch up and get to market quicker, simply
extended their solutions to multi-core, but introduced no new memory
transport improvements. Even with this new Quad-Core processors, the memory
transport architecture remains the same as the single-core Xeon solutions,
and thus still suffers from some of the SMP scalability limitations.
What does this mean from the point of view of the DBMS? It means that you
can use SQL Server's NUMA-awareness against Intel's Itanium and AMD's
multi-core processors, but not on Intel's dual or quad cores. Moreover, SQL
Server for Itanium has been optimized for the EPIC instruction set in
addition to large-scale NUMA. AMD, however, is more a logical NUMA, still
uses x86 extended x64 instructions, but still blows the doors off of the
Intel Xeon solutions.
However, Intel has also recently released their hyper-threaded, multi-core
Itanium processor (series 9000): the Montecito, which actually doubles the
processing capability over the older Itanium 2 Madison chips. Moreover, the
quad-core Itanium Tukwila processor is expected to launch sometime in 2007.
From these, the full-scale, macro-style, NUMA cell implementations can be
constructed.
Moreover, in early 2008, AMD will be launching a new quad-core processor
built on a newly updated Hyper-Transport 3.0 interconnect protocol.
Hope this helps. I would keep my eye on the TPC-C sites. The Itanium-2
solutions are all in the top performer categories, boasting Millions of
Transactions per Minute (Intel's Xeon quad-core only reached 200 thousand
TPM). But for less expensive, smaller scale requirements, the AMD
multi-cores also reach into the top mark lists. AMD's dual-core reached the
same relative limits it took the Xeon quad-core to reach. Recent
expectations for the AMD Barcelona quad-core 4-way would exceed 500,000 TPM,
almost double the Intel marks.
Sincerely,
Anthony Thomas

"Sezgin" <anonymous@.anonymous.com> wrote in message
news:uJFPxKWOHHA.4244@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> We are considering hardware upgrade.Can SQL Server 2005 Enterprise and
> Standard Edition fully take advantage of the Quad Core architecture ?.
Quad
> Core Intel Xeon X5355 is top of the range. Dual Core 5160 is another
choice
> worth considering. At the current prices,which one would be a more cost
> effective choice.
> Regards,
> http://www.intel.com/performance/server/xeon/database.htm
>
>

database backup using Veritas

Hi
My client wants to use veritas tape back in SQL Server 2000 Standalone and
cluster environment.
Can anyone tell disadvantages/practical issuse with veritas backup?
thanks
KalyanHi Kalyan
I am using Veritas netbackup for SQL server on SQl server 2000 and has no
issues with it. It is easy to use but I would prefer SQL*LITE
which provide much better functionality than veritas. The latest version
support tape backups too.
Tks
Mangesh
"Kalyan" wrote:
> Hi
> My client wants to use veritas tape back in SQL Server 2000 Standalone and
> cluster environment.
> Can anyone tell disadvantages/practical issuse with veritas backup?
> thanks
> Kalyan
>|||Personally from what I have experienced with VERITAS using backup tapes you
are better off using LightSpeed for backing up your SQL server because it
compresses the databases backup sizes by about 60% of what the normal backup
size would be on the hard drive. Also tape backups are not the most reliable
form of backup method in my opinon. I have used backup software and rotated
on removalable storage drives so that you can have a copy of database data
stored off location in case of a major disaster you have company livelyhood
in another location at all times.
Hope this helps. Below is the VERITAS information:
---
VERITAS Backup Exec 10 for Windows Small Business Server provides
exceptional value at a single price point. Best of all, the products are easy
to install and manage!
KEY BENEFITS
Complete data protection for Microsoft Windows Small Business Server 2000
and 2003
Easy to use, deploy and manage through user-friendly wizards
Low-cost, highly adaptable solution supporting backup and restore from disk
and tape devices
Intelligent Disaster Recovery reduces downtime for the local server and all
protected client systems at no extra cost
Fast backup and restore of Exchange Server, SQL Server, and SharePoint
Services
Continuous backup protection option for desktops and laptops
PRODUCT HIGHLIGHTS
ENHANCED! Cost Effective Complete Data Protection Solution â' Backup Exec
softwareâ's Small Business Server Edition provides complete data protection
for Microsoft Windows Small Business Server 2000 and 2003 in one totally
comprehensive suite. Core functionality includes database agent technology
for protecting Microsoft Exchange Server, SQL Server, and SharePoint
Services, Intelligent Disaster Recovery, and single tape drive autoloader
support.
ENHANCED! Ease of Use â' Enhanced install wizard helps ensure fast and
successful installations. Web-based administration console, new policy
wizard, and the new Backup Exec assistant, enable easy management and improve
the overall customer experience.
ENHANCED! Disaster Recovery for the Entire Environment â' Provides recovery
solution for media server and all systems backed up by the Backup Exec server
at no extra cost, eliminating the need to first reload the entire operating
system of crashed servers. Includes the ability to create system specific
recovery media for protected systems even AFTER a system crashes.
ENHANCED! Desktop and Laptop Option â' Provides continuous disk-based
protection and synchronization for users that are in the office or on the
road. Designed to automatically copy user data to existing network shares or
storage, it enables quick recovery of data by the administrator or the user
for optimum efficiency. The new push-install functionality from within Backup
Exec streamlines deployment, and user-specific backup reports improve data
and service level visibility.
Support for Microsoft Volume Shadow Copy Services Writer â' Backup Exec
Softwareâ's Small Business Server Edition supports Microsoftâ's VSS writers
simplifying the protection and recovery of Exchange and SharePoint Services
Faster, Flexible Backup and Restore Management of Online Exchange Servers â'
Single Instance Storage (SIS) of email message attachments, incremental or
differential mailbox backups and individual public folder restore provide
granularity and deliver faster backup and recovery of Exchange servers. The
agent also empowers administrators to perform individual mailbox backup with
selective restore, down to an individual message.
INCLUDED AGENTS AND OPTIONS
ENHANCED! Intelligent Disaster Recovery Option Saves recovery time by
automating the traditional manual, error prone process. The Intelligent
Disaster Recovery Option automates server recovery, reducing the time to
recovery and gets you back into business fast. Implement a server recovery
solution for both local and remote Windows servers, eliminating the need to
first reload the entire operating system of crashed servers. Using either
diskette-based, CD-R/CD-RW or bootable tape, the Intelligent Disaster
Recovery Option will quickly recover downed servers and workstations enabling
restores from the last complete backup set including full, differential,
incremental, and working set backups. The Intelligent Disaster Recovery
Option integrates directly with Microsoftâ's Automated System Recovery (ASR)
functionality in Windows Server 2003 and Windows XP to provide complete
disaster recovery on Windows servers. With Offline Protection functionality,
even when computer crashes before administrators create disaster recovery
media, IDR can still recover the computer using a full backup that includes
information needed to restore the system made prior to the crash.
ENHANCED! Agent for Microsoft Exchange Server Fast, flexible technology to
protect vital Exchange Server 5.5, 2000 and 2003 data while the application
is online. This agent provides full, incremental, or differential backup and
restores of embedded objects, attributes, and all Outlook components. Restore
can automatically mount the database upon completion of backups, which
ensures the valid database is brought back online quickly. Using the Single
Instance Storage (SIS) feature eliminates backup of duplicate information by
storing only the first instance of attachments distributed to multiple
mailboxes. For Microsoft Windows Exchange 2003 Server support, the mailbox or
message level restores from a full traditional backup does not require
installation of a separate Exchange 2003 server. When running on Microsoft
Windows Server 2003, the Backup Exec Agent for Exchange Server has added
support for Microsoft Exchange Server 2003 Volume Snapshot (VSS) technology
enabling the user to select either the VERITAS or the Microsoft proprietary
frozen image technology for protecting open files. The agent provides the
ability to perform consistency checks before backup when using Microsoft
Volume Shadow Copy Service.
ENHANCED! Agent for Microsoft SQL Server Ensures business- ritical databases
and e-business data are protected in the event of application or
hardware-based corruption or loss. This agent provides SQL Server 7.0 and SQL
Server 2000 users granular protection down to the individual database or file
group. Execute differential backups as well as Transaction Log backups with
automatic truncation. Restore with one-pass recovery of the last full and any
subsequent backup as a single restore job or perform â'rollback restoresâ',
enabling a database to be recovered to a specific moment in time, rather than
a specific restore point based on the last backup job. Virtual Device
Interface (VDI) support gives users the most dependable and fastest method
available for complete SQL Server protection. The agent supports Microsoft
Volume Shadow Copy Service (VSS) snapshot technology to create point-in-time,
recovery consistent snapshots of SQL Server 2000 on Windows Server 2003.
Consistency checks can be performed before backup when using Microsoft VSS
snapshot provider.
ADDITIONAL SMALL BUSINESS SERVER AGENTS AND OPTIONS SOLD SEPARATELY ENHANCED!
Desktop and Laptop Option Most businesses rely on users to manually copy
business critical data to a server. When users do not comply, the majority of
business-critical information residing on employee workstations, desktop and
laptop does not get protected. The Desktop and Laptop Option delivers
continuous data protection to desktops and laptops whether in the office or
on the road. Not only improving data protection and efficiency, this option
enables users to restore their own files, and maintains synchronization
between multiple desktops and laptops so the most up-to-date file versions
are available on all of a userâ's computers. Because the Desktop and Laptop
Option does not require a dedicated stand alone server as competing products
do, it easily integrates into existing IT infrastructure and policies,
helping lower the total cost of ownership. The new push-install functionality
from within Backup Exec centralizes deployment. This version also adds
Outlook 2003 support, reporting and console access control.
Library Expansion Option
Scale the media storage system by leveraging additional drives within
multi-drive tape or optical autoloader/library storage systems. This option
leverages Backup Execâ's Advanced Device and Media Management (ADAMM)
technology to provide extensive configuration and management capabilities to
include â'lights-outâ' backup and restore operations, bar-code reader and
portal support for both SCSI and fibre-attached devices. Users can partition
slots within libraries to target backup jobs to a specific slot.
ENHANCED! Advanced Open File Option
Helps ensure that files on local or remote servers are protected even while
in use. The VERITAS Backup Execâ?¢ Advanced Open File Option handles open files
at the volume level and is seamlessly integrated into Backup Exec software.
There is no need to know which files are open ahead of time; just set a
scheduled backup to use this option with a simple mouse click. It can backup
multiple volumes in one job while creating a snapshot of only one logical
volume at a time. After the logical volume is snapped and backed up, the
snapshot is deleted before the next logical volume is snapped. This feature
increases the ability to meet the minimum quiet time needed to complete a
snapshot. Advanced technology also provides the ability to detect and
leverage alternate frozen image technologies such as Microsoft Volume
Snapshot Service (VSS) on Windows Server 2003 or VERITAS Storage Foundation
for Windows FlashSnapâ?¢ for increased application availability.
ENHANCED! Remote Agent Client Access License (CAL) for Windows Servers
Expand network-wide data protection and optimize data transfers for 32 and
64-bit remote Windows servers, including local Registry and System State
information. Exclusive Agent Accelerator technology maximizes backup and
recovery performance by providing source-level compression and distributed
processing at the client. The result is reduced network traffic and maximized
data throughput.
ADDITIONAL BACKUP EXEC FEATURES
Backup & Restore
Support for Microsoft Windows Small Business Server 2003 Standard Edition
Support for Microsoft Windows Small Business Server 2003 Premium Edition
Support for Microsoft Windows Small Business Server 2000
Single-step protection of Server and Exchange data
Individual Mail Message Restore
Single-pass recovery of SQL Server
One-Button Backup capability
Complete Workstation Protection and Recovery
Desktop & Laptop Data Protection Option
Remote System Management capabilities
Environment check utility for the proper system configuration
CA ARCserve Tape Read Capability
Report Generation
44 Backup reports
Other Features
Include/Exclude File Selection
Onscreen Progress and Status Indicators
User Configurable Alerts
Automatic Job Retry
Scheduled Job â'Test Runâ'
Single Drive Library Support
100% Compatible with Microsoft Tape Format
Software Compression
Hardware Compression
Backup to Disk
Specified Backup NIC
SharePoint Services Support via Volume Shadow Copy Services â'Writerâ'
Integration
"Kalyan" wrote:
> Hi
> My client wants to use veritas tape back in SQL Server 2000 Standalone and
> cluster environment.
> Can anyone tell disadvantages/practical issuse with veritas backup?
> thanks
> Kalyan
>sql