performence tuning tips for dba

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

Performance tunning is very VAST area. it will taker years of practice.

You can tune your db thru

1. SQL Server profiler

2. DTA (Database Engine Tuning Advisor)

3. DMVs(Dyanamic management views)

4. DBCC commands

but can you specify you exact requirement ?

In the meantime refer these links

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 2

I generally try not to do this, but in this case, follow the link in my signature below. There's a book that covers what you need.

There's no way for someone to give you enough information in a blog post to provide you with a meaningful construct to begin performance tuning.

Also, just so you know, the difference between tuning for a 3gb database and a 300gb database is rather large.

For more specific answers, please ask more specific questions.

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