|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Slow Query analyzer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Slow Query analyzer
|
|
| Zen S. 2002-06-28, 10:25 pm |
| Hi,
I'm having trouble with a performance of query analyzer.
It takes 20 to 40 seconds to execute a simple query.
Any sugestion how to solve this will be greatly
apprecieated. I,m learning SQL.
Thanks much.
| |
| Tom Moreau 2002-06-29, 7:25 am |
| I've not heard of QA being slow. Rather, it is likely that the query is
slow. Do you get the same performance when the query is run through osql?
Perhaps you can show us your DDL - including indexes and keys - and the
query.
--
Tom
----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Zen S. wrote in message < 139b501c21f1d$149ea890$3aef2ec
f@TKMSFTNGXA09>...
Hi,
I'm having trouble with a performance of query analyzer.
It takes 20 to 40 seconds to execute a simple query.
Any sugestion how to solve this will be greatly
apprecieated. I,m learning SQL.
Thanks much.
| |
| Zen S. 2002-06-30, 12:25 am |
| Hello Tom,
I've just installed Enterprise edition and tryed to play
with Northwind database, that's all. If you have any
sugestions, let me know. Thank you.
>-----Original Message-----
>I've not heard of QA being slow. Rather, it is likely
that the query is
>slow. Do you get the same performance when the query is
run through osql?
>Perhaps you can show us your DDL - including indexes and
keys - and the
>query.
>
>--
> Tom
>
>----------------------------------------------------------
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
>SQL Server MVP
>Columnist, SQL Server Professional
>
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>www.apress.com
>---
>Zen S. wrote in message <139b501c21f1d$149ea890
$3aef2ecf@TKMSFTNGXA09>...
>Hi,
>I'm having trouble with a performance of query analyzer.
>It takes 20 to 40 seconds to execute a simple query.
>Any sugestion how to solve this will be greatly
>apprecieated. I,m learning SQL.
>Thanks much.
>
>
>.
>
| |
| 2lazybutsmart 2002-06-30, 7:18 am |
| seems like ur running a query with complecated joins. or your database fragramentation level is high.
can u show me the query ur running. |
|
|
|
|