|
|
You're in the
sql server msde
group:Timeout
sql server msde:
4MB is very small database size.
The problem might be poor database design or query. Make sure proper index are on table. Look at the locks in more detail , use profiler to find other activity on the database when you are facing this problem. Regards Amish Shah http://shahamishm.tripod.com [quoted text, click to view] Uri Dimant wrote:
> Hi > > Do you have an index on id column? > Do you have trigger/s on tmarcid table? > Do you have another table define in cascade delete to tmarcid table? > > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... > > Hi > > > > What can cause "Timeout expired" on deleting only one row? > > > > delete from tmarcid where id=3423 > > this happens not every time, same problem with update. > > > > > > SQL 2000,Windows XP, all SP's installed. > > > > DB size is only 4MB > > Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. > > > > > > Regards; > > Meelis > > > >
Hi,
Do you have an Index in column ID. otherwise a tablescan can happen while you delete and cause a time out. As well as take a look if there is any FK relationship. If you have a FK relation ship ensure that partcular table is also indexed based on ID. Thanks Hari [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... > Hi > > What can cause "Timeout expired" on deleting only one row? > > delete from tmarcid where id=3423 > this happens not every time, same problem with update. > > > SQL 2000,Windows XP, all SP's installed. > > DB size is only 4MB > Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. > > > Regards; > Meelis > >
[quoted text, click to view]
Meelis Lilbok wrote: > Hi > > What can cause "Timeout expired" on deleting only one row? > > delete from tmarcid where id=3423 > this happens not every time, same problem with update. > > > SQL 2000,Windows XP, all SP's installed. > > DB size is only 4MB > Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. > > > Regards; > Meelis > > Where are you seeing this timeout, in a client application or Query Analyzer? Quite likely, something is blocking your UPDATE/DELETE statement - check sp_who2 to check for blocking. Without proper indexes, deleting even one row can require a table scan, which is highly vulnerable to being blocked. -- Tracy McKibben MCDBA
Hi
What can cause "Timeout expired" on deleting only one row? delete from tmarcid where id=3423 this happens not every time, same problem with update. SQL 2000,Windows XP, all SP's installed. DB size is only 4MB Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. Regards; Meelis
Hi
Do you have an index on id column? Do you have trigger/s on tmarcid table? Do you have another table define in cascade delete to tmarcid table? [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... > Hi > > What can cause "Timeout expired" on deleting only one row? > > delete from tmarcid where id=3423 > this happens not every time, same problem with update. > > > SQL 2000,Windows XP, all SP's installed. > > DB size is only 4MB > Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. > > > Regards; > Meelis > >
[quoted text, click to view]
> Nope> Do you have an index on id column? ID is PK > Do you have trigger/s on tmarcid table? Nope > Do you have another table define in cascade delete to tmarcid table? strange is, with other clients, with bigger db's this error happens only once in a year :) meelis [quoted text, click to view] > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >> Hi >> >> What can cause "Timeout expired" on deleting only one row? >> >> delete from tmarcid where id=3423 >> this happens not every time, same problem with update. >> >> >> SQL 2000,Windows XP, all SP's installed. >> >> DB size is only 4MB >> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >> >> >> Regards; >> Meelis >> >> > >
I think this client has problems with network
M. [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:uTlGDvzLHHA.1248@TK2MSFTNGP03.phx.gbl... > Hi > > Do you have an index on id column? > Do you have trigger/s on tmarcid table? > Do you have another table define in cascade delete to tmarcid table? > > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >> Hi >> >> What can cause "Timeout expired" on deleting only one row? >> >> delete from tmarcid where id=3423 >> this happens not every time, same problem with update. >> >> >> SQL 2000,Windows XP, all SP's installed. >> >> DB size is only 4MB >> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >> >> >> Regards; >> Meelis >> >> > >
[quoted text, click to view]
Meelis Lilbok wrote: > Hi > > Im still having problem with this timeout :( > > a) Indexes are ok > b) No triggers > > With other clients using database with same conf. all works fine > What does the execution plan for the query look like? Where is it spending the time? -- Tracy McKibben MCDBA
Hi
Im still having problem with this timeout :( a) Indexes are ok b) No triggers With other clients using database with same conf. all works fine Meelis [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... > Hi > > What can cause "Timeout expired" on deleting only one row? > > delete from tmarcid where id=3423 > this happens not every time, same problem with update. > > > SQL 2000,Windows XP, all SP's installed. > > DB size is only 4MB > Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. > > > Regards; > Meelis > >
and
sp_who2 does not show anu block or lock problems Meelis [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:uUP2gH$LHHA.4384@TK2MSFTNGP03.phx.gbl... > Hi > > Im still having problem with this timeout :( > > a) Indexes are ok > b) No triggers > > With other clients using database with same conf. all works fine > > > Meelis > > > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >> Hi >> >> What can cause "Timeout expired" on deleting only one row? >> >> delete from tmarcid where id=3423 >> this happens not every time, same problem with update. >> >> >> SQL 2000,Windows XP, all SP's installed. >> >> DB size is only 4MB >> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >> >> >> Regards; >> Meelis >> >> > >
Perhaps LOG file is growing and users get the eeror.
Have you checked any enties in the ERRROL.LOG file? [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:ewfIZI$LHHA.4928@TK2MSFTNGP06.phx.gbl... > and > sp_who2 does not show anu block or lock problems > > Meelis > > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:uUP2gH$LHHA.4384@TK2MSFTNGP03.phx.gbl... >> Hi >> >> Im still having problem with this timeout :( >> >> a) Indexes are ok >> b) No triggers >> >> With other clients using database with same conf. all works fine >> >> >> Meelis >> >> >> >> >> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >> news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >>> Hi >>> >>> What can cause "Timeout expired" on deleting only one row? >>> >>> delete from tmarcid where id=3423 >>> this happens not every time, same problem with update. >>> >>> >>> SQL 2000,Windows XP, all SP's installed. >>> >>> DB size is only 4MB >>> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >>> >>> >>> Regards; >>> Meelis >>> >>> >> >> > >
no problems with log file (its only 1MB, db size 24mb)
nothing in error.log file M. [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:OwcSLU$LHHA.4376@TK2MSFTNGP03.phx.gbl... > Perhaps LOG file is growing and users get the eeror. > > Have you checked any enties in the ERRROL.LOG file? > > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:ewfIZI$LHHA.4928@TK2MSFTNGP06.phx.gbl... >> and >> sp_who2 does not show anu block or lock problems >> >> Meelis >> >> >> >> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >> news:uUP2gH$LHHA.4384@TK2MSFTNGP03.phx.gbl... >>> Hi >>> >>> Im still having problem with this timeout :( >>> >>> a) Indexes are ok >>> b) No triggers >>> >>> With other clients using database with same conf. all works fine >>> >>> >>> Meelis >>> >>> >>> >>> >>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>> news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >>>> Hi >>>> >>>> What can cause "Timeout expired" on deleting only one row? >>>> >>>> delete from tmarcid where id=3423 >>>> this happens not every time, same problem with update. >>>> >>>> >>>> SQL 2000,Windows XP, all SP's installed. >>>> >>>> DB size is only 4MB >>>> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >>>> >>>> >>>> Regards; >>>> Meelis >>>> >>>> >>> >>> >> >> > >
Meelis
I have no idea why it is happened. Do you have a last service pack installed on SQL Server? [quoted text, click to view] "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message news:unJaGY$LHHA.3556@TK2MSFTNGP03.phx.gbl... > no problems with log file (its only 1MB, db size 24mb) > nothing in error.log file > > > > M. > > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:OwcSLU$LHHA.4376@TK2MSFTNGP03.phx.gbl... >> Perhaps LOG file is growing and users get the eeror. >> >> Have you checked any enties in the ERRROL.LOG file? >> >> >> >> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >> news:ewfIZI$LHHA.4928@TK2MSFTNGP06.phx.gbl... >>> and >>> sp_who2 does not show anu block or lock problems >>> >>> Meelis >>> >>> >>> >>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>> news:uUP2gH$LHHA.4384@TK2MSFTNGP03.phx.gbl... >>>> Hi >>>> >>>> Im still having problem with this timeout :( >>>> >>>> a) Indexes are ok >>>> b) No triggers >>>> >>>> With other clients using database with same conf. all works fine >>>> >>>> >>>> Meelis >>>> >>>> >>>> >>>> >>>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>>> news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >>>>> Hi >>>>> >>>>> What can cause "Timeout expired" on deleting only one row? >>>>> >>>>> delete from tmarcid where id=3423 >>>>> this happens not every time, same problem with update. >>>>> >>>>> >>>>> SQL 2000,Windows XP, all SP's installed. >>>>> >>>>> DB size is only 4MB >>>>> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >>>>> >>>>> >>>>> Regards; >>>>> Meelis >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
yeah sql 2000 sp4, today i'll try sql 2005
thnx anyway :) M. [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:eATj$e$LHHA.5012@TK2MSFTNGP02.phx.gbl... > Meelis > I have no idea why it is happened. Do you have a last service pack > installed on SQL Server? > > > "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message > news:unJaGY$LHHA.3556@TK2MSFTNGP03.phx.gbl... >> no problems with log file (its only 1MB, db size 24mb) >> nothing in error.log file >> >> >> >> M. >> >> >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:OwcSLU$LHHA.4376@TK2MSFTNGP03.phx.gbl... >>> Perhaps LOG file is growing and users get the eeror. >>> >>> Have you checked any enties in the ERRROL.LOG file? >>> >>> >>> >>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>> news:ewfIZI$LHHA.4928@TK2MSFTNGP06.phx.gbl... >>>> and >>>> sp_who2 does not show anu block or lock problems >>>> >>>> Meelis >>>> >>>> >>>> >>>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>>> news:uUP2gH$LHHA.4384@TK2MSFTNGP03.phx.gbl... >>>>> Hi >>>>> >>>>> Im still having problem with this timeout :( >>>>> >>>>> a) Indexes are ok >>>>> b) No triggers >>>>> >>>>> With other clients using database with same conf. all works fine >>>>> >>>>> >>>>> Meelis >>>>> >>>>> >>>>> >>>>> >>>>> "Meelis Lilbok" <meelis.lilbok@deltmar.ee> wrote in message >>>>> news:erCLPszLHHA.3552@TK2MSFTNGP03.phx.gbl... >>>>>> Hi >>>>>> >>>>>> What can cause "Timeout expired" on deleting only one row? >>>>>> >>>>>> delete from tmarcid where id=3423 >>>>>> this happens not every time, same problem with update. >>>>>> >>>>>> >>>>>> SQL 2000,Windows XP, all SP's installed. >>>>>> >>>>>> DB size is only 4MB >>>>>> Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. >>>>>> >>>>>> >>>>>> Regards; >>>>>> Meelis >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |