Microsoft – SQLServer – Frenemy

Microsoft – SQLServer – Frenemy

In the “Microsoft SQL Server” Ecosystem, there are many frenemies.

There are many ways to define that term, but I will settle on Wikipedia’s:

Someone who really is your friend but is also a rival  

Obvious friends are the chip vendors:

  • Intel
  • AMD

Obvious friends also includes the server hardware vendors:

  • HP
  • Dell

Storage vendors:

  • EMC
  • NetApp
  • IBM
  • Fujitsu

Software Application Vendors (Enterprise):

  • SAP
  • Oracle

Software Infrastructure Vendors:

  • VMware

Chip Manufacturers

Intel & AMD

To praise the chip vendors for the work they have done in raising the bar for computing is to say so very little.

  • AMD in sticking with the original x86 microsoft design and starting the craze to add more CPUs
  • And, Intel in catching up and arguable surpassing AMD in some quarters
  • Memory Addressability up to 2 TB (increasing the size of memory that can into a box)
  • NUMA & Local Memory (with all these microprocessors and memory in a box, to get the best performance, one has to gracefully handle the interaction)
  • Hardware Assisted Virtualization (Hypervisor -> Live Migration)
  • Reliability – Hardware error recoverability (Machine Check Recovery)
  • Energy Savings & Power Efficiency

PC Manufacturer

After the chip manufacturers, the group that has the most to do with your database performance is the host manufactures, the HP and the Dells of the world.

Their work is to add everything up – do the hard work in the LAB and publish Reference Architecture that talks up the design principles and guidelines.

With iSCSI, Fiber Channel, and them buying up HBA companies they are “elbowing” a bit into the Storage area.  And, so their footprint is only growing.

Same with the investment that they are making with Network Switches & Routers.

Dell

The fruits of Dells overarching investment can be explored @

Implementing SQL Server
http://www.dell.com/Learn/us/en/555/sql-server-implementing

Storage Vendors

EMC

Traditional SAN Vendors such as EMC are starting to enable high speed storage —

  • Introduction of  Flash Drives – “FAST cache uses enterprise Flash drives to extend existing cache capacities up to 2 terabytes. FAST cache monitors incoming I/O for access frequency and automatically copies frequently accessed data from the back-end drives into the cache. FAST cache is simply configured and easy to monitor” – Fully Automated Storage Tiering – http://www.emc.com/corporate/glossary/fully-automated-storage-tiering-cache.htm

Read more @ “EMC Fast Cache” — http://www.emc.com/collateral/software/white-papers/h8046-clariion-celerra-unified-fast-cache-wp.pdf

References:

Infrastructure Software Vendors

VMWare

There are plenty of published resources from VMWare regarding MS SQL Server.

They include:

Enterprise Software Vendors

SAP

To say that SAP is a big friend is an understatement.  Here are some sites:

For specific MS SQL Server version:

 

Oracle

A good listing of documents available for those interested\invested in suporting Oracle Applications on Microsoft Infrastructure is available @:

Microsoft and Oracle Applications and Technology Platform
http://blogs.msdn.com/b/anu_chawlas_blog/

Consumers – Governments & Corporations:

The paying customers continue to be the fuel that is driving the exponential growth in Technology.

  • They buy the software and ask for it to run all the time
  • They ask for the Power Savings so that they do not have to keep building new data houses
  • They fund by employing all those who produce the white-papers, blogs, and discussion forums out in the wild

Global community:

Just like MTV did for Singers and Song-writers, the Internet has made it cool to be an introvert and prefer to code than to talk.

So here is to the players…

  • US Government, Defense Industry, Telcos for laying the pipe
  • The Robert Metcalfe (Ethernet), Vincent Cerf (Internet)
  • Google for making it faster to search for something on Net than even one’s own brain — forget from your cube mate
  • Jimmy Wales (Wikipedia) & Matt Mullenweg & Mike Little (WordPress)
  • Microsoft Bloggers
  • QA forums – StackOverflow, Serverfault
  • Community forums (SQL Server Central [Steve Jones] – http://www.sqlservercentral.com/)

Conclusion:

All in all, everyone on the table is doing a tremendous job in the back-rooms and on the Net.  They are spending a lot of resources and evangelizing like crazy.

So that each one of us can continually ask, have we done enough.  Have you really gotten as much as you can get from your Technology Portfolio.

I know Engineering and the Operations side of the house is quite different.  Operations job is to keep things running; and Engineering is to architect firm, reliable, optimized, and systems built to grow.

So if you find yourself in Engineering, ask where your bottlenecks are and how much you ‘re leaving on the table?

To rest a bit on one of my favorite Rap Lyrics — Everything on the table, someone paid for it, another slaved for it, and God gave the increase.

And, that is why we talk about it.

References:

References – Intel

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s