September 29, 2008 at 8:40 am
Hi Experts,
we are having a application which writes data from MS ACCESS to MS SQL Server .The insertion of data occurs every ten minutes and at that time the CPU usage is very very high.Can anyone point out the reason for this??
TIA
September 29, 2008 at 10:12 am
Hi Ritesh
Is that the only process running at that point of time, if yea, how are u inserting data from Access to SQL?? and what version of SQL are you using?? are both on the same server??
Cheers
🙂
September 29, 2008 at 10:42 pm
check out the blockings and use profiler .... counters
September 29, 2008 at 11:25 pm
Pls give more details specially regarding your hardware , volume of data and about the process happening.
"Keep Trying"
October 1, 2008 at 6:23 am
Sorry to post here ....
Its a 2000 server.Both the access db and sql server db in the same machine.
The data from access is exported to sql server in every 3 minutes and at that time the CPU utilization is 100%
October 1, 2008 at 7:38 am
Its a dual core machine with 4GB RAM.
October 1, 2008 at 7:53 am
The particular database to which insertion occurs is in SIMPLE recovery model is that a cause???
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply