Plain language for new DBA 1

[ZoomerZ]

I was studying for DBA position in different language, now I need some terms to be clarified for me. If you can please, tell:
"security and database monitoring and tuning" in plain language. Thank you very much

 

[mrdenny]

security is making sure that only the people who are using the database are the people that need to use the database, and making sure that the people that need to use the database can.
database monitoring is watching the CPU levels, memory usage, disk capacity, disk IO, network IO, etc.
tuning is making sure that the database is configured to run as quickly as possible. Making sure that the database is configured in the best possible method. Making sure that the tables and indexes return data as quickly as possible, and the stored procedures are optimozed for the fastest execution possible without causing data corruption, blocking, locking, etc.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ZoomerZ]

I would be lost without you, guys. Get a star, thank you mrdenny

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)