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

SQLserver time out expire Expand / Collapse
Author
Message
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.

Thanks
Ashish

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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 40,193, Visits: 36,597
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 2008, MVP
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