Sims Server Performance Benchmarks
I'm really interested in what other schools performance is like from their Sims server?
I find it incredibly slow even with a brand new server just installed by Capita.
850 student school (SQL 2012, Solus 3, Discover)
Virtual Hyper-V, 10GB RAM, 4 Cores Xeon "E5-2430L" @ 2.ghz, SSD drive, Gbit NIC
11 Seconds Client Load time
13 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
3+ Seconds Search "Smith" student name in main screen search box
6 Seconds Solus 3 launch on server Scrolling agents is also really slow
Sims.mdf - 3.10 GB
Sims.ldf - 656 MB
Simsdiscover_Primary.mdf - 419 MB
Simsdiscover_Primary.ldf - 894 MB
I've run the Re-indexing patch but not sure what else to do to improve performance??