Optimization in sql server RRS feed

  • Question

  • Hi All,

    Need you help regarding the optimization of SQL server to ensure that SQL server is monitored and is up on running.

    What strategies can be followed if any fluctuations occurs in Database

    For example if sever has restarted, we step up an notification that our server has been restarted. Apart
    DB Restart Notification,DB Growth rate,Blocking Notifications,Deadlock Trace and notification regarding backups .What others steps or plans can be taken for optimization from DB side.

    Thanks you in advance.

    Monday, February 27, 2017 3:50 AM


All replies