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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-29 : 09:40:34
|
| israel writes "Hey guys, looks like a xmas tree on our event log! sql server 2k with all the patches and service packsheres the issue, from what i can see on the transaction logs in sql the MSSQLSERVER SERVICE stops responding to requests so we have to restart the service to make it functional again.we get these like mad.and what i can see ..they start after a transaction log backup runs ..hourlyEvent Type: WarningEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17055Date: 11/26/2002Time: 1:27:18 PMUser: N/AComputer: TDSHQAP01Description:17424 :Warning: OPEN OBJECTS parameter may be too low. Data:0000: 10 44 00 00 0a 00 00 00 .D......0008: 0a 00 00 00 54 00 44 00 ....T.D.0010: 53 00 48 00 51 00 41 00 S.H.Q.A.0018: 50 00 30 00 31 00 00 00 P.0.1...0020: 07 00 00 00 6d 00 61 00 ....m.a.0028: 73 00 74 00 65 00 72 00 s.t.e.r.0030: 00 00 .. and also this one..... and they chain down the event logEvent Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17055Date: 11/26/2002Time: 1:27:18 PMUser: N/AComputer: TDSHQAP01Description:17426 :Run sp_configure to increase the parameter value. Data:0000: 12 44 00 00 10 00 00 00 .D......0008: 0a 00 00 00 54 00 44 00 ....T.D.0010: 53 00 48 00 51 00 41 00 S.H.Q.A.0018: 50 00 30 00 31 00 00 00 P.0.1...0020: 07 00 00 00 6d 00 61 00 ....m.a.0028: 73 00 74 00 65 00 72 00 s.t.e.r.0030: 00 00 .. what can we do? thanks againisrael galindoigalindo@thedebtsolution.com" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-29 : 10:00:32
|
| Looks like you might have to increase the OPEN OBJECTS parameter. As the msg says, try running sp_configure. |
 |
|
|
|
|
|
sql 17055 errors