I have a very large archived process that is expiring time-consuming.
This process is about 15 different- It also reads data from different databases in the same server.
I would like to reproduce anything (update / insert data in any table), to regenerate the environment.
Is it OK to make a snapshot of the original database and do all my tests? Not a database snapshot is read-only, so process will not be able to do anything.
Ask the system's database administrator to give you a backup of the database to do the problem again. Restore this backup on your Dev / Test environment and analyze the problem there. As your proc reads from several DBs, you will need to backup the those are ideally hardware characteristics similar to dev / test environment (similar CPU / cache / memory / disk), but this It is often impossible.
Read this to understand what you have to see after receiving your report environment. Make sure that you are solving the real problem, due to hardware defects there is no problem generating only on your repo environment
As a side note, The information in sufficient quantity can be collected invisibly from the production server via adequate monitoring, again, read the link from the article.
Comments
Post a Comment