July 6, 2012 at 11:55 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply