School Info
1,150 student school (SQL 2012, Solus 2, Discover)
Sims server
Virtual Hyper-V, 10GB Dynamic to 20GB RAM, 12 Cores on Xeon E5-2650 @ 2.0GHz,
Sims Benchmarks
05 Seconds Client Login Time (SSO from when hitting Enter)
20 Seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
01 Second Search "Smith" student name in main screen search box
N\A Seconds Solus 3 launch on server
Sims Database
Sims.mdf - 6.7 GB
Sims.ldf - 0.3 GB
Our Data Manager still complains that running reports is a slow process, She's got a 2nd PC to keep up with work while running reports. I found that an SSD client speeds up her reports a bit. The Assistant Head told me that they are going to be running whole school reports at the same day (is it even possible??) so he was asking if we could invest on the system to be a bit faster.
Any ideas?