SQL server times out while waiting for buffer latch type 4

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL server times out while waiting for buffer latch type 4

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-20 : 07:23:44

Bertrandk writes "I am getting the following error when doing some tasks namely: Backing up a database. The back up process just stops abruptly, When adding a column to a table in Enterprise Manager.

Time out occurred while waiting for buffer latch type 4, bp 0x18fef900, page 1:8448), stat 0x10000b, object ID 8:292912115:0, EC 0x7533BA78 : 0, waittime 300. Not continuing to wait.

I am running Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Please help as I am unable to backup any database.

The server has 1 GB of Memory and the configuration options when I run sp_configure:
affinity mask 0 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 1 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 300 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 3072 3072
min server memory (MB) 0 2147483647 408 408
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 1 1
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
scan for startup procs 0 1 1 1
set working set size 0 1 1 1
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0"

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-20 : 11:50:52

There are a lot of KB articles that refer to this error. I would suggest searching support.microsoft.com

Suggestions:
Immediately install SP3 You should not be on the RTM version.

Why do you have AWE configures as on? You should turn that off. Even though the run value is off, you should turn the config value off as well.

What errors is your error log showing?

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources