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 |
|
Logicalman
Starting Member
6 Posts |
 Posted - 2006-02-01 : 14:10:13
|
| I have a Stored Procedure serving an web application that returns data from a number of tables.This dat resides on three seperate tables, two of which I join in a single select statement, the third I use to lookup data dependent on some data retrieved from the original select statement.On some infrequent occasions the user will receive an error message stating they are the victim of a deadlock etc, etc.I have checked the logs on SQL but find no error message pertaining to this. I then created a script in QA that access this Stored procedure in a loop at 1000 and then 10000 times, but whenever I run it, I receive no error messages, just the recordset(s) returned correctly.The data being accessed is live and updateable 24/7 by other users. This Stored Procedure does not moify the data in any shape or form, simply reads it.Another developer I work with has suggested using the NOLOCK hint on all reads, but I am loathed to use this as it may cause dirty reads.1. Does the scenario indicate this is truly a deadlock situation or could there be another cause for this error message (the web app is in .NET)2. What is the general point of view on using the NOLOCK hint and should it be used as a matter of course or very sparingly? I am obliged for any assistance or guidance in this matterTony |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2006-02-01 : 15:20:02
|
| (Moved to the Developer forum.)===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-02 : 03:40:56
|
| http://sql-server-performance.com/deadlocks.aspMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Locking