Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

2773 Results Found

ARTICLE

Obtaining Query Execution Plans Through SQL Profiler Traces

... up talking about using execution plans to aid in the optimization of those stored procedures ... aware that you can obtain execution plans through Query Analyzer. What most of the clients do ... utilize SQL Profiler to obtain the execution plans of queries running on a particular system. The problem is once ...

ARTICLE

Displaying Execution Plans

... I published an article describing a basic plan to use when optimizing existing or newly created queries. After a brief discussion with the publishers at www.SQLServerCentral.Com ... articles on optimizing and tuning Transact-SQL queries. The plan for this series is to start with the basics of execution plans, progress to advanced execution plan topics and finish up with articles on other ... procedures. You can review the brief query tuning plan article on my website at www.TransactSQL.Com to get a sense of the game plan for this series of articles. It is also my intention ...

ARTICLE

Inside the Optimizer: Constructing a Plan - Part 2

... how the optimizer builds up an executable query plan using rules. To illustrate the process performed ... we'll configure it to produce incrementally better plans by progressively applying its internal exploration ... can read about the basics of how a plan is conrtucted in Part 1. Part Two - Producing the Fully-Optimized Plan As a reminder, here is the sample query we are optimizing: Part One ended with this partially-optimized plan: The optimizer has pushed the predicate "ProductNumber ...

ARTICLE

Searching for Plans

... set up to give you the best plan.  Instead, it is set up to give you a good enough plan quickly (where good enough is very ... Why spend 4 hours optimizing a query that runs in 2 minutes to get it down ... two minutes. If the optimizer looked for the best plan, I'd be very angry as a customer. Especially ...

ARTICLE

Real World Query Plans

... help troubleshoot. We got there and found a query that normally returns in a few seconds but was taking ... join, 3 left joins really, the query normally runs with 7000 reads. So we fire up query analyzer and check the server. We see ... normally easily handles the load. But today the queries are slow, the average CPU% is 95%, and nothing ...

ARTICLE

Understanding Execution Plans Part 1

Understanding Execution Plans  Introduction   The purpose of this article is to give you ... working knowledge of how to view and understand query execution plans for SQL Server.This is part 1 in a series ... walk you through understanding execution plans to help you improve your queries.Throughout ...

ARTICLE

Execution Plans

... Server, I was not using the “Show Execution Plan” properly to analyse the query. I always thought that when I compose a query, it is the best it can be; I never even think of performance on my query and I did not give much importance to looking at the “Execution Plan” on my query.  In the initial days of my career, I ... returned to me and what sort of “Execution Plan” was used on the query. I presumed SQL Server would handle the query performance. I think it is the nature for software ... day, my customer was not happy with the performance on the query using the application. He has come ...

ARTICLE

Exporting Execution Plans - SQL Spackle

... come a time when performance (specifically that of a query) is less than stellar.  When that happens ... what the problematic code is doing, the execution plan needs to be exported and posted someplace so ... who will be providing their services.  Exporting an execution plan is a short and simple exercise that I will explain ...

ARTICLE

Inside the Optimizer: Constructing a Plan - Part 3

... how the optimizer builds up an executable query plan using rules. To illustrate the process performed ... we'll configure it to produce incrementally better plans by progressively applying its internal exploration ... Part 2 of this series to understand how a plan is constructed. Part Three - Identifying the Rules ...

ARTICLE

SQL Server Execution Plans, Second Edition by Grant Fritchey

... Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same ... questions come up repeatedly: Why is this query running slowly? Why is SQL Server ... ignoring my index? Why does this query run quickly sometimes and slowly at others ...