Thursday, March 29, 2012

DBA First Date

Hi, I am going to start as the only DBA in a company, very nervous, since
there is no peer at the company and no transition from the job, could someone
told me when I start, what would be the initial steps to take for starting? I
read some article about daily activities on the job, since i used to be a
development dba, now into a produciton dba with 15-20 servers, how to get to
practice myself for this new job requirements?
For starters, try to keep in mind the most important things to the
organization:
-Backups. Make sure all your important databases are being backed up
regularly, and test the restores. Monitor and get very familiar with them.
-Maintenance plans. Make sure that appropriate maintenance windows are
taken for reindexing, updating stats, integrity checks etc.
-Setup perfmon counters that you can watch in real time from your
desktop machine. That way you'll often be aware of performance issues
before you get a phone call.
-Make sure your SQL boxes are regularly patched, ideally in a test
environment first.
-Make sure all your servers are on the latest service packs (assuming
you don't have any applications that would break with a new SP).
-Pick up an administration book to get familiar with all of the regular
routines a DBA has.
HTH,
Rubens
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:1AC1B73B-B186-4E55-A8BB-178FCE0BA8B6@.microsoft.com...
> Hi, I am going to start as the only DBA in a company, very nervous, since
> there is no peer at the company and no transition from the job, could
> someone
> told me when I start, what would be the initial steps to take for
> starting? I
> read some article about daily activities on the job, since i used to be a
> development dba, now into a produciton dba with 15-20 servers, how to get
> to
> practice myself for this new job requirements?
|||This role also require to hand reporting service, so anyone has
experience on handling both? thank you
On Mar 3, 5:25Xpm, "Rubens" <rubensr...@.hotmail.com> wrote:
> For starters, try to keep in mind the most important things to the
> organization:
> X X -Backups. XMake sure all your important databases are being backed up
> regularly, and test the restores. XMonitor and get very familiar with them.
> X X -Maintenance plans. XMake sure that appropriate maintenance windows are
> taken for reindexing, updating stats, integrity checks etc.
> X X -Setup perfmon counters that you can watch in real time from your
> desktop machine. XThat way you'll often be aware of performance issues
> before you get a phone call.
> X X -Make sure your SQL boxes are regularly patched, ideally in a test
> environment first.
> X X -Make sure all your servers are on the latest service packs (assuming
> you don't have any applications that would break with a new SP).
> X X -Pick up an administration book to get familiar with all of the regular
> routines a DBA has.
> HTH,
> Rubens
> "tulip" <tu...@.discussions.microsoft.com> wrote in message
> news:1AC1B73B-B186-4E55-A8BB-178FCE0BA8B6@.microsoft.com...
>
>
> - Show quoted text -
|||when Setup perfmon counters that you can watch in real time from your
desktop machine. If there are about 20 servers, how do you monitor all of
them from my desktop? thank you
"Rubens" wrote:

> For starters, try to keep in mind the most important things to the
> organization:
> -Backups. Make sure all your important databases are being backed up
> regularly, and test the restores. Monitor and get very familiar with them.
> -Maintenance plans. Make sure that appropriate maintenance windows are
> taken for reindexing, updating stats, integrity checks etc.
> -Setup perfmon counters that you can watch in real time from your
> desktop machine. That way you'll often be aware of performance issues
> before you get a phone call.
> -Make sure your SQL boxes are regularly patched, ideally in a test
> environment first.
> -Make sure all your servers are on the latest service packs (assuming
> you don't have any applications that would break with a new SP).
> -Pick up an administration book to get familiar with all of the regular
> routines a DBA has.
> HTH,
> Rubens
> "tulip" <tulip@.discussions.microsoft.com> wrote in message
> news:1AC1B73B-B186-4E55-A8BB-178FCE0BA8B6@.microsoft.com...
>
|||That's a bit of a tough one. I am lucky enough to have an additional
desktop machine aside from my laptop with a decent sized monitor. Even
then, I can only effectively see about 8 servers at a time. That being
said, you could still all add the servers (in blocks of 8), you'd just need
to scroll through them once in a while to see how they are doing. And if
someone called you with a performance issue, you could quickly flip over to
that particular one...
Rubens
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:7314E503-7223-47CD-B73F-19F6D3907216@.microsoft.com...[vbcol=seagreen]
> when Setup perfmon counters that you can watch in real time from your
> desktop machine. If there are about 20 servers, how do you monitor all of
> them from my desktop? thank you
> "Rubens" wrote:
|||Hi
[url]http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1 [/url]
--administaiting best practices
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --security
best practices
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:1AC1B73B-B186-4E55-A8BB-178FCE0BA8B6@.microsoft.com...
> Hi, I am going to start as the only DBA in a company, very nervous, since
> there is no peer at the company and no transition from the job, could
> someone
> told me when I start, what would be the initial steps to take for
> starting? I
> read some article about daily activities on the job, since i used to be a
> development dba, now into a produciton dba with 15-20 servers, how to get
> to
> practice myself for this new job requirements?

No comments:

Post a Comment