c# - improve performance in business application -

i'm doing business application in c# windows form. 10000 data entry per day.

current implementation after triggers:

1. filter relevant data base table , insert secondary table 2. send email users when there insert/delete/update secondary table. 3. exec stored procedure when there insert/delete/update secondary table. 

one of problem there deadlock when display report in ssrs

click 1 deployment current implementation manual installation. no online update should have use file share deploy can check updates

any can advice should use triggers business application

1.) not in favour of using triggers implement business logic. difficult maintain bl in triggers.

2.) have seen trigger not fire on each record if updating bulk records.

3.) troubleshoot performance issue can turn on sql profiler trace files. in trace file can analyse deadlock.

4.) there ready made dmv queries available on net a.) list of top slow queries. b.) unused indexes (you can remove these indexes) c.) missed indexes (you can add new indexes) d.) indexes needs add/drop columns , many more.

4.) can apply nolock query hint on reports queries gain performance.

5.) if fine should rdl. rendering consume lot of time depending upon functions used in rdl.