Guys,
what I need is a tool which gives details on the choice of an
execution plan by the SQL Server. For example, the cost for a hash
join might be 200 and 100 for a nested loop, and therefore a nested
loop is used. Same thing for the access paths for each table/view
involved. In Oracle, we turn on event 100053 to see this kind of info.
Thanx
Daniel 2 1728
"Daniel Roy" <da************ *@hotmail.com> wrote in message
news:37******** *************** *@posting.googl e.com... Guys, what I need is a tool which gives details on the choice of an execution plan by the SQL Server. For example, the cost for a hash join might be 200 and 100 for a nested loop, and therefore a nested loop is used. Same thing for the access paths for each table/view involved. In Oracle, we turn on event 100053 to see this kind of info.
Thanx
Daniel
There's no real equivalent in MSSQL - you can see the plan that optimizer
selected, not the logic it used to arrive at that plan. Query Analyzer can
display the cost of each step in the plan, and how many rows were affected,
either after the query runs or before (by asking for an estimated plan).
This is more or less a graphical presentation of the SET SHOWPLAN_ALL ON
output.
Simon
> There's no real equivalent in MSSQL - you can see the plan that optimizer selected, not the logic it used to arrive at that plan. Query Analyzer can display the cost of each step in the plan, and how many rows were affected, either after the query runs or before (by asking for an estimated plan). This is more or less a graphical presentation of the SET SHOWPLAN_ALL ON output.
Isn't there ANY other way to understand the optimizer's logic in
choosing a specific execution plan as opposed to another one?
Daniel This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Fotios |
last post by:
Hi guys,
I have put together a flexible client-side user agent detector (written in
js). I thought that some of you may find it useful. Code is here:
http://fotios.cc/software/ua_detect.htm
The detector requires javascript 1.0 to work. This translates to netscape
2.0 and IE 3.0 (although maybe IE 2.0 also works with it)
|
by: cody |
last post by:
is there any tool which can optimize msil? for example:
if (a is MyType)
{
MyType mt = (MyType)a
}
could turn into:
MyType mt = mt as MyType ;
|
by: Bupp Phillips |
last post by:
I have a customer table that has the field CUSTOMER_ID as the primary key
(cust_pkkey), the table has 102,834 records in it.
The following select statement works fine:
select * from customer order by customer_id;
QUERY PLAN:
Index Scan using cust_pkkey on customer (cost=0.00..5175.17 rows=102834
width=724)
|
by: deepukutty |
last post by:
Hi all,
I know tht we can do tracing in two ways.one in application level and the
other is at Page level.
I am able to see the details of trace either on the page itself or
.../trace.axd page.
I want to use maximum out of the available trace details .
or
let me put it like this....
tell me the actual scenario's where these trace details will be use ful and
|
by: Tim Mavers |
last post by:
Is there an easy way to turn on soap tracing of some sort for a web service?
We have built a web service (in production) that is experiencing problems
for a client. Is there an easy way we could enable some sort of tracing so
we could view the entire HTTP request (and payload)?
I would prefer not to have to recompiling our own home-grown tracing code
into the app because it is hard to deploy.
Does .NET support this internally?
| |
by: EdgarSanchez |
last post by:
Hello Group,
This mail is intended to announce the release of the newest version of SpeedTrace .NET Tracing & Profiling tool, SpeedTrace Pro. This tool is an improvement of the previous version that was launched in this group last year.
SpeedTrace Pro has come up with the following new features:
· Support .NET Framework 2.0 (Windows applications, ASP.NET, Windows .NET Services)
· Improved Fast Engine(increased trace...
|
by: magennisw |
last post by:
Our three tier web application is "pausing" under test loading (IIS 6.0
(win2003) -> Web services (win2003) -> SQL server) . The CPU usage on
the W3WP.exe on both the web server and middle tier drops to zero for
about 5 seconds then springs back into life. Nothing in the NT event
logs. No SQL database blocking.
I suspect it is a particular web service call. With SQL server I can
start a "trace" and get a list of all SQL calls (and their...
|
by: fiona |
last post by:
FOR IMMEDIATE RELEASE
Catalyst release low cost logic processing tool
87% of defects in software are errors in logic
Yucca Valley, CA, September 2006 - Catalyst Development Corporation,
publisher of SocketWrench and SocketTools, today announced the release
of its first application software, a logic processing software tool.
LogicGem is designed to provide a familiar, easy-to-use way to create,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |