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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-01-11 : 22:27:41
|
| hii am having a server with 8GB RAM, windows server 2003 x64 cluster, sql server 2005 x64. we are using this server to handle datastorage. the application has been developed using a baan. In the live situation when there are more transactions, some time we are getting time out expired error but not always and all appliction is stop.can anyone help me in this matter. thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-11 : 23:38:58
|
| You need to check your statistics, execution plans, index fragmentation, IO bottlenecks, other PerfMon counters. You need to ensure your queries are properly indexed and that there is no blocking occurring. Without more specific information, we can only generalize what to look for.Startup a SQL Profiler trace next time it happens to find the queries that are taking longer than the application timeout setting, which is typically 30 seconds.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." |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-01-12 : 00:11:24
|
| you need to enable tcp chimney to balance the load on CPU utilization. enable it. you will be all set.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Time out expired error