Give me a strong Solution?

Question

Give me a strong Solution?

Saravanan_tvr

SSCarpal Tunnel

Points: 4558
More actions
May 4, 2009 at 6:35 am

#209085

I am a sql-developer..for Proc.trigger,cursor, etc...
But I need to know What is performance tuning?
how can we tune database and how can we find the Poor or good?
I need step by step...tuning process
Please Tell me...
Thanks in advance

Viewing 11 posts - 1 through 10 (of 10 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

There are books on the subject that will get you off to a very good start. Check out the Books section on this site. Also check Red Gate's site. Microsoft Press has some really good ones too.

- 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

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

The Inside SQL Server series, specifically the book on performance tuning could help you. I'd like to recommend my book as well, in the link below.

"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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

Everyone say it with me... G-O-O-G-L-E 😉

http://www.google.com/search?hl=en&q=what+is+performance+tuning+sql+server&btnG=Google+Search&aq=f&oq=

On a different note, I would also recommend Grant's book.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 4

Thanks for reply ...

I am not asking the books.. I need some basic ideas

Why we are going this performance and when we need this performance tools...

When i getting this points answers..

then i can easily to move that book..

arun.sas SSChampion Points: 11831 More actions · Answer 5

viswa (5/4/2009)
Thanks for reply ...
I am not asking the books.. I need some basic ideas
Why we are going this performance and when we need this performance tools...
When i getting this points answers..
then i can easily to move that book..

Hi,

For the end user the performance is speed of getting the records,

For the DBA the performance is DB size and the memory catch,

For the programmer like you, it’s the both of above.

Any thing above get feel worse it’s related to performance, performance is quality of the application.

The mentioned book and links tells to identify and fix these issues.

ARUN SAS

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 6

The basic idea is to allow the optimizer to do it's job using properly written set based code. You do that by avoiding cursors and while loops in 99.99% of the cases, avoid unneccessary UDF's, avoid some bad forms of correlated sub-queries and views, and avoid the creation of unneccessary internal row generation by using "Divide'n'Conquer" methods to decrease the size of monster joins.

That being said, the next step would be to do the Google search I recommended and start reading about some of the basic ideas you asked for. Seriously.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

Oh... and my definition of "Performance Tuning" is one of two things... either writing code to let the optimizer do its job, or rewriting someone else's code to let the optimizer do its job.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 8

Saravanan_tvr

SSCarpal Tunnel

Points: 4558

May 5, 2009 at 1:01 am

#988573

VERY VERY THANKS JEFF.....

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

These might help you a bit. They're purely on indexing, not rewriting bad code.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

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

GSquared SSC Guru Points: 260824 More actions · Answer 10

viswa (5/4/2009)
Thanks for reply ...
I am not asking the books.. I need some basic ideas
Why we are going this performance and when we need this performance tools...
When i getting this points answers..
then i can easily to move that book..

Performance tuning isn't something you learn by reading a couple of posts on a web page. The reason I started out by suggesting books, is that it's a large subject with a lot of factors in it, and it takes some work to learn it.

If what you want is just the 1-minute version, then just look up "performance" in a dictionary, and "tuning", and you'll get the basic idea. It means exactly what the dictionary says, nothing more, nothing less, nothing else.

It takes some work to get good at something. If you don't want to do the work, then you don't want to be good at the thing. If you don't want to be good at it, why bother with it in the first place?

- 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