how to do hardware and SW assesment.

hi
if i want to evaluate my database servers and make sure that i am free of risks. i have told to make risk assesment on my databasees or SWs..how ut can be done.
besmile4everAsked:
Who is Participating?
 
CallandorConnect With a Mentor Commented:
Basically, you want to know if you have redundancy in your hardware and software such that if a piece of hardware fails, there is a backup system.  The same is true of a fault in the software.  Make sure your backup plan covers failures and allows you to restore to the point where the business can continue to operate.
0
 
besmile4everAuthor Commented:
hi
ok what about the database it self is there any important parameters that I should take care of it..
0
 
CallandorConnect With a Mentor Commented:
Keep your log files on a different drive from the data.  There are whole books written on tuning databases for optimal performance, so I won't go into that here.  You do want regular backups of your databases in a rotating schedule so that in the worst case, you only are off by one day's worth of data, so make daily backups, then weekly backups and monthly backups.

You want to make sure no one can freeze your database with exclusive locks on records unless they absolutely need to, and then only for a short time or off hours.  You should have permissions in the database so that no one goes in as sysadmin; give them the minimum amount of permissions to enable them to do their job.  Guard against queries that return an excessive number of records; these can crash a server or prevent anyone else from using the database.  Perform periodic load balancing if you have the option to keep one machine from being overwhelmed.
0
 
besmile4everAuthor Commented:
thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.