Database planning

All of the servers which have Microsoft SQL Server installed are set up with different forms of RAID in order to gain redundancy and performance. This is needed because all the clients report back a large amount of data to the site, depending on what features are enabled in the client policy.

For instance, some examples of what the clients might report back to the site and the database are as follows:

  • Software inventory
  • Hardware inventory
  • Software metering
  • Baselines and configuration items

And depending on the information and the schedule this might result in a large amount of data.

But let us delve into the different forms of RAID and how it can give us better performance and redundancy for our database server. The whole purpose of ...

Get Microsoft System Center Configuration Manager High availability and performance tuning now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.