Re: Procedure output

Some questions to help clarify things:
-- when the query is running slower, is SQL on the same machine as the first
test, or a different machine / instance?
-- if it's on a separate machine, what else is installed and running on that
machine, and what are the specs;
-- if you're running against the same instance of SQL Server in both cases,
have you checked current activity in SQL or the OS to see what else is
happening;
-- did you change any parameters to the SP when you ran it the second time

David

"Rogers" <rogers@xxxxxxxxxxx> wrote in message
news:ed8YJssaGHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
I have a sql server installed on my machine and when I run the stored
procedure it gave me the result in 1 min but when I run the same stored
procedure in to different box it gave me the result in 20 min and that
machine has a higher configuration of mine machine, can any one guide me
which options i have to check for the SQL Server 2000 ?

Thanks in advance




.

Relevant Pages

  • Re: ntext getting truncated
    ... Tibor Karaszi, SQL Server MVP ... I applied the query as follows: ... select counthowmany, datalengthntextlength ...
    (microsoft.public.sqlserver.programming)
  • Re: upsizing to sql 2005
    ... which include MS SQL Server linked table. ... Query Name: Arcadia - ARC ... are still unable to upsize one of these queries, ...
    (microsoft.public.access.queries)
  • Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
    ... I am using an Access update query, with parameters, for the ... Then my app goes against a SQL ... OleDbDataAdapter that I use to retrieve the original table from the ... So your named parameters for SQL Server suddenly become anonymous ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: upsizing to sql 2005
    ... A query in Access-Jet will be started and under the supervision of Jet, ... Jet syntax parsing and evaluation. ... so, in this case, into MS SQL Server. ...
    (microsoft.public.access.queries)
  • [REVS] SQL Injection Walkthrough
    ... problems facing them while trying to utilize SQL Injection techniques, ... Many web pages take parameters from web user, and make SQL query to ... MS SQL server ignore the rest of the query, which will get rid of the last ... Microsoft OLE DB Provider for ODBC Drivers error '80040e07' ...
    (Securiteam)
Loading