SQL Server Performance

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


Article Topics

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

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

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

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

articles >> performance tuning >> The Ultimate SQL Server

The Ultimate SQL Server

By : Brad McGehee
Mar 31, 2003

Page 2 / 3


Disk Subsystem

  • Fibre Channel Connection with maximum amount of cache available. SCSI is so passé.

  • Direct Attach, SAN. I don’t care how the servers connect to storage, as long as I can get to my data faster than Bill Gates earns a dollar.

  • 15,000 RPM disk drives. I don’t live in California, so I don’t care if these drives drink electricity.

  • A cool one terabyte disk space. Anything less wouldn’t have enough bragging rights. Besides, its easier to glibly say, “My server has one terabyte” instead of “my server has one hundred-eight gigabytes.” (Fewer words to get out.)


Networking

  • Two Gigabit Networking Cards, each connected directly to its own exclusive Gigabit switch ports. I would need two, just in case one decided to take a break.


Other

  • NEC 18” LCD Screen. My baby blues deserve the best.

  • 16x/10x/40x CD-RW Drive. I want to be able to burn mix CDs when I'm performing routine backups.


Software

  • Windows 2000 Datacenter Server. Everything else is a wimp. The hard part, as I found out, is finding out how much this software costs. I searched the Internet in vain looking for how many pennies that my company will have to spend for an unlimited use license for eight CPUs. I guess the cost is so high, that they don’t want to put it on a web page and scare you away. All the references I found to its cost said to e-mail or call for more information. [Note: one visitor to my website pointed out that one vendor's price for Windows 2000 Datacenter Server can be found here.]

  • SQL Server 2000 Enterprise Edition. What else is there? And it can be yours for only $20,000 per CPU, or $160,000.


As I was pondering this list, I felt something was missing. An empty feeling penetrated by soul, my entire being. It was like I was alone in the universe. Then it hit me. I now knew what was missing. A 4-way cluster. Yea, that’s it. A 4-way cluster.

With a 4-way cluster, I could run SQL Server on three of the servers, leaving the fourth one for failover purposes. In fact, I would want four identical servers, as described above. The only difference would be that I would want to share my one terabyte of disk storage among all four servers. And then again, maybe I really need four terabytes of storage, you know, just in case.

Getting a server like I have described above would be like receiving my first two-wheeler for Christmas, maybe even better. I don’t have my hopes up too high that I will get one soon, but you never know. Ed McMahan could knock on my door.


<< Prev Page     Next Page>>    








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | 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 | 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


              © 2010 Jude O'Kelly. All rights reserved