SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


So You're the New DBA


So You're the New DBA

Author
Message
Daryl Quadros
Daryl Quadros
SSC-Enthusiastic
SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)

Group: General Forum Members
Points: 164 Visits: 194
Comments posted to this topic are about the item So You're the New DBA
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: General Forum Members
Points: 147938 Visits: 41714
we quickly resolved the situation by upgrading the server to 2GB of RAM


Heh... I guess they didn't think too much of their server Tongue

Good write up about what to look for when you first "move in". I'd also add that you should determine the number of CPU's, what the disk configuration is, and where they keep the backups. Guess that might fall under the "Total/available disk space and other relevant server specs" bullet you mentioned, but wanted to break those out, for sure.

I'd probably also talk with the boys in OPs and find out what type of firewalls are in place and also check to see what types of encryption may be in place.

Heh... then there's the matter of finding out what the SA passwords are for all the servers, once you find all the servers Smile

Anyway, good article. Thanks for taking the time to write it.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Clive Strong
Clive Strong
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2152 Visits: 6610
Nice write up. I started at a new place a few months back and yeah, that is a good start point of things to get to understand in the first couple of days.

I guess I've been lucky to have never jumped in at the deep end with a company that has a horrible environment. More a case of less than optimal database servers thankfully!
majorbloodnock
majorbloodnock
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2029 Visits: 3062
Good succinct list, although I must admit I'd add another paragraph right at the beginning about backups - taking fresh ones and/or verifying existing ones, perhaps also performing a test restore or two. My modus operandi has always been to have a fallback position, and, if none is forthcoming, to create one, so knowing I've got good backups from the point I started is perhaps number one on my list.

A while ago, I read a similar article regarding Oracle DBAs, but this time it was what to do when one is about to leave. One of the suggestions was to ensure, if possible, that all important databases were restarted a significant amount of time BEFORE the incumbent DBA left the building for the last time. The idea was to avoid hidden time bombs of changes that have been applied that are still to come into force (running parameters vs configured values, for instance). It also ensures problems are seen whilst the person with the knowledge of the system is still around to fix it. Coming back to Daryl's article, I'd still suggest it's a good idea to follow up taking your backups with a plan of rebooting all servers as soon after you've started as possible so that the environment is in a known state.

Semper in excretia, sumus solum profundum variat
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: General Forum Members
Points: 147938 Visits: 41714
Heh... the only Latin I know is "Non Illigitimi ie Carborondum" (very loosly translates to "Don't let the ba----ds grind you down". What does your tag line mean? Just curious, that's all...

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
majorbloodnock
majorbloodnock
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2029 Visits: 3062
Jeff Moden (11/28/2007)
Heh... the only Latin I know is "Non Illigitimi ie Carborondum" (very loosly translates to "Don't let the ba----ds grind you down". What does your tag line mean? Just curious, that's all...


BigGrin

"Always in the sh-t, it's just the depth that varies"

Semper in excretia, sumus solum profundum variat
Wayne West
Wayne West
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4352 Visits: 3702
A few more things to look for:

Auto-close.
Auto-shrink.
Recovery Model.
Auto-Grow settings, very important if somehow databases got on to the C: partition.
System databases are getting backed up.
DBCCs and index maintenance. I run them as scheduled jobs, not through maintenance plans, so as to get more detailed output.
LICENSING. I'm concerned about the server licensing more than the client licensing.

When I started at my current job, the help desk ticketing DB was set to auto-close. And auto-shrink. On a dual P3/500 box. It wouldn't have been so bad if it hadn't been seven months ago. Funny, that server is now a lot more stable now that those two settings are turned off.... BigGrin

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: General Forum Members
Points: 147938 Visits: 41714
majorbloodnock (11/28/2007)
Jeff Moden (11/28/2007)
Heh... the only Latin I know is "Non Illigitimi ie Carborondum" (very loosly translates to "Don't let the ba----ds grind you down". What does your tag line mean? Just curious, that's all...


BigGrin

"Always in the sh-t, it's just the depth that varies"


OMG! Now, that's funny! BigGrin The funny part is, it's so true Hehe

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Curt Spanburgh-286235
Curt Spanburgh-286235
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 4
Good Article, and very down to earth. As a Dynamics MVP, I see SQL servers treated like water heaters.

The day of decision comes when the apps stop working.

Then it is often too late.

Thanks for the club to bring about a reality check.
/:>
John Mitchell-245523
John Mitchell-245523
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23786 Visits: 16470
majorbloodnock (11/28/2007)


BigGrin

"Always in the sh-t, it's just the depth that varies"


Sorry to be pedantic, but shouldn't the comma come after "sumus"?

John
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search