SQL in the Cloud, Feet on the Ground
Salvato in:
| Pubblicato in: | Database Trends and Applications vol. 24, no. 4 (Dec 2010), p. 28. |
|---|---|
| Autore principale: | |
| Pubblicazione: |
Information Today, Inc.
|
| Soggetti: | |
| Accesso online: | Citation/Abstract Full Text Full Text - PDF |
| Tags: |
Nessun Tag, puoi essere il primo ad aggiungerne!!
|
| Abstract: | Long-running queries and idle connections will be closed. Also, excessive resource usage will result in the closing of a connection. I struggled to find a definition of what excessive resource usage would equate to, but this is an inevitable constraint, as others will be sharing the resources allocated to your database, much like your ISP's "fair usage policy." Working with smaller companies, I often find SQL Server struggling along without a specialist DBA. It is generally an exercise in keeping your head above water and hoping nothing fundamental goes wrong. By moving suitable applications to the cloud, companies can remove the burden of worying about areas such as hardware, high availability, and patching. Microsoft will manage resource allocation and transparent failover, but normal database and security administration is still in the hands of the IT department. You have no control over CPU, memory, or storage configuration, but you still manage schemas, indexes, statistics, and query optimization. |
|---|---|
| ISSN: | 1547-9897 1089-019X 1525-4976 |
| Fonte: | ABI/INFORM Trade & Industry |