Navigation

Search

Site Content

Syndicate

Home

Performance Tuning

SQL Server Myths

Wed, 11/12/2008 - 17:02 |  sqlguychuck
0
Your rating: None

The PSS Team blog (Bob Dorr wrote article) has a great discussion on a couple of common myths for SQL Server performance:

  • SQL Server Uses One Thread Per Data File
  • A Disk Queue Length greater than 2 indicates an I/O bottleneck

 http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Summary notes from article:

Read more
Tags: Performance Tuning, SQL 2005 DBA

Excellent intro to reading execution plans

Sat, 11/08/2008 - 11:40 |  sqlguychuck
0
Your rating: None

Grant wrote an excellent introductory article on execution plan basics and has a more detailed ebook for sale on lulu.com. http://www.simple-talk.com/sql/performance/execution-plan-basics. Code listing link.

Read more
Tags: Performance Tuning

TCP Optimization for Windows

Fri, 08/29/2008 - 18:55 |  sqlguychuck
0
Your rating: None

 

Your NIC card configuration settings maybe the cause of slow file copies over your wide area network (WAN). Also, know that Windows Explorer file copy is designed to throttle its network usage, so use Robocopy, Richcopy, FTP, etc instead.

 

Read more
1 attachment |  Tags: Performance Tuning, SQL 2005 DBA

Best practices for Troubleshooting Slow Running Queries

Fri, 05/09/2008 - 14:40 |  sqlguychuck
5
Your rating: None Average: 5 (1 vote)

MS SQL Community Worldwide has a great summary article on best practices on troubleshooting performance with sql queries including links to other great articles on the subject.

Tags: Performance Tuning, SQL 2005 DBA

SQL Performance

Sun, 01/06/2008 - 12:51 |  sqlguychuck
0
Your rating: None

Best Practices Information for SQL Server Performance

 External Articles on Server Performance

Read more
Tags: Performance Tuning, SQL 2005 DBA

SQL Pagination Optimization with CTEs

Thu, 12/27/2007 - 12:32 |  sqlguychuck
0
Your rating: None

Since many of us write sql code for websites, I thought I would share this performance tip I found while improving a proc to get list with start and end positions using row numbers - what I am calling pagination. 

Read more
Tags: Performance Tuning, SQL 2005 Dev

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2010 SQLWebpedia. All Rights Reserved.

Creative Commons License
This work by Chuck Lathrope is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Disclaimer for all content: No warranty is expressed or implied by the authors' or owner's of this website or content linked externally. Use at your own risk.