Im working on an assignment that involves automating an SQL server and im stuck
ID: 3907048 • Letter: I
Question
Im working on an assignment that involves automating an SQL server and im stuck on the following question,
"If this database became very large and your weekend performance impact window (time when you can affect performance) became limited, what adjustments might you need to make? Try to come up with at least two adjustments."
I know one adjustment might be giving each task a different time entry but I cant think of any more, can someone please help me come up with atleast one more adjustment I could make please
Explanation / Answer
SOLUTION:- You will have to scale-out the database from minimum dismission to maximal :--
1-We can scrutinize the indices,triggers and WAL procedure because these are very easy to modify at DBA level resulting minimum impression.
2-We can scrutinize large SQL statements. for eample MERGE INTO SQL transactions should be moved to NoSQL database because they are the main causes of Deadlocks.
3- We will have to ensure batch files calling from application level code in order to correct Invocation of a database.
4- We will scrutinize the database and make sure that it is in optimal form even if it violates the DBA rules by such that denormalize the 3 tables into 1 in order to stop O(n^3) join operation is being executed on 3 large tables.
================================================================================