• You should keep track on SQL Server storage and performance to avoid this type of problem

    If the capacity management of sql server is up to the mark then sql server always perform well and you will never face this type of problem

    you can try some third party software for capacity management of SQL server which will give you accurate information.