SQL 2005 & SharePoint 2007 Setup

  • We have just install SharePoint 2007 but I believe the person who install it could have done a better job. The database server is a standalone box (that has 8 CPUs) with three drives.

    Drive “C” 35000MB (Total), 27512MB (Free);

    Drive “D” 104971MB (Total) 104146MB (Free),

    Drive “E”409598MB (Total) 409517MB (Free).

    All of the databases are on drive “D” including the system databases; I would have preferred master, model & msdb on the “C” drive and tempdb on several equal disks. Would it be in our best interest to reconfigure the database files and have one tempdb database file per physical core (using the Alter database command)? Any suggest would be appreciated.

    😀

  • Will Sharepoint be installed and share resources with database server, or does Sharepoint has its own box?

    Once sharepoint server is installed and configure a site, 3 different databases with suffix prof,serv and site will be created. There will be an other database called configuration database. Once you are done with sharepoint set and configuring, bringdown all services related to sharepoint and then move database files related to sharepoint as required.

  • It has it's own box like SQL

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply