July 12, 2013 at 3:02 pm
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.
May 7, 2015 at 3:13 pm
Did you ever get an answer to your problem? I have the same problem right now.
May 7, 2015 at 3:15 pm
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.
May 7, 2015 at 3:17 pm
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.
May 7, 2015 at 3:19 pm
It happens randomly. May be once in 2-3 months. I'm just putting up with it.
May 7, 2015 at 3:21 pm
Okay! 😎 Thanks for replying back.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply