Need Performance Tuning books tips

Question

Post reply

Need Performance Tuning books tips

ricfors

Say Hey Kid

Points: 665
More actions
June 30, 2008 at 8:21 am

#193931

Hi,
I want to get started with performance tuning. I want to know what tools there are within sql2005 that can be used and what the different data means, and how to read the output from those tools.
E.g. what sql is consuming most CPU?, what sql is most I/O intense?, what is blocking what?, etc.
These are some of the questions I want to be able to look up when having performance issues.
Do you have any tips on good resources on the web and/or good books that can help me on the way?
Thanks a lot
ricfors

Viewing 6 posts - 1 through 5 (of 5 total)

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

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 1

Hi,

Get a free book from http://www.devx.com/RedGateVS/Door/37329

http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx

http://www.sql-server-performance.com/tips/performance_monitor_general_p1.aspx

http://www.windowsitlibrary.com/Content/77/15/1.html

http://www.mssqltips.com/tip.asp?tip=1265

http://whitepapers.zdnet.com/abstract.aspx?docid=337037

http://sql-server-performance.com/articles/per/System_Monitor_Hardware_Bottlenecks%20_p1.aspx

http://sql-server-performance.com/articles/per/sys_dm_os_performance_counters_p1.aspx

regards,

Ahmed

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

In addition to that list of links, which is pretty good, I'd just say to get very familiar with Profiler. One of the best books you can get is "Inside SQL Server 2005 TSQL Querying" although it doesn't explicitly address performance tuning. It just talks about the best way to write queries.

"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

ricfors Say Hey Kid Points: 665 More actions · Answer 3

Ahmed Bouzamondo (6/30/2008)
Hi,
http://www.sql-server-performance.com/tips/performance_monitor_general_p1.aspx

Thanks Ahmed!

This link was exactly what I was looking for. Especially the correlation between spid and thread ID.

I will save all these links so I can return to them whenever I need to.

Thanks everybody else for helping me out!

ricfors

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

The entire Inside SQL Server series is excellent. There are four books - the storage engine, T-SQL querying, T-SQL procgramming and Query tuning and optimisation.

The other one I'll recomend was written for SQL 2000, but is still a good book - SQL Server Query Performacne Tuning Distilled by Sajal Dam

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

Look for 2 word documents from microsoft: sql 2005 troubleshooting performance problems and sql 2005 performance tuning waits and queues

Also, I really found a lot of good stuff in "SQL Server 2005 Performance Tuning" from WROX press.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service