Re: Insert Query taking ages....

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 17:14:05 +0530

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
> >>>
> >>>
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: DISTINCT and LEFT JOIN problem
    ... P. Thomas ... >>> Roji. ... >>> Net Asset Management ... >>>>> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
  • Re: searching with varying parameters
    ... "Roji. ... P. Thomas" wrote in message ... > Net Asset Management ... >> body, Search by attachment name, search if message has attachments). ...
    (microsoft.public.sqlserver.programming)
  • Re: How to concat the values in a column across rows.
    ... P. Thomas ... "Colin Halliday" wrote in message ... >> Roji. ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: Output parameters
    ... > Set CmdParams = Nothing ... > "Roji. ... P. Thomas" wrote in message ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic table name in query
    ... "Roji. ... P. Thomas" wrote in message ... >> Dynamic SQL, you could just explain your position or at least write the ... >>> You are trying to write a procedure without any cohesion at all. ...
    (microsoft.public.sqlserver.programming)