Start your ignition to Production

Question

Start your ignition to Production

Anamika

SSCertifiable

Points: 6202
More actions
October 15, 2010 at 3:15 am

#229766

Hi all,
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance tuning, storage mechanism, pagination etc...
Any hints in general, links to articles or white papers are welcome.
Thanks,
Ami

Viewing 8 posts - 1 through 7 (of 7 total)

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

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

That is a huge topic. You're not likely to get really useful responses in a forum like this. The configuration you need to put on your system is very dependent on the system itself. For example, you're going to haven entirely different memory settings for a 32 bit machine than for a 64 bit machine. My recommendation would be to get a couple of books like Kalen Delaney's SQL Server 2008 Internals or Brent Ozar, et al, SQL Server 2008 Internals and Troubleshooting. They're going to give you a lot more options, broken down and explained, so that you can apply the unique situation that you're faced with, as opposed to going through some checklist that may not apply to your server.

If you're really just getting started as a DBA, then you might want to get a copy of Brad McGehee's How to Become an Exceptional DBA. Great starter. Also, I wrote a few chapters for an introductory book, Beginning SQL Server Administration. It's specifically geared towards people just getting their start.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

george sibbald SSC Guru Points: 104210 More actions · Answer 2

Anamika (10/15/2010)
Hi all,
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance tuning, storage mechanism, pagination etc...
Any hints in general, links to articles or white papers are welcome.
Thanks,
Ami

If I was intuitive I would guess 😀

If I was vibrant I would borrow one of steves shirts 😛

---------------------------------------------------------------------

Anamika SSCertifiable Points: 6202 More actions · Answer 3

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance tuning, storage mechanism, pagination etc...
Any hints in general, links to articles or white papers are welcome.

Thanks, Grant Fritchey!

hope i didn't mean anything wrong....

I was asking for some links / white papers where i can shape my knowledge or from where I can start...

I know that there is no definite way to achieve this and this comes purely by experience.

Thanks,

Regards,

Ami

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

Anamika (10/17/2010)
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance tuning, storage mechanism, pagination etc...
Any hints in general, links to articles or white papers are welcome.
Thanks, Grant Fritchey!
hope i didn't mean anything wrong....
I was asking for some links / white papers where i can shape my knowledge or from where I can start...
I know that there is no definite way to achieve this and this comes purely by experience.
Thanks,
Regards,
Ami

Have you already searched without success ?

http://tinyurl.com/2c7az7h

or

http://tinyurl.com/2ez86gp

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

Anamika (10/17/2010)
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance tuning, storage mechanism, pagination etc...
Any hints in general, links to articles or white papers are welcome.
Thanks, Grant Fritchey!
hope i didn't mean anything wrong....
I was asking for some links / white papers where i can shape my knowledge or from where I can start...
I know that there is no definite way to achieve this and this comes purely by experience.
Thanks,
Regards,
Ami

No, you didn't say anything wrong, I'm sorry if my response implied it.

You're just going to have a tough time getting much, on this topic, out of forum posts. I strongly recommend Kalen's book. That'll teach more than just about anything. Once you've got the big picture nailed down, some of the white papers & stuff available out there will make a lot more sense.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Anamika SSCertifiable Points: 6202 More actions · Answer 6

Hi Grant Fritchey,

I didn't mean it. I need a starting point(that why i mention ignition). I take your suggestion. Let me go through Kalen's book.

Thanks a lot,

Regards,

Ami

P Jones SSChampion Points: 12361 More actions · Answer 7

P Jones

SSChampion

Points: 12361

October 20, 2010 at 4:26 am

#1239554

An ITIL foundation course?