Monitoring SQL Services with Out-of-the-Box Microsoft Tools

According to the recent news, Google launched the databases (SQL) service for its cloud-hosted app engine application development and hosting platform. For now, the database called Google Cloud SQL is available for preview only. This database based on SQL services will soon be available to the public, after a successful completion of the preview stage. During this period, Google offer its Cloud SQL service free of charge and promises to publish the details of charges 30 days prior, in case they plan to charge for their services at a later stage.

After a much successful Cloud hosting and DBMS services from a variety of known names, Google enters this business. Competing with Microsoft again, Google plans to offer the capabilities of MySQL database. This allows Google to maintain high portability and helps in faster time-to-market transition.

Cloud DBMS is evolving and we define it as a distributed database, which can deliver query services across multiple data centers. Before cloud services came into existence, querying distributed data source was a grave problem encountered by businesses. Even today, as cloud DBMS is in evolving stage, it is imperative for cloud computing to grow to deliver a high availability and cater to disaster recovery.

Internet-based computing evolved cloud computing. Beginning from the static pages to adding interactivity to those pages, internet provided a common infrastructure. Internet unveiled its potential when it became possible to add more configurations to the web-based applications; they renamed it as Software-as-a-Service (SaaS).

When growing companies looked forward to engage in SaaS services, Amazon released web-services that enabled companies to operate their own SaaS. Later, companies created their own private cloud platform; and now, many offer public cloud as a service. In a similar fashion, Microsoft offers private cloud service in the form of SQL Azure.

The reason for the evolution of Cloud DBMS is scalability. Traditionally, organizations focused on relational and column-store databases that followed a centralized architecture limiting the scalability at some point both within and between the data centers. However, a distributed architecture seamlessly scales and is needed to satisfy cloud DBMS characteristics.

Google Cloud SQL service allows enterprises to focus on developing applications and services, free from the chorus of managing, administering and maintaining relational databases. It includes import/export features, which would allow developers to move their databases on-premise, which would be further administered, maintained and replicated by Google. Google's Cloud SQL services are still under improvement. However, continuation of such services would soon eliminate the left-over cloud deficiencies and will make a huge difference in the way database or SQL services work today. We are soon to see a full-fledged concept of CDBMS (Cloud Database Management System).

About DBA-24x7

DBA-24x7 provides MySQL Enterprise monitoring services to clients of all sizes without compromising on personal attention to each. An impeccable team at DBA-24x7 offers high performance, secure and managed MySQL, Oracle and SQL services.