Site Sections
Posts
53
Comments
71
Trackbacks
27
<< Introduction | Home | inherent flaw with IEEE's representation of decimals >>
Nice list of SQL Performance Articles

SQL performance has been a big focus of mine lately.  Too often you find sql that someone tested in a lab and shipped it, without ever running it against production data and checking the query plan and read count.  Once it starts running against millions of rows, it times out.  Then it often ends up on my desk to rewrite.   A friend of mine, Dave Roberts, is one of those I rely on when I get stuck.  He shared with me the following list of articles, mostly from msdn, which will aid you on your quest for faster running queries.  This is a good list to keep handy.  They are the kind of articles you run across, but can never find them again when you really need them.  If nothing else, they will help you out if you are having trouble falling to sleep one night. 

nQuery Analysis
lhttp://www.sql-server-performance.com/statistics_io_time.asp 
lhttp://www.sql-server-performance.com/query_analysis_tuning.asp
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_536v.asp
lhttp://support.microsoft.com/default.aspx?scid=kb;en-us;167610
nTroubleshooting
lhttp://support.microsoft.com/default.aspx?scid=kb;en-us;224587
nStatistics
lhttp://support.microsoft.com/kb/q195565/
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp
nBlocking
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_7a_5ovi.asp
lhttp://support.microsoft.com/default.aspx?scid=kb;en-us;224453
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_7a_7xde.asp
nFragmentation
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_46cn.asp
nTable Variables
lhttp://support.microsoft.com/default.aspx?scid=kb;en-us;305977
nQuery Recompilation
lhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp
posted on Wednesday, May 11, 2005 10:17 PM Print
Comments
Gravatar
# re: Nice list of SQL Performance Articles
Vijay shankar ganesh K
5/12/2005 2:10 AM
Thanks for the list jhon, it will be a real lifesaver for people in tight corners. Have a nice day.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 3 and 7 and type the answer here:
Archives
Post Categories
Blogs
Development Resource
SQL
XML
News
Xobni outlook add-in for your inbox
Twitter