I suppose that if you have to choose, putting it on the DB is probably the least bad of the options, since it will affect the performance on the DB server anyway - no sense in hosing other boxen, too.
Keep the test discoveries small during the working hours - run your full gets during user down time, because it may lock up the DB until it's done. I noticed that the process of moving the data from the Discovery dataset to the Asset/CMDB dataset WILL lock up the DB for a while, so do that after hours, too. Rick On 9/20/07, T Wang <[EMAIL PROTECTED]> wrote: > > ** Rick, > > That is interesting. We are trying to setup Foundation and Topology > Discovery. These two pieces shared the same BMC Datastore. FD and TD look > to be small and lite, but the datastore that they shared is big (2GB). We > really have no choice but to install FD/TD Datastore on the same SQL Server > box having ARSystem on the default instance already. My initial plan is to > create another SQL instance for FD/TD datastore and install FD and TD > application piece on the Midtier. Do you have any recommendation for those > that don't have much choice due to system resource, but to setup > ARSystem/ITSM/Discovery Suite on limited Servers. (Just 3 in this case) > > > > T Wang > BAE Systems Information Technology > U.S. Department of the Treasury > Office of the Chief Information Officer > Headquarters IT Operations > > Phone: 202-622-5541 > > -----Original Message----- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Thursday, September 20, 2007 11:54 AM > *To:* [email protected] > *Subject:* Re: BMC Foundation Discovery - Installation? > > ** Well, that depends on two things - how powerful that server is, and to > what extent you're willing to deal with performance issues on that box when > a discovery process is running - FD will basically take over that box during > that process. There's a reason BMC recommends that FD be on its own server. > > > Rick > > On 9/20/07, T Wang <[EMAIL PROTECTED]> wrote: > > > > ** Can BMC Foundation Discovery Datastore be install on SQL Server > > specified instance or does it matter regarding performance? We only have > > one SQL Server box to work with. > > > > thanks > > > > Window Server 2003 > > SQL 2005 > > BMC FD 1.4 > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
