SQl 6.5: Problem with TEMPDB during Frontend Data Import
Oliver Thieke
side and Centura Team Developer for implementing the client-frontend
(based on native MS SQL ODBC driver).
One part of the frontend is responsible for importing large amount of
data
to the SQL Server. The data must pass a complex check and depending on
their existence/
non-existence the row is inserted or updated.
The first tests of the code worked fine. But now - with much heavier
load of
data - we're getting constantly the SQL Server error message no. 1101,
saying:
"New pages for databse 'tempdb' cannot be reserved. No more valid pages
accessible".
It occurs after updating approximately 200 rows. The Updates don't use
any
temporary tables and no stored procedures are involved.
Why is the "tempdb" affected ?
"tempdb" is not located in RAM.
I increased the DB size for "tempdb" significantly, but the error
occured
now just a little bit later (after 300 rows). The real data import would
try to insert or update up to 50'000 rows...
Right now, I don't have a clue how to track down this bug !
Do you have any pointers ?
Thanks for your help in advance.
Ronnie Chee
Check out the following KnowledgeBase article (looks like what is happening
to you):
http://support.microsoft.com/support/kb/articles/Q153/9/17.asp
It appears that you are on an old service pack.
To determine what service pack you are on:
In an ISQL window, do:
select @@version
which will return a message with one of these version numbers:
6.50.201 6.5 No service pack installed
6.50.213 6.5 SP1
6.50.240 6.5 SP2
6.50.258 6.5 SP3
6.50.281 6.5 SP4
6.50.415 6.5 SP5
6.50.416 6.5 SP5a
See this article for more details:
http://support.microsoft.com/support/kb/articles/Q202/0/51.ASP
Where to get Service Packs? See
http://support.microsoft.com/support/SQL/Content/spack.asp
Localized versions (ie German I assume) see the info at the bottom of the
article.
Hope this helps.
"Oliver Thieke" <thi...@tagesspiegel.de> wrote in message
news:3888973D...@tagesspiegel.de...