[sims] Speeding up SIMS

[jinnantonnixx]

Good point, Vik. It might be an error to overlook the client machines and to focus just on the server.

[pete]

If you want a prolonged thrash of the database, modify the academic year (by placing a fake bank holiday somewhere in the future, for example) and then change it back again. Do this when no-one else is using SIMS.

[jinnantonnixx]

I found this very interesting talk (21 mins) about SQL and SSD. This is a must-view.

 

SQL on SSDs: Hot and Crazy Love | Brent Ozar Unlimited

Edited May 8, 2013 by jinnantonnixx

[matt40k]

What do you mean by reports running slowly? Is it just reports? Can you share a copy of one of the reports

[matt40k]

I found this very interesting talk (21 mins) about SQL and SSD. This is a must-view.

 

SQL on SSDs: Hot and Crazy Love | Brent Ozar Unlimited

 

Haha - very good point about SSD failures.

[sparkeh]

Personally I would be pointing fingers at the application.

Take a look at this chart from MS on SQL performance from here: Chapter 14 - Improving SQL Server Performance

http://msdn.microsoft.com/dynimg/IC42074.gif

You have a well specced server but the db and application have a much bigger effect.

SIMS is slow at reporting and I have often suspected the db or app is the reason.

[Theblacksheep]

How did you get on??