litmic
asked on
Keep Ms SQL server at good performance
Ms SQL 2017 on windows 2016 server was setup, after running for half a year, occasionally some report generate with slow speed. Is there any health check, monitoring tool, optimization, housekeep work to keep the SQL database server running at good performance?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, probably rebuilding some indices as part of a database maintenance plan is a good start.
ASKER
Sorry I'm new to SQL,may I have more detail about the rebuilding indices you mentioned?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.