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 |
|
JAldrich73
Starting Member
1 Post |
 Posted - 2010-04-14 : 09:49:26
|
| I have been working on a Point of Sale system. The issue we run into is that twice a daily, usually first thing in the morning, when everyone is first logging in for the day, and late afternoon, when they are preparing their bank deposits, our SQL server generates timeout errors. This appears to happen when we try to write invoices to the Sales Order and/or Payment tables. The sales and payment tables are also viewable in our reporting section for Daily Sales reports and SQL Reporting services.Whaat avenues can I begin with to determine what is causing the timeouts and how to prevent them? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-04-14 : 09:51:45
|
| 1. Use Profiler to trace all SQL activity.2. Guess/Monitor which business functions are being used at peak times. Examine the execution plans.3. Post sample code & DDL here and we'll comment/advise, etc. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL timeouts during parts of the day