Site sponsored by: Idera Try Idera’s new SQL admin toolset
SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Quiz
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


Article Topics

All Articles
Performance Tuning
Audit
Business Intelligence
Clustering
Reporting Services
Developer
General DBA
ASP.NET / ADO.NET

Write for Us

Share you SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

Capture DDL Changes using Change Data Capture with SQL Server 2008 ...
Business Intelligence in Collaborative Planning, Forecasting and Replenishment
Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I ...
Configure and Manage Policy Based Management in SQL Server 2008 ...

More     
 
Latest FAQ's

Cannot Start SQL Server Service
Users are able to connect to report manager but not able ...
Errors when SQL Server Snapshot Replication is Running
How to Display Server Name or IP Address in a Reporting ...

More     
   
Latest Software Reviews

Spotlight on ApexSQL Doc 2008
ApexSQL Enforce
Embarcadero Change Manager
SQL Server DBA Dashboard

More     

articles >> general dba >> SQL Server Upgrade Recommendations and Best Practices ...

SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning

By : Jeremy Kadlec
Jun 14, 2003

Page 2 / 5

Business Justification - SQL Server 2000 Upgrade

For those companies that have not migrated existing servers to SQL Server 2000, the rewards certainly outweigh the effort. The level of effort may be moderate to high, but the overall platform stability and feature rich capabilities of SQL Server 2000 are unprecedented. As a DBA, your ultimate responsibility is to ensure your systems are available to support the business needs to include the proper platform to efficiently and accurately process the transactions in a cost effective manner. Below outlines the Business Justification to leverage SQL Server 2000.

Business Justification

ID

Justification

Supporting Information

1

Total Cost of Ownership3

  • Total Cost of Ownership (TOC) lower than any other DBMS in the market

2

System Performance3

  • Unprecedented System Performance for both OLTP and OLAP environments

  • Improved ability to scale up and out by leveraging expanded hardware resources
    • As much as 64 GB of Memory and 32 Processors

3

Microsoft Support

  • As SQL Server 6.5 ages, Microsoft is providing less support for the product and will eventually have few Support Engineers available to address critical needs

  • Currently, if you have a business critical issue with SQL Server 6.5, the typical Microsoft Support recommendation is to ‘Upgrade to SQL Server 2000’

4

Regulated Industry Requirements

  • Upgrading to SQL Server 2000 becomes especially important for companies in regulated industries that may require a several year data retention period

  • Relying on SQL Server 6.5 for the short term may not be an issue because staff is familiar with the technology

5

DBA Support

  • In five years, finding individuals to administer SQL Server 6.5 will be difficult and not attractive to DBAs who are typically interested in the latest and greatest technologies

6

Level of Automation

  • The level of automation from the SQL Server tool set

    • Enterprise Manager
    • Query Analyzer
    • Profiler
    • Data Transformation Services (DTS)

7

New Capabilities2

  • Analysis Services
  • DTS
  • XML Integration
  • Optimizer Enhancements
  • Functions
  • DBCC’s
  • Log Shipping
  • New Replication Models
  • Full Text Indexing
  • Database Recovery Models
  • Linked Servers

8

Third Party Products

  • SQL LiteSpeed – Compressed and Encrypted backups – www.sqllitespeed.com

  • Lumigent Entegra – Enterprise Auditing Solution – www.lumigent.com/products/entegra/entegra.htm

  • Lumigent Log Explorer – Review and Rollback Database Transactions - www.lumigent.com/products/le_sql/le_sql.htm

  • Precise Indepth for SQL Server – Performance Tuning - http://www.precise.com/
  • NetIQ SQL Management Suite – Enterprise Monitoring and Alerting - www.netiq.com/products/sql/default.asp


<< Prev Page     Next Page>>    








Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | QDPMA Performance Tuning | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 1999-2008 by T10 Media. All rights reserved