m**b
发帖数: 9 | 1 在DBA这个位置上，第一周应该做什么？
我已经熟悉了系统，但是新老板不懂技术
但是我感到他很希望我作出些什么make difference.
我只是懂一些query optimization trick.
其余的都是现学来的textbook stuff.
很有些焦虑现在 |
c*****d
发帖数: 6045 | 2 作为DBA，系统不出问题，不当机就是最好的工作成绩
想make difference，最简单的就是sql optimization
能找到几句算几句，能改好几句算几句，呵呵
另外还要很多其他的，比如
space reorganization
bottleneck identification & performance tunning
backup & recovery策略改变 |
j*****n
发帖数: 1781 | 3 if MSSQL Server,
run a trace and try to capture the long running queries.
eg. RPC:completed, SP:completed sp:stmtcompleted
setup duration >=500
run perfmon, see if ur production under any pressure: cpu, memory, disk i/o.
..
google will be ur best teacher and friend.
good luck |
a*******t
发帖数: 891 | 4 "第一周"? don't brake the system, haa
【在 m**b 的大作中提到】
: 在DBA这个位置上，第一周应该做什么？
: 我已经熟悉了系统，但是新老板不懂技术
: 但是我感到他很希望我作出些什么make difference.
: 我只是懂一些query optimization trick.
: 其余的都是现学来的textbook stuff.
: 很有些焦虑现在
|
u******u
发帖数: 595 | 5 The 1st thing you need to do is Setup the monitoring system (which you know
how to use), so you can have a whole picture of your database.
Then from the monitored result find out if there is a problem.
If No problem, do enjoy your day as vacation everyday.
If find a problem, do fix it.
Don't change anything if it is running well.
Don't CHANGE APPLICATION CODE if it is running OK.
Thanks! |
j*r
发帖数: 17 | |
