A new article of mine is out!
This time I write about the meaning of “my database is slow” and what hidden secrets database contain. I.e. databases are never a single player in the game of performance.
Here is the article: How come the Hourglass? Why database applications slow down.
When migrating a database to a new SQL Server instance, there are numerous steps to be taken, as I mention here.
One of the considerations is to move all Agent Jobs related to the database to the new instance.
How do we find which jobs to move, though?
The rule of thumb in IT is that ’hardware used in production becomes obsolete every 3 years and needs to be replaced and upgraded’.
So far so good. The boss approves, the financial department approves, the IT department writes the specs and the vendor eventually delivers the hardware and installs it.
The old ‘obsolete’ hardware is
Continue reading […] A new beginning: migrating database systems to new environments […]