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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2011-11-25 : 17:32:52
|
| We are having few issues with the application delete statements(Appliction is opening multiple threads to delete these) ,We tested the queries on a test server and they had ran fine with out any issues(Blocking),When we ran it in PRD,it was causing too much blocking and running very slow which we had not seen this on test server.PRD server has very efficient memory and capacity resources when compared to Tst.Server wide,database settings are same.Any one has any ideas what might be the issue? |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-26 : 06:27:47
|
| Are you using READ_COMMITTED_SNAPSHOT setting on the database? If not, and you have Read's blocking Writes, that might help. Needs testing first, before you deploy it on Production because there are some instances where queries can return different results (Google for the details) |
 |
|
|
|
|
|
Blocking -Peformance issue