未加星标

SQL SERVER Performance Choice Coding or Automation

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二03 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏

We talk a lot about optimizing SQL with building the most efficient queries and application architectures. It’s what we enjoy doing and what we’re paid to do. We love to twiddle bits and tweak code, and can spend day after day doing this. But are we looking at the big picture? Is what we are working on the highest priority for the business or organization we work for? Are we extending our value beyond just implementing and optimizing SQL databases and applications? Can we deliver value that has a return on investment (ROI) to organizations? That ROI can be in terms of making people more productive, saving infrastructure costs, and even making trade-offs for when we should code and when we should automate. This even applies to when to use consultants like me. Can an hour of consultation with me save days or weeks of research and trial-and-error in addressing a major performance roadblock?


SQL SERVER   Performance Choice   Coding or Automation
Coding or Automation

A good case in point is to consider that all SQL Server applications are running on a network. These applications contend with other applications for network resources, whether in the data center, across geographies, or into the cloud. Beyond this, consider that database applications are generally going to be one of the largest impacts on network traffic since things like analytics, replication, and interactive database applications can result in very large amounts of data being moved. Most DBAs considers this the network team’s problem. The result is massive investments in infrastructure to support the data center, remote offices, cloud applications, and mobile users. Consider the costs in terms of network cabling, routers (cable and wireless), WAN optimizers, and with the cloud they charge for bandwidth and may also charge for data volume. For even mid-size organizations these costs can add up to hundreds of thousands of dollars in setup costs and monthly costs in the thousands to tens of thousands of dollars. Closer to home, you help make choices in architecture that affect whether you need Standard SQL Server or Enterprise which again can impact the cost of tens of thousands of dollars.

Saving UDS 100K per Year

An example is when you run across performance issues with end-users experiencing slow performance due to the network or replication being too slow between sites, the organization has a choice to expend a lot of energy in optimizing the application, purchasing more bandwidth, or purchasing WAN optimizers. That can cost thousands of dollars per year. I have been experimenting with a tool called NitroAccelerator from Nitrosphere that addresses this problem at a fraction of the cost of the other solutions. In my testing, not only does NitroAccelerator improve performance across slow networks, but with large queries, I was experiencing a big performance improvement on a high-speed LAN. I had discussed this product with a customer of theirs that provides big data analytics for consumer behavior analysis. The DBA was initially trying to fix a performance problem for the data analysts. The result was that he saved the organization nearly $100K per year in data related costs to their cloud provider. And, yes, he solved the performance issue.

This is one example of creating a huge benefit to the organization without having to code. The important thing is to look beyond your direct responsibility and see your impact across the whole organization. Will using automation save the organization money? Will it improve productivity? Will it allow you to move on to other high-visibility issues? Additionally, if you think this way before you roll out new applications, maybe you can get them productive faster with minimal resource impact. Maybe you can roll out more applications faster.

When considering a problem or a new application rollout consider all resources your technical abilities, automation, and consultation that augments your abilities to bring the greatest value to your organization. By doing this, you can be a hero to the organization and it can only help your career whether there or elsewhere.

For more information on Nitrosphere and/or to try NitroAccelerator, please visit http://nitrosphere.com/trial/

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLSQL Server
分页:12
转载请注明
本文标题:SQL SERVER Performance Choice Coding or Automation
本站链接:http://www.codesec.net/view/480060.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(34)