Re: Server Sizing Guidance ... Urgent

2008-01-06 Thread Joe D'Souza
With that kind of configuration I would go with at least 3 servers in a
server group - considering you have at least 300+ concurrent users. Each
single instance with at least 4 GB RAM, an initial data file size of at
least 1 GB and a log size of about the same..

With that being said, your site is a better candidate for a UNIX operating
system instead of Windows. When it comes to large volume users and high
volume transactions, I'm not quite that confident about Windows.. There may
be a few who would disagree with me as yes there are sites out there
handling pretty high transaction volumes on Windows using MS-SQL.

If you are having virtualized environment, I'd like to warn you about
performance issues I have faced on VMWare where the instances didn't get the
necessary horse power needed to run the applications (almost a similar
environment like you mention).. And recently have considered standalone
servers instead of virtual servers running on VMWare..

Hope this helps...

Joe

PS: In actual practice the minimum recommended RAM for the AR Server and
apps seldom work and maybe ok for demo environments.. go almost double the
documented recommendations..
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Naveen Kaushik
  Sent: Sunday, January 06, 2008 11:49 PM
  To: arslist@ARSLIST.ORG
  Subject: Server Sizing Guidance ... Urgent
  Importance: High


  **
  Hi Lists,



  I need an urgent help regarding remedy server’s sizing.



  We need to implement IM, PM, CM and SLM modules and there are significant
customizations in IM and CM modules. Along with that the CMDB will be
significantly customized to cater to above four modules.



  Also the AIE integration with CMDB to populate it from 3 to 5 discovery
tools and ARDBC integration with AD are in scope.



  Also 300+ Concurrent users will be using the ITSM modules on first go
live.



  The environment is Windows 2003 EE SP 2, SQL Server 2005 EE, ITSM 7.0.2
and CMDB 2.1.



  I am urgently looking for a document/theory/calculation matrix which can
guide me to give the hardware requirements (Most Significant is PRIMARY
MEMORY) for a QA and Production Server on Virtualized environment.



  There will be 6 boxes on a big virtualized box and there will be three
pair that will act as Database, Web and Application server for QA and
Production environment.



  The knowledge I have is:



  RAM :- 2 GB for AR Server + 1 GB for Mid-tier + 2 GB for each Major ITSM
module (from ARS Docs), but I need plenty of FACTS and INFORMATION to give a
concrete base for asking the Hardware which can cater my requirements and
satisfy a really tough customer.



  After all my searches now I rely on the vast experience of this list to
give some pointers or some guide.



  Please help!



  Thanks in advance



  Regards

  Naveen Kaushik

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Server Sizing Guidance ... Urgent

2008-01-06 Thread Naveen Kaushik

Hi Lists,

 

I need an urgent help regarding remedy server's sizing.

 

We need to implement IM, PM, CM and SLM modules and there are
significant customizations in IM and CM modules. Along with that the
CMDB will be significantly customized to cater to above four modules.

 

Also the AIE integration with CMDB to populate it from 3 to 5 discovery
tools and ARDBC integration with AD are in scope.

 

Also 300+ Concurrent users will be using the ITSM modules on first go
live. 

 

The environment is Windows 2003 EE SP 2, SQL Server 2005 EE, ITSM 7.0.2
and CMDB 2.1.

 

I am urgently looking for a document/theory/calculation matrix which can
guide me to give the hardware requirements (Most Significant is PRIMARY
MEMORY) for a QA and Production Server on Virtualized environment.

 

There will be 6 boxes on a big virtualized box and there will be three
pair that will act as Database, Web and Application server for QA and
Production environment.

 

The knowledge I have is:

 

RAM :- 2 GB for AR Server + 1 GB for Mid-tier + 2 GB for each Major ITSM
module (from ARS Docs), but I need plenty of FACTS and INFORMATION to
give a concrete base for asking the Hardware which can cater my
requirements and satisfy a really tough customer.

 

After all my searches now I rely on the vast experience of this list to
give some pointers or some guide.

 

Please help!

 

Thanks in advance

 

Regards

Naveen Kaushik



DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

---

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remedy on Vista

2008-01-06 Thread Mike

Barber, Dave wrote:


Haven't tried it against Oracle XE on Vista yet, but I think I'm just 
as likely to try running Oracle XE on the Ubuntu VMWare session, and 
attempt to install 7.1 against that - before I start sweating blood 
over the weekend, is it likely to install?


Remedy _will_ work with Oracle XE on Linux.  You need to hack the 
install script, around line 4288 ,

if you don't have an officially supported distribution.
 OpenSUSE and SLED worked easily after that, I'm not sure if Ubuntu 
might need a little work.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Re: Iritive Search on Set Fields

2008-01-06 Thread Carey Matthew Black
SMR,

I would think that a table field would get the job done very easily.
The only "trick" would be that you need an active link guide to set
the value, refresh the table field, check the number of rows in the
table and decide to either stop, or shorten the string and loop
through the guide again. So something like this...

Table field qual: 'field_to_find_value_in' LIKE $String_to_look_for$+"%"

"OnReturn" active link --> Set a field ('String_to_look_for') with the
initial value then call a guide.

Guide:
 Lable: "Start"
  AL0 : Action 0: 'zLength' = LENGTH($String_to_look_for$)

  AL1 : RunIf : 'zLength' >=1
  AL1 : Action 0: Refresh table field
  AL1 : Action 1: Set field 'zInt' = $ LASTCOUNT$
  AL1 : ELSE Action 0: Exit Guide

  AL2 : RunIf: If : $ LASTCOUNT$ <= 0 AND 'zLength' >=2
  AL2 : Action 0: 'String_to_look_for' =
LEFT($String_to_look_for$,LENGTH($String_to_look_for$)-1)
  AL2 : Action 1:  GOTO LABEL "Start"

That guide should exit when it finds one or more records in the table
refresh or it should shorten the string (down to one character [ You
might want to change that AL1,AL2 RunIf's a bit] ) and try again.

Then if you could also choose to add another active link "OnReturn"
and do a set field action (if you want to show a picklist instead of
the table field) or you can call a guide...etc... You might even want
to have an active link to check for the case of 'String_to_look_for'
being = $ NULL$ and tell the user that "no match was found for any of
those combinations" too.

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Jan 6, 2008 6:01 PM, Marquez Rankin <[EMAIL PROTECTED]> wrote:
> **
> I need to create a search which will search for a string (ie. "LMNOPQR"),
> then search that minus a character (ie. LMNOPQ") if no records match and so
> on.
>
> I would like to have this OnReturn of the character field.
>
> I have experimented with writing direct SQL and/or using a chain of active
> links with SUBSTR to remove the last character
>
> Has anyone done this in Remedy?  I'd like to limit this to Remedy code but
> SQL is an option.
>
> -SMR

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Iritive Search on Set Fields

2008-01-06 Thread Marquez Rankin
I need to create a search which will search for a string (ie. "LMNOPQR"),
then search that minus a character (ie. LMNOPQ") if no records match and so
on.

I would like to have this OnReturn of the character field.

I have experimented with writing direct SQL and/or using a chain of active
links with 
*SUBSTR*
to
remove the last character

Has anyone done this in Remedy?  I'd like to limit this to Remedy code but
SQL is an option.

-SMR

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Re: User Sizing ?

2008-01-06 Thread Rami S Ayoub
Carey,

Thank you I found one white paper , but still I don't have clear
computability for what I'm trying to do ? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Monday, January 07, 2008 12:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: User Sizing ?

Rami,

   Your answer completely depends on the application the users will be using
and the type of actions they will be taking in that application.
( Even a few users doing a bad search will bring any application/RDBMS to a
crawl.) Generally however there is a "white paper" that BMC published for
ITSM sizing. From memory I think 200 users is sized to be a "small" install.
(maybe it was medium, but I think it was still small. ) I also think there
are considerations for what clients the users will be using. ( User Tool,
Mid-Tier, Crystal Reports, Import tool, ect... )

   Generally however, buy the hardware that you can afford to by and then
try to do performance tuning at the DB when needed. (And user education
whenever possible.) You likely will also find that your hardware/performance
needs change over time. So be prepared to adjust and improve things as time
passes too.

HTH.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Jan 6, 2008 9:10 AM, Rami S Ayoub <[EMAIL PROTECTED]> wrote:
> **
>
> **
> Hi List,
>
> There is methodology for the sizing for example if I have 200 users 
> they will using the system , there is any requirement or compatibly 
> matrix for this ?
>
> Regards,
> Rami Ayoub
> BMC Development Manager


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Re: User Sizing ?

2008-01-06 Thread Carey Matthew Black
Rami,

   Your answer completely depends on the application the users will be
using and the type of actions they will be taking in that application.
( Even a few users doing a bad search will bring any application/RDBMS
to a crawl.) Generally however there is a "white paper" that BMC
published for ITSM sizing. From memory I think 200 users is sized to
be a "small" install. (maybe it was medium, but I think it was still
small. ) I also think there are considerations for what clients the
users will be using. ( User Tool, Mid-Tier, Crystal Reports, Import
tool, ect... )

   Generally however, buy the hardware that you can afford to by and
then try to do performance tuning at the DB when needed. (And user
education whenever possible.) You likely will also find that your
hardware/performance needs change over time. So be prepared to adjust
and improve things as time passes too.

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Jan 6, 2008 9:10 AM, Rami S Ayoub <[EMAIL PROTECTED]> wrote:
> **
>
> **
> Hi List,
>
> There is methodology for the sizing for example if I have 200 users they
> will using the system , there is any requirement or compatibly matrix for
> this ?
>
> Regards,
> Rami Ayoub
> BMC Development Manager

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


User Sizing ?

2008-01-06 Thread Rami S Ayoub
**
Hi List,
 
There is methodology for the sizing for example if I have 200 users they
will using the system , there is any requirement or compatibly matrix for
this ?
 
Regards,
Rami Ayoub
BMC Development Manager
 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"