I need help from froum guys?

Question

Post reply

I need help from froum guys?

elchuru

Default port

Points: 1435
More actions
March 26, 2009 at 1:31 am

#130142

Hi guys,
I need your help regarding dba daily activities.
Please give me what are daily activities as dba. And what are critical issues u faced as dba. Those will be big helpful for me in coming days.
Please help guys
Thanks in advance
vijay

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Eswin SSCrazy Eights Points: 8320 More actions · Answer 1

1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.

2. Verify that all scheduled jobs have run successfully.

3. Confirm that backups have been made and successfully saved to a secure location.

4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.

5. Throughout the day, periodically monitor performance

6. Last of all, don't stop learning new things. It's a constant learning and you need to know what's out there that can bring value to yourself and the business

Tanx 😀

elchuru Default port Points: 1435 More actions · Answer 2

Eswin (3/26/2009)
1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
2. Verify that all scheduled jobs have run successfully.
3. Confirm that backups have been made and successfully saved to a secure location.
4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.
5. Throughout the day, periodically monitor performance
6. Last of all, don't stop learning new things. It's a constant learning and you need to know what's out there that can bring value to yourself and the business

Thanks a lot eswin

elchuru Default port Points: 1435 More actions · Answer 3

Hi guys,

Please tell me about dba dailly activities.Because tommorow onwards i have to attend interviews.

Thanks in advance

BLADE-1043594 SSCrazy Points: 2576 More actions · Answer 4

It includes backup databases,monitoring the servers,monitoring diskspace for proper running of servers.

1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.

2. Verify that all scheduled jobs have run successfully.

3. Confirm that backups have been made and successfully saved to a secure location.

4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.

5. Throughout the day, periodically monitor performance using both System Monitor and Profiler.

6. Use Enterprise Manager/Management Studio to monitor and identify blocking issues.

7. Keep a log of any changes you make to servers, including documentation of any performance issues you identify and correct.

8. Create SQL Server alerts to notify you of potential problems, and have them emailed to you. Take actions as needed.

9. Run the SQL Server Best Practices Analyzer on each of your server’s instances on a periodic basis.

10. Take some time to learn something new as a DBA to further your professional development.

11. Verify the Backups and Backup file size

12. Verifying Backups with the RESTORE VERIFYONLY Statement

13. In OFF-Peak Hours run the database consistency checker commands if possible

[font="Comic Sans MS"]+++BLADE+++[/font]:cool:

GSquared SSC Guru Points: 260824 More actions · Answer 5

Daily activities are only part of it. The list above is pretty good for those.

You'll also want a schedule of weekly activities, and monthly, most likely.

For example, every Monday, I do restore tests on databases. Just to make sure they're looking okay.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

elchuru Default port Points: 1435 More actions · Answer 6

Hi,

What are regulars activities that will be doing by DBA in terms log shipping and replication.And what are performance issues check by dba.

Please help me.

Thanks in advance

Vijay

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

prvreddy (3/26/2009)
Hi guys,
Please tell me about dba dailly activities.Because tommorow onwards i have to attend interviews.
Thanks in advance

If you're applying for a job as a DBA, then you should already know that.

Or are you applying for a very junior position?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 8

We can't really teach you enough for an interview, nor are we interested in having you try to show more knowledge than you have.

Be honest that you don't know answers. Show you know where to find answers, which is important. If you don't know that, perhaps you're applying for the wrong position.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 9

Normalization will probrably come up and yes the interviewer will ask you some questions.

Be honest and say i not done this part but i am happy to research and provide this to you later in the day.

maechismo_8514 SSCoach Points: 17510 More actions · Answer 10

And also some interviewers try to scare you. You don't have to, be confident as long as you know the right answer and that depends on your experience and how much you practiced on your server.

Long back I was asked what are the High Availability options in SQL 2005. I mentioned Log shipping as one of them and he replied me back saying it's not!!!!!! and justify how could it be, I thought ahhhhhh what a dumbhoooooo:w00t:

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 11

Confidence is paramount, however being truthful about your skillset will help. A smart interviewer can immediately spot when someone is making things up.

elchuru Default port Points: 1435 More actions · Answer 12

Hi guys,

If you working as a DBA for bank, What are common types problems can occur regularly.

Thanks in advance

vijay

Sequelsurfer SSCrazy Points: 2562 More actions · Answer 13

There is an excellent EBook available for download called 'DBA Best Practices', sounds just what you are looking for. I downloaded it AFTER I got through the interviews recently and it has been extremely helpful. I am a relatively inexperienced DBA so the book has been just what I needed for filling in the gaps.

It's amazing what you can find if you look hard enough.:-)

elchuru Default port Points: 1435 More actions · Answer 14

Paul H. (3/27/2009)
There is an excellent EBook available for download called 'DBA Best Practices', sounds just what you are looking for. I downloaded it AFTER I got through the interviews recently and it has been extremely helpful. I am a relatively inexperienced DBA so the book has been just what I needed for filling in the gaps.
It's amazing what you can find if you look hard enough.:-)

Hi Paul can you tell me author name ?

I am having "Database Administrator" by Craig S. Mullin

Is it same what u told.If it is different from the above please give me full name and author name.

Thanks in advance

vijay