my little problem become a BIG problem....

Hi,
I've just posted some memory and performance problems...
but after my last reboot I've a big problem !
If I work remotly on the server a query takes 44 seconds to be completed and
return 155008 rows.
To view the estimated plan, less then 1 second is requiered.
But If I do the same job on the server himself, after 4minutes the result is
not display, and the estimated plan takes 12 seconds!!!
All the local access to SQL Server are very slow, but all the network access
are very good.
any idea'
Jerome.
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 2004-02-09Could perhaps ODBC tracing be turned on at the server?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jéjé" <willgart@._A_hAotmail_A_.com> wrote in message
news:eziZJeW9DHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've just posted some memory and performance problems...
> but after my last reboot I've a big problem !
> If I work remotly on the server a query takes 44 seconds to be completed
and
> return 155008 rows.
> To view the estimated plan, less then 1 second is requiered.
> But If I do the same job on the server himself, after 4minutes the result
is
> not display, and the estimated plan takes 12 seconds!!!
> All the local access to SQL Server are very slow, but all the network
access
> are very good.
> any idea'
> Jerome.
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.581 / Virus Database: 368 - Release Date: 2004-02-09
>|||yeah...
I've just found that this option is running!
ggrrrr
loosing time for a small option...
there is no popup to inform that the performance will be degradated when
this option is checked.
thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit
dans le message de news:uJfTxuW9DHA.2696@.TK2MSFTNGP10.phx.gbl...
> Could perhaps ODBC tracing be turned on at the server?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Jéjé" <willgart@._A_hAotmail_A_.com> wrote in message
> news:eziZJeW9DHA.1424@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've just posted some memory and performance problems...
> >
> > but after my last reboot I've a big problem !
> > If I work remotly on the server a query takes 44 seconds to be completed
> and
> > return 155008 rows.
> > To view the estimated plan, less then 1 second is requiered.
> >
> > But If I do the same job on the server himself, after 4minutes the
result
> is
> > not display, and the estimated plan takes 12 seconds!!!
> >
> > All the local access to SQL Server are very slow, but all the network
> access
> > are very good.
> >
> > any idea'
> >
> > Jerome.
> >
> >
> >
> > --
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.581 / Virus Database: 368 - Release Date: 2004-02-09
> >
> >
>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 2004-02-09