s
Contact Login Register
h M

SQL Server Performance Situations - Full Table Scans

SQL Server Full Table Scans - Key SQL Performance Situations to Watch Out For

Have you ever opened up a really big book lately?  Let’s say someone handed you a copy ofWar and Peace by Tolstoy and told you that there was an interesting phrase found on page 435.  How would you go about looking up that page?  Would you start at the beginning of the book, turning page after page, one at a time looking for page 435?  Would you start at the back of the book and do the same?  The most common answer to that is “Who’s Tolstoy?” but following at a close second place is “No way?  What are you… stupid or something?  Why would anyone do that?”  The most common way people would go about finding that page number would be to start in the middle.
Thursday, October 10, 2013/Author: Chad Nash/Number of views (10567)/Comments (-)/ Article rating: 5.0
Tags:

SQL Server Performance Situations - Expressions

When SQL Server has to perform calculations on both sides of a comparison operator within a Where clause, then this criteria cannot be considered when evaluating the usage of indexes. SQL Server must try to use other criteria within the query to figure out which indexes to use, and if there are none, the query processor will scan all of the rows in the table, evaluating these expressions one row at a time, in order to determine which rows to process or return.
Thursday, October 10, 2013/Author: Chad Nash/Number of views (2195)/Comments (-)/ Article rating: No rating
Tags:

SQL Server Blocking - Key SQL Performance Situations to Watch Out For

Key SQL Performance Situations to Watch Out For - Part One of Three

SQL Server is a very deep, robust software package, as are most enterprise class DBMS applications.  There are many areas of functionality that work very well and are self tuning.  However, with that much functionality at the disposal of the developer community, there are also many ways that features can be overused, misused, or abused.  That being stated, there isn’t enough time with a single article to cover every possible conceivable performance situation that could arise.  So, this article will attempt to focus on 3 of the most common SQL performance related issues that one will encounter in heavily loaded applications. 
Thursday, October 10, 2013/Author: Chad Nash/Number of views (5604)/Comments (-)/ Article rating: 5.0
Tags:

Microsoft SQL Server -Determining Query Performance Metrics...

Determining Query Performance Metrics

The performance of an application can be influenced by many things.  Hardware constraints such as lack of memory or slow disk sub system can be just as detrimental as application inefficiency.    However, in many situations the first is caused by second.  An inefficient application can be cheaper and easier to fix in the long run, then creating server farms or buying huge, super-beefy equipment and paying lots of people to keep it up and running.  (Not to mention increasing the payment for the electric bill, insurance, network infrastructure, power supplies, etc.)
Thursday, October 10, 2013/Author: Chad Nash/Number of views (4244)/Comments (-)/ Article rating: No rating
Tags:

SQL server 2008 Profiler and Tuning Wizard

SQL Server 2008 Profiler

SQL Server Profiler is one of the performance tools that are available in the SQL Server 2008. But this tool has been mostly under utilized by the Database Administartors. The SQL Server Profiler does various functions like:
Thursday, October 10, 2013/Author: Chad Nash/Number of views (12436)/Comments (-)/ Article rating: 3.3
Tags:
RSS
123

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

  
Subscribe