I have a major development on several sites which was developed in VB6 using a SQL database. As you would assume there are several occasions where data is writen to tables. The application has been on site for many years and has been working under MS SQL exclusively beginning with 2000, and progressing through to 2008. In the last few weeks the application has been operating on one site under 2012 and I have hit snags. Some transactions are taking far longer to run with noticable pauses in the application while SQL writes data to tables.
Can anybody provide some general advise on tweating performance before I start sending code snips>