• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

MS SQL Server 6.5 BUG ?!

I have MS SQL Server 6.5 running as a Database Server .
The problem I have is that SQL-Srv breaks down without any message.
Although I have the Service Pack 4 , it often happens when I have a lot of requests.
Hope someone can give me some good tips .
 
0
kaber
Asked:
kaber
1 Solution
 
formulaCommented:
Does SQL Server stop? If so, what are the messages in the errorlog? And what kind of requests are going on?(i.e. selects, updates, inserts,deletes)
0
 
kaberAuthor Commented:

No , not really . The server hangs up without any message and the only way is to reeboot your computer.
It happens so surprisingly that the server has no error log file.
Could it be the same problem like the 4.5 version , where the Server hangs when a lot of requests come in with "ASC" or " DESC"  ???

0
 
gertrudeCommented:
What are your configuration settings for the following:
   set working set size
   smp concurrency
   priority boost
   max worker threads
   procedure cache
If they are not set to the default values, you'll want to review the Technet article Q166967.

Additionally, MS techs have told me that the default value (500) for Open Objects is low.  Try increasing it to 5000.


0
 
ShirishCommented:
Had faced the same problem when the configured maximum number of user connections used to be reached. Try increasing that number in server configuration.
0
 
SpaarQCommented:
Increase the number of connections.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now