[winniewang]

Hi, everyone,

I got the following error when I want to open a view:

Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.


when i used the following command line to check the tempdb log,please refer to the result below, seems that I have enough space to open a view.

1> use tempdb
2> go
1> sp_helpsegment logsegment
2> go
segment name status
------- ---------- ------
2 logsegment 0
device size
------ -----
master 4.0MB
free_pages
-----------
1165

Objects on segment 'logsegment':

table_name index_name indid partition_name
---------- ---------- ------ --------------
syslogs syslogs 0 syslogs_8

Objects currently bound to segment 'logsegment':

table_name index_name indid
---------- ---------- ------
syslogs syslogs 0

total_size total_pages free_pages used_pages
reserved_pages
----------------- --------------- --------------- ---------------
---------------
4.0MB 2048 1165 25
0
(return status = 0)
1>
2>

[Martijnvs]

Create an extra device (e.g. tempdb_extra) and extend the tempdb on the extra device:
disk init
name="tempdb_extra",
physname="<location of file>",
size="1000M"
go
alter database tempdb on tempdb_extra = "1000M"
go

[winniewang]

Got it.
I will do it, thanks a lot:-)

Winnie