What’s the best way to optimize the performance of the system?
There are a couple of things that can greatly improve the performance of the SMS Server
- Use an SSD (solid state disk) for the SMS Server database
- Use a local installation of SQL Server
- Make sure that you have a multi-core PC
- Make sure that your SQL Server license permits using multiple cores