Service Connect SQL setup

Yahoo Archive
1
We can easily have 660 SC events in a 24 hour period. Many of our
events include up to 680 steps while processing all of the data. Many
of the events can also trigger errors that are posted to individual
tasks that are stored in task manager until resolved and then are
maintained in the db for a designated period of time for documentation
purposes for SOX. So the potential for us is 300,000 plus individual
transactions through SC in a day.



Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@...







[Non-text portions of this message have been removed]
2
Hello,

I am in the process of building a server to run Service Connect. Do we need the `ideal' SQL drive configuration, or not? Bearing in mind our instance of Vantage (8.03.406) has a 23GB Progress backend.

Regards,


Michael
3
To my knowledge no. The SQL instance used by SC is just for management of the SC workflows, doc tracking, etc. SQL Express works just fine for that.

The size of the Progress DB it is issuing commands to should be irrelevant.

Sean B
Director of IT
HMU, LLC

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I am in the process of building a server to run Service Connect. Do we need the `ideal' SQL drive configuration, or not? Bearing in mind our instance of Vantage (8.03.406) has a 23GB Progress backend.
>
> Regards,
>
>
> Michael
>
4
Just a note - If you have large volumes of SC transactions, SQLExpress
can easily reach is Max Record limit.



We had to change to use full Blown SQL in order to accommodate our
volume of transactions.



Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@...







[Non-text portions of this message have been removed]
5
Hey jerry,



You've made me curious.. can you define large volumes, and what
information is the SC sql database storing that needs the room? Thanks!



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jerry W. Rodden
Sent: Tuesday, March 29, 2011 5:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect SQL setup





Just a note - If you have large volumes of SC transactions, SQLExpress
can easily reach is Max Record limit.

We had to change to use full Blown SQL in order to accommodate our
volume of transactions.

Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@... <mailto:jrodden%40yutakatech.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]