Re: Insert Query taking ages....

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kan Grewal (k.grewal_at_virgin.net)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 12:51:34 +0100

Absolutely - I've checked SQL Agent jobs and Windows scheduled tasks and
there's nothing

k.

"Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
news:eGq0YSvoEHA.1576@TK2MSFTNGP12.phx.gbl...
> Are you sure no other processes are running?
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
>
> "Kan Grewal" <k.grewal@virgin.net> wrote in message
> news:uHboKGvoEHA.644@tk2msftngp13.phx.gbl...
>> Additional information:
>>
>> I can't seem to create any tables at this point either - I run a create
>> table command in query analyser and it also just sits there for ages....
>>
>> k.
>>
>> "Kan Grewal" <k.grewal@virgin.net> wrote in message
>> news:eKF1l$uoEHA.3668@TK2MSFTNGP15.phx.gbl...
>> > The only lock on that table appears when I run that command.
>> >
>> > I have a clustered index on login_date.
>> >
>> > This is confusing the hell out of me!
>> >
>> > k.
>> >
>> > "Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
>> > news:%23%23lj3QuoEHA.1800@TK2MSFTNGP15.phx.gbl...
>> >> Some other process might be blocking the table.
>> >>
>> >> Try running sp_who2 and sp_lock when you face the problem.
>> >> Do you have an index on the table?
>> >>
>> >>
>> >> --
>> >> Roji. P. Thomas
>> >> Net Asset Management
>> >> https://www.netassetmanagement.com
>> >>
>> >>
>> >> "Kan Grewal" <k.grewal@virgin.net> wrote in message
>> >> news:endyxIuoEHA.3668@TK2MSFTNGP15.phx.gbl...
>> >>> I have a very simple table:
>> >>> username - varchar(10)
>> >>> login_date - datetime
>> >>>
>> >>> The problem I'm having is that every so often an insert query into
> this
>> >>> table is taking ages to complete:
>> >>> insert into login (username, login_date)
>> >>> values ('test', getdate(())
>> >>>
>> >>> Usually it takes less than a second to complete but then every so
> often,
>> >> it
>> >>> takes almost 2 minutes to complete.
>> >>>
>> >>> I'm running this from an asp web page, and it therefore timesout. If
> I
>> >> then
>> >>> run it in query analyser, wait the 2 minutes, it's fine after that.
>> >>>
>> >>> I've run virus checks and stuff but that's come out ok.
>> >>>
>> >>> I'm stumped - any suggestions?
>> >>>
>> >>> Oh yeah, it's SQLServer2000 sp3 on a windows 2003 server.
>> >>>
>> >>> Cheers,
>> >>>
>> >>> Kan
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>>
>
>