sql performance tuning
Hello,
i'm concidering SQL performance in our SCCM evironment. According to this document
http://technet.microsoft.com/en-us/library/bb932206.aspx men can
divide the SQL Server tempdb database into multiple database files.
Our current SCCM DB size is +-20GB with curently only 1700 clients, and during the next 6 month it'll grow towards 7-10k clients. I'm curious if i can also divide SCCM's own database into multiple database files to gain better(or at least not worser
than now) performance.Mikhail
December 15th, 2010 5:55pm