Error 17803 Clustered Windows 2000 Server

Question

Post reply

Error 17803 Clustered Windows 2000 Server

Bryan Conlon

SSC Journeyman

Points: 98
More actions
November 3, 2005 at 9:59 am

#90708

Running Win 200 Adv. Server and SQL Server 2000 Cluster with /3GB PAE. Found KB artcles mentioning this kind of error in conjunction with running a create index or dbreindex on a database in simple or bulk logged recovery model. I cannot find any index jobs that correlate to the time of the error.
Anyone else seen this type of error before?
2005-11-03 08:41:03.14 spid16    BPool::Map: no remappable address found.
2005-11-03 08:41:03.17 spid97    Buffer Distribution: Stolen=200902 Free=1249 Procedures=689
  Inram=0 Dirty=5908 Kept=0
  I/O=2, Latched=274, Other=184192
2005-11-03 08:41:03.19 spid97    Buffer Counts: Commited=393216 Target=393216 Hashed=190387
  InternalReservation=510 ExternalReservation=5115 Min Free=1024
2005-11-03 08:41:03.19 spid97    Procedure Cache: TotalProcs=86 TotalPages=689 InUsePages=550
2005-11-03 08:41:03.19 spid97    Dynamic Memory Manager: Stolen=71775 OS Reserved=1896
  OS Committed=1857
  OS In Use=1784
  Query Plan=1260 Optimizer=44229
  General=5527
  Utilities=250 Connection=1049
2005-11-03 08:41:03.19 spid97    Global Memory Objects: Resource=2523 Locks=21610
  SQLCache=101 Replication=25
  LockBytes=2 ServerGlobal=49
  Xact=192
2005-11-03 08:41:03.19 spid97    Query Memory Manager: Grants=2 Waiting=36 Maximum=134924 Available=0

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Glauco Costa Mr or Mrs. 500 Points: 547 More actions · Answer 1

remember: sp_createstats and sp_updatestats create a kind of index.

I get a same problem and was ocurred when i update statiscs in my production box.

Johan Bijnens SSC Guru Points: 135267 More actions · Answer 2

is this an sp4 instance ? (we plan to upgrade to sp4, just inventoring what to expect)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Francis Apel SSC Eights! Points: 918 More actions · Answer 3

Hey Bryan,

Did you ever find any resolution to this? We are getting the same on our clustered server running Win 2000 Adv. Server and SQL Server 2000 Cluster with /3GB switch

TIA

Francis
-----------------
SQLRanger.com