Tres enfocaments de la gestió del creixement de les bases de dades |
|
En SQL Server es pot utilitzar l'ordre DBCC SHRINKDATABASE per reduir l'espai ocupat pels arxius de dades i de log. El problema de SHRINKDATABASE és que, al contrari del que pugui semblar, si no s'utilitza be, pot donar com a resultat un important increment en la fragmentació dels índexs, i de les taules, cosa que deriva en un empitjorament del rendiment de la nostra base de dades..
An application using SQL Server as the database backend was experiencing some application rollbacks. I decided to investigate the SQL Server to identify any errors which could be correlated to the application timeouts experienced by the users.
I started reviewing the errors in the Extended Events system health logs, which are normally running by default on a SQL Server. They…
In this blog, we will discuss about how to perform cluster configuration changes while cluster is up and processing transactions (online).
In MySQL NDB Cluster, configuration data is parsed and distributed by the management server (MGMD) nodes. Users supply an input text file (commonly known as config.ini) which describes cluster topology, resource usage limits and other parameters. The…
Aquesta obra està subjecta a una Llicència de Creative Commons.
