Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shared Memory Provider Error Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 3:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 13, 2015 9:18 AM
Points: 367, Visits: 949

I experienced this type of error today in SQL server instance.

[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00




Is this memory issue?

I checked one of the db properties.

it had Size = 151899 MB
Space Available = 75.13 MB
Number of Users = 20

Should this of concern?

Anybody can shed some light on this as where to start? SQL instance didn't accept any connections for about 20 minutes
and after that it was fine.


I am on SQL server 2005.
Post #1473240
Posted Thursday, May 7, 2015 3:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 11:51 AM
Points: 243, Visits: 877
Did you ever get an answer to your problem? I have the same problem right now.
Post #1683726
Posted Thursday, May 7, 2015 3:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 13, 2015 9:18 AM
Points: 367, Visits: 949
No. But it seems like too much processing going on the server during that time. So, could be CPU pressure as well. But I'm not sure exactly to be honest.
Post #1683728
Posted Thursday, May 7, 2015 3:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 11:51 AM
Points: 243, Visits: 877
Did it ever go away or did you just put up with it? We have transaction log backups that run every 15 mins when it happens. 10 backups will fail all at the same time and some of them will go to success.
Post #1683729
Posted Thursday, May 7, 2015 3:19 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 13, 2015 9:18 AM
Points: 367, Visits: 949
It happens randomly. May be once in 2-3 months. I'm just putting up with it.
Post #1683730
Posted Thursday, May 7, 2015 3:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 11:51 AM
Points: 243, Visits: 877
Okay! Thanks for replying back.
Post #1683731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse