ESXI 5 Disk is on a local host, running raid 6 on a LSI raid card Machine has HT turned off so only scheduling full cores System takes up less than 500mb of RAM and uses less than 1% of CPU
Intel Xeon X5482 3.2Ghz 64GB RAM 6TB Raid 6 10GB NIC VMXNET NIC#2 Windows Server 2008 R2 Dedicated Development Box VM #1: 8 Core 6GB (Writes SQLITE DB's to C and shares directory) VM#2: 4 Core 4GB (Writes SQLITE DB's out to Share on VM#1) The Tick Tapes are on 40TB NAS Looking through the code I noticed sqlite3_exec(db, zSQL, 0, 0, 0); wrapped inside transaction. Suspect this is causing the CPU load, going to try recoding using prepared statements. <<< Response to Keith Medalf >>> What version of ESX and where is your disk coming from? Are you scheduling full cores or fake cores? What is the split between USER/SYSTEM CPU on the VM when it tanks? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
