Using SQL Replication to Enhance SMS Site Performance

 < Day Day Up > 



Management points, and to a lesser extent server locator points, can access the SMS site database frequently to service requests made by SMS Advanced Clients. This can place a significant strain on server resources on the computer hosting the SMS site database as well as generate a significant amount of network traffic.

You can mitigate these issues by installing a separate instance of SQL Server on another computer in your network and replicating the Advanced Client policy tables from the SMS site database to the second instance of SQL Server. SQL Server database replication will then keep the replicated Advanced Client policy database synchronized with the SMS site database. The replication process is handled entirely by the SQL Server publication and subscription services. Then, configure the management point or server locator point to connect to the SQL Server computer that contains the replicated database rather than the SMS site database server. Refer to Chapter 3 for detailed steps for configuring a management point.

You can run MpPublish.vbs at a command prompt from the SMSSETUP\BIN\ I386\ folder on the SMS 2003 product CD to publish the table and store procedures. The syntax for using MpPublish.vbs is

MpPublish.vbs SiteDatabaseName PublisherMachineName SQLUserName SQLPassword

where SiteDatabaseName is the name of the SMS site database, PublisherMachineName is the name of the SQL Server computer that hosts the replicated database (if not specified, the local computer name is assumed), SQLUserName and SQLPassword represent the SQL account and password that has access to the replicated database (required if you aren’t using Windows Only Authentication for that instance of SQL Server). If the command runs successfully, you’ll see the message MpPublish Completed Successfully. After you run this command, you can configure the subscriber and start the snapshot agent on the distributor computer (the SMS site database server). Refer to the SQL Server documentation for information about completing the configuration.



 < Day Day Up > 



Microsoft Systems Management Server 2003 Administrator's Companion
Microsoft Systems Management Server 2003 Administrators Companion (Pro-Administrators Companion)
ISBN: 0735618887
EAN: 2147483647
Year: 2006
Pages: 178

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net