Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
badara24
Starting Member
3 Posts |
 Posted - 2010-03-12 : 03:22:46
|
| we have one hr module which is accessing sql server2000 database which is in clustering.we are having 13 database on whole in which all are having 1mb as .ldf file. As we are facing the time out expired problem in one of the application in hr database..one of team mate increased to 25gb (.ldf) is there any performance issue over this. i mean to say increase from 1mb to 25gb. we are facing the problem can one suggest me.. please. Is that the correct solution for the timeout expired. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-12 : 18:14:26
|
| I should also mention what my blog post doesn't discuss regarding applicaton timeouts:1. Lack of indexes for the queries2. Poorly written queriesI don't mention these things in that blog post, since my blog reader already has those things covered.For the queries that are timing out, what does the execution plans show? Any scans?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
INCREASE IN SIZE .LDF