Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQLserver time out expire Expand / Collapse
Posted Friday, July 6, 2012 11:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 6, 2012 11:56 AM
Points: 1, Visits: 4
Dear forums,

I have facing one problem on my application. I am fetching my record from my application (front end is VB)but its throw sql server
error - TIME OUT EXPIRE...

I have checked query and connection . but every thing is ok .
I am facing this problem is last 2 days.
when i stop the sqlserver services and then restart my problem resolved only some time.
after that its show same error msg.
I also checked the data file and logfile. i found that my log file size is increase day by day .

please give me the solution ASAP.


Post #1326251
Posted Friday, July 6, 2012 11:57 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
You need to do some performance tuning. It's not about log files, it's about the time the query takes to run. Identify the problematic queries and see if you can tune them.

Oh, and about that log file, please read through this - Managing Transaction Logs

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1326254
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse