Re: The log file for database 'tempdb' is full

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Peter Yeoh (nospam_at_nospam.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 11:47:04 +0800

Now that is strange. What would that query have to do with the tempdb
database? No sorts, subqueries, or aggregation at all. Color me stumped.
Does it make any difference if you select top 10, 100, 1000 etc? Or create
a view and select from the view (not that any of these suggestions would
identify what's wrong)? 

-- 
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files?  Use MiniSQLBackup Lite, free!
"Jonas Larsen" <Jonas.Larsen@Alcan.com> wrote in message
news:uRUDhtzrEHA.596@TK2MSFTNGP11.phx.gbl...
> The query was Select top 1000 * from table1
>
> Table1 being a normal table with less than 10,000 records and less than 20
> columns. And again there was heaps of space available in the TempDb and if
> it needed to grow there were heaps of disk space available and the growth
> options were unrestricted.
>
> Regards
> Jonas
>
>
> "Peter Yeoh" <nospam@nospam.com> wrote in message
> news:utiVojzrEHA.556@tk2msftngp13.phx.gbl...
> > One possibility is that your query requires the use of one or more large
> > worktables, which are automatically created in the tempdb database.
Check
> > the execution plan of your query.
> >
> > -- 
> > Peter Yeoh
> > http://www.yohz.com
> > Need smaller SQL2K backup files?  Use MiniSQLBackup Lite, free!
> >
> >
> > "Jonas Larsen" <Jonas.Larsen@Alcan.com> wrote in message
> > news:eM4QXbzrEHA.1816@TK2MSFTNGP09.phx.gbl...
> > > Hi Guys
> > >
> > > I was trying to run a simple Select stament against a database and it
> > > returned to below error message:
> > >
> > > The log file for database 'tempdb' is full. Back up the transaction
log
> > for
> > > the database to free up some log space..
> > >
> > > I checked the disk space which was fine, I checked the file sizes and
> > growth
> > > options which were fine. Luckyly it is a test server so I have just
> > > restarted the SQL Server Service and everything is fine however if
this
> > had
> > > been the production server this might not have been an option.
> > >
> > > Does anyone know why and/or any fixes?
> > >
> > > Thanks
> > >
> > > Regards
> > > Jonas
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... I have mapped out the path to the final query that is used to get to the ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ... and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Single-Threading / Performance issues
    ... SQL Server MVP ... > Early this year my database was migrated from a single CPU, ... (when a long select query is running, ... server guy also sez it's not his problem. ...
    (microsoft.public.sqlserver.server)
  • Re: Share Point Services
    ... Change the database ownership and permissions for the configuration database ... Microsoft SQL Server, and then click Query Analyzer. ... EXEC sp_changedbowner @AdminVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)