July 21, 2005 at 4:44 pm
Good afternoon:
Pls note I had the following problem yesterday: I work with SQL server 6.5, we have settled the user connection in 500, but in fact we have aproximate 250 real users. However, yesterday the SQL server felt down, but before this felt down, this showed a message indicating that the 500 connections were already connected and also showed the following error: Error 834 Severity 21 State 1
I would appreciate if you can inform the reason of this felt.
Best Regards,
Alex Sanchez
July 24, 2005 at 8:36 pm
Hi Alex,
When the dirty buffer is not cleanedup this type of error is showed and server gets down to clean the dirty buffer.
The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).
Use this to see the real problem
DBCC CHECKDB WITH NO_INFOMSGS
GO
There is a command DBCC DROPCLEANBUFFERS which will clear the buffer pool. Before running DBCC DROPCLEANBUFFERS run command "CHECKPOINT" and then run DBCC command.
CHECKPOINT
DBCC DROPCLEANBUFFERS
or u can use this
- DBCC DROPCLEANBUFFERS
- DBCC FLUSHPROCINDB
- DBCC FREEPROCCACHE
Hope this helps u
from
Killer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply