Many SMS services and components make extensive use of SQL Server. In order for SMS to perform well, the computer running SQL Server must be configured for optimum performance. In addition, there should be a fast interface between the SQL Server and the services and components using the SQL Server.
Each instance of the SMS Administrator uses SQL Server. In addition, the following SMS services use SQL Server:
The following threads (running in the SMS Executive) use SQL Server: