July 14, 2015 at 6:20 am
How many no of records of the tables are called large tables.
We are getting more deadlocks. We are using default isolation. Read & insert statements are blocking each other and causes dead locks.
I am thinking that might be purging will help to reduce deadlocks.
The table has 15million records. Is this table consider as large table or not in OLTP systems?
In general how many records we need to consider as large table
July 14, 2015 at 6:24 am
How long is a piece of string?
I've got 20 million row tables in my test DB. I've seen tables with billions of rows in them. I've seen systems where no table has more than 2 million rows.
Deadlocks are typically caused by inefficient queries, poor indexing and/or code within transactions accessing objects in different orders.
Archiving might help. Or might not. No way to say in general. Tune your queries, make sure your indexes support the workload, consider using one of the row-versioning based isolation levels.
https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply