There's some good info here. http://www.brianmadden.com/forums/t/30061.aspx
Namely, use 1 CPU per VM and do more VMs. Addresses your 100% usage directly. And what does process explorer tell you about context switches? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of IQuant [sql...@iquant.co.cc] Sent: Thursday, June 07, 2012 8:24 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] 100% CPU utilization sqlite running in VMWare 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
