Post reply

SQLserver time out expire

  • July 6, 2012 at 11:55 am

    #96849

    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

  • July 6, 2012 at 11:58 am

    #1509835

    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[/url]

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply