I'm using SQL Server Express Edition.It includes 10 databases with each containing data above 4GB and it grows. There are 7 EXE's running and it inserts multiple rows in 4 tables in each database for every 5 seconds.
My issue is, When I running all the EXE's at the same time, the database processing is getting slowed down. For example, I have EXE's like E1,E2,E3 and it inserts records in table D1,D2,D3 respectively. One of the table contains a "datetime" column and which records the current date and time for every 5 seconds. During the initial stage, it records the correct time, but after 5 or 10 minutes, it queues the data and process is getting slow down. that is, consider now the time is 12:00, but the the time recorded in the column is 11:45. When I run a single EXE, it load the data correctly and will record the current time. Is there any possibility to avoid this slowness?
Submit an article or tip