Re: How to make a SQL run longer?


"Raj" <jkamaraj@xxxxxxxxx> schreef in bericht
news:1182968186.181731.177720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hell All,
To reproduce one of our cusotmer's probem, I need to make the SQL to
run for more than a minutes before it returns the result set. I do not
have large amount of data in the database to simulate the dealy.

Is there a way in SQL to cause the delay while returning the result
set

Thanks for the help.

Regards
Raj


maybe you should tell us WHY you need a delay, because most in the eyes of
most people a SQL-server must be fast, so no DELAY's....

I hink when you do give that information, there might be another way to
solve your problem.

regards,
Luuk


.

Relevant Pages

  • Re: Indexing delay for one row.
    ... script and WAITFOR and varying the delay from 1 to 18 seconds. ... could you confirm your exact version of SQL Server that you are seeing ... It is possible that a change was made to the pooling frequence under SP3 to ... exec sp_fulltext_table 'FTSTable','create','FTSCatalog','FTSTable_IDX' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... Is there a way in SQL to cause the delay while returning the result ...
    (comp.databases.oracle.server)
  • Re: SQL access very slow in Paradox 9 HELP!
    ... the 200 m/s delay that now exists by default under Windows 2003. ... other than being slightly slow due to the nature of the SQL box also being ... a File / Print server. ... This box is Windows 2000. ...
    (comp.databases.paradox)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... Is there a way in SQL to cause the delay while returning the result ...
    (comp.databases.oracle.server)
  • Re: Are Population Schedules required?
    ... Historically in SQL 2000, populations could impact querying so you may have wanted to do delay the population. ... So, just for my edification, what are population schedules for? ...
    (microsoft.public.sqlserver.fulltext)