A few days ago, ACMUG&CRUG technology salon greets countrywide make one's rounds to perform the 10th station -- Xi'an stands. This is ACMUG&CRUG first time conducts technical salon activity to Xi'an, also be Xi'an technology person people expect long already sumptuous dinner. Technologist of Hua Weiyun database did a theme to make a speech: " Hua Weiyun Microsoft SQL Server aids power company to digitlize transition not to have care " .
As in recent years the cloud on the enterprise, digitlization transition makes the trend that everybody agrees with gradually. How to choose the database on the cloud, how to help an enterprise go up quickly the cloud, how to let an enterprise be used weller on cloud platform, more province, more be at ease, it is extensive business management person the theme that maintains personnel to pay close attention to with database development.
Of technologist of Hua Weiyun database this second share, also cut from above problem just about, all-around introducing enterprise should how implementation of achieve greater ground digitlizes transition.
The cloud on traditional business SQL Server 4 big painful
Limitation of attributive of date of 1. database Zhang is big, development habit suffers an effect
SQL Server uses a database as a business, the meeting in cloud process is faced with Zhang date attributive to suffer on be restricted, the influence develops a habit, cause the problem of loss of efficiency.
Suffer commonly be restricted attributive, include: Cannot found the database, inquiry that does not have view of commonly used system attributive, cannot found child Zhang date and advanced function cannot use accredit, a few databases, cannot direct Kill process.
2. business uses database function character castrate is much, business sells at a discount with value
Well-known, the characteristic with the most welcome SQL Server, character of function of nothing is more... than is all ready, use convenient. But going up in cloud process, suffer the effect of the element such as technology, compatibility, functional character encounters castrate, bring about business to sell at a discount greatly with value.
Common the function that be emasculated, include: Link service, optimize data of advisory, SQL Profiler, change to capture, database audit function is waited a moment.
3. tripartite uses compatible ability difference, cloud passageway suffocate suffocate fills in on
The cloud serves the biggest value drop, depend on the integrality of the convenience sex that resource calls and zoology. But in the process that uses the cloud on the service in business, often be faced with tripartite to use compatible ability difference, cloud passageway gets the problem of block on. This brings about an user to must face the following challenge:
(1) the tripartite software that this locality uses cannot direct and migratory go up to the cloud
(2) cannot support traditional software vendor to provide the service on the cloud
(3) file of the data below Yun Shangyun is alternant and difficult
(4) the user is based on database management migratory not agile
4. version is enclothed not complete, use choice is not agile
SQL Server version is numerous, at present the business on cloud database market uses version cannot complete enclothe. Business of a few services offers enterprise edition only, or offer only 2008 with a few a few big edition, perhaps offer double opportunity only again tall usable version, bring about an user going up the choice in cloud process suffers be restricted.
Heavy fist hits out: Case of all directions of suit the remedy to the case of Hua Weiyun SQL Server
Be aimed at the 4 big pain spot of the cloud on traditional business SQL Server, hua Weiyun gave out the solution of a suit the remedy to the case combines a fist.
1. essence allows attributive segregation, the experience below the line on the line is consistent
Hua Weiyun SQL Server undertakes be keepinged apart effectively to user attributive and attributive of systematic carry dimension, open all engine character of SQL Server the user to use (link service, optimize data of advisory, SQL Profiler, change to capture, database audit function is waited a moment) , make sure DBA carries dimension personnel and database develop personnel, the line on the line issues the consistency of the experience, the harm that causes attributive misgovern possibly to the database at the same time falls lowest.
2. 6 big character, file of the data below the line on get through line is alternant
What issue a database to the line on the line to make sure the user is agile is migratory with management, hua Weiyun developed 6 big character, file of the data below the line on get through line is alternant channel, accomplished whole process undertake with database granuality alternant, is not traditional undertake handling for the unit with example.
(1) backup file downloads: Supportive user downloads the backup file on example by the database, quicken an user to get the data on the line quickly
(2) backup file uploads reductive: Leave a line migratory through DRS the task, the user can go to file backup of on this locality example many databases in file of backup of one or more Bak, one-time upload reductive to target example.
(3) the hand moves database snapshot: When supportive user founds a hand to move snapshot, can choose database of the correspondence on this example.
(4) increment backup uploads reductive: Leave a line migratory through DRS the task, the user is OK the complete equipment database of this locality example&Increment of day equipment file uploads reductive to target example.
(5) backup is reductive&PITR is reductive: When the user has reductive operation to current example, supportive user chooses partial database to have reductive operation.
(6) the database is fast and migratory: Leave a line migratory through DRS the task, the user can move snapshot and automatic snapshot through the hand on example, fast will among them a database is migratory go up to the example that is the same as Region.
3. is offerred exceed complete edition to make sure the line on client SQL SERVER is compatible ability
Current, hua Weiyun SQL Server offers the cloud of the most complete edition inside course of study to serve, supportive limits is enclothed 2008, 2014, edition of standard of 2016 whole set, enterprise edition, Web edition, 2017 enterprises edition, will go up line 2012 version, a variety of norms make an user OK choose the most appropriate example according to different setting, economic cost 90% above.
(1) freeboard function, freeboard is reliable enterprise edition
Enterprise edition: Highest norms 60U512G; Already offerred 2008 now | 2014 | 3 2016 version, support crosses AZ Gao Ke to use completely synchronous pattern, ensure clerical strong consistency, be user core business not 2 choices.
(2) price material benefit, function is all ready standard edition
Standard edition: Highest norms supports 16U128G; Already offerred now 2014, two 2016 version, support crosses AZ Gao Ke to use completely synchronous pattern.
(3) freeboard sex price is compared
Web edition: Highest norms supports 16U64G; Already offerred now 2008, 2014, 3 2016 version, support stand-alone pattern, commercial serves, drive the price of the source.
4. soft hardware is united in wedlock, the database on superexcellent cloud experiences
Hua Weiyun SQL SERVER uses newest hardware to configure, abide by Microsoft in the round optimal practice, provide service of the database on first-rate cloud to the user.
(1) all example norms all is used China for V5 series newest hardware is configured.
(2) finish setting of example of 200 multinomial Windows.
(3) finish configuration of server of 40 multinomial SQL SERVER.
(4) 74 example parameter is worth version of nine of the SQL SERVER that finish optimal deserve to compare.
Be worth what carry is, in newest TPCC function pressing is measured in, no matter Hua Weiyun SQL SERVER is odd below example or tall usable example, the each function index such as TPM, IOPS all the other cloud on far outclass market serves, TPM is to break through 1 million above more!
Not long ago, china for enterprise of cloud database SQL Server 2017 edition head is sent, use Gao Ke of Microsoft Always On to use a framework, support is read write depart, laden and balanced. This version is highest support 5 read-only carbon, intelligent zoology serves embarking Hua Weiyun, the user that help strength answers huge data processing easily, dimension allowing use does not have care!
Know news of more of Hua Weiyun SQL Server, visit government-owned net please.
Welfare time: Hua Weiyun database is popular engine new user is free try out, support enterprise and individual formula!
New user clicks lower part to link → to login / register renown attestation of fact of → of date of Hua Weiyun Zhang (enterprise / individual) → of → choice engine is gotten instantly
