SQLServers Data Collation Method _mssql

Today, in Sunday, because the database was too slow, it was finally decided to reorganize the database.
(Assuming the database name is: db_ste)
1, based on the current database script to create a script file (FILENAME:DB_ste.sql)
2, the establishment of a new database db_ste2, if there is a file group database, you need to establish the same file group. (Db_ste_group)
3, the data file (Db_ste) in the new database Db_ste2 implementation. (Note: Because some processes rely on databases from other servers, the server must be linked to the network, and there will be warnings when they are created.) Also, the primary and check names in the new database are not the same as the old ones, and can be ignored. )
4, the use of MSSQL's own DTS tools to db_ste data into the db_ste2.
5, change sp_renamedb ' db_ste ', ' db_test '.
Sp_renamedb ' Db_ste2 ', ' db_ste '
6, can make use of the database.
Summarize:
Although this method is very helpful to the speed of the database, it does not solve the problem of the slow database fundamentally.
Because the final reason for the slow database is not found, so in six months, the database will also be slow, but also more slowly.
I will not be able to do so again, often walking along the river, there are not wet shoes. It would be troublesome to get the data out of the day.