Estimated Data size for 3-5 years

Dears,

I was looking for a document that give me an idea or talking about how to 
estimate Microsoft Dynamics GP database Growth and size. Any one could help 
me in this?

I found an article on MSDN but it is about SQL server and it needs to go 
throw all GP tables and finde the size of each field and calulate that number.

I have the following GP system:
POP module
FA module
And Financial Module

Any help?

Best regards,
0
3/19/2007 1:54:02 PM
greatplains 29623 articles. 6 followers. Follow

3 Replies
477 Views

Similar Articles

[PageSpeed] 36

Hi Hasan,
It really depends on the number of transactions that go through your system. 
If I had to guess at an average, I would say a database in use for 3-5 years 
would be only a couple of a gigabytes, but this varies dramaticaly based on 
the number of transactions.

-Mike

-- 
Micheal LoPatriello
Coordinator,
Luna Development
mlopat@lunadevelopment.com
http://www.lunadevelopment.com


"Hasan Ghannam" wrote:

> Dears,
> 
> I was looking for a document that give me an idea or talking about how to 
> estimate Microsoft Dynamics GP database Growth and size. Any one could help 
> me in this?
> 
> I found an article on MSDN but it is about SQL server and it needs to go 
> throw all GP tables and finde the size of each field and calulate that number.
> 
> I have the following GP system:
> POP module
> FA module
> And Financial Module
> 
> Any help?
> 
> Best regards,
0
mlopat (88)
3/19/2007 4:10:13 PM
Thank you Micheal for your response.

I get your point. If the number of transaction will be as following 500 
transaction per month on POP module. and anothre 1000 transaction per month 
on FA & Financial Module? what is the size will be in this case?

Regards,

"Micheal LoPatriello" wrote:

> Hi Hasan,
> It really depends on the number of transactions that go through your system. 
> If I had to guess at an average, I would say a database in use for 3-5 years 
> would be only a couple of a gigabytes, but this varies dramaticaly based on 
> the number of transactions.
> 
> -Mike
> 
> -- 
> Micheal LoPatriello
> Coordinator,
> Luna Development
> mlopat@lunadevelopment.com
> http://www.lunadevelopment.com
> 
> 
> "Hasan Ghannam" wrote:
> 
> > Dears,
> > 
> > I was looking for a document that give me an idea or talking about how to 
> > estimate Microsoft Dynamics GP database Growth and size. Any one could help 
> > me in this?
> > 
> > I found an article on MSDN but it is about SQL server and it needs to go 
> > throw all GP tables and finde the size of each field and calulate that number.
> > 
> > I have the following GP system:
> > POP module
> > FA module
> > And Financial Module
> > 
> > Any help?
> > 
> > Best regards,
0
3/19/2007 4:23:43 PM
That's pretty light duty for Dynamics GP and I would estimate somewhere in 
the nighborhood of 3GB over a 5 year span.

-Mike

-- 
Micheal LoPatriello
Coordinator,
Luna Development
mlopat@lunadevelopment.com
http://www.lunadevelopment.com


"Hasan Ghannam" wrote:

> Thank you Micheal for your response.
> 
> I get your point. If the number of transaction will be as following 500 
> transaction per month on POP module. and anothre 1000 transaction per month 
> on FA & Financial Module? what is the size will be in this case?
> 
> Regards,
> 
> "Micheal LoPatriello" wrote:
> 
> > Hi Hasan,
> > It really depends on the number of transactions that go through your system. 
> > If I had to guess at an average, I would say a database in use for 3-5 years 
> > would be only a couple of a gigabytes, but this varies dramaticaly based on 
> > the number of transactions.
> > 
> > -Mike
> > 
> > -- 
> > Micheal LoPatriello
> > Coordinator,
> > Luna Development
> > mlopat@lunadevelopment.com
> > http://www.lunadevelopment.com
> > 
> > 
> > "Hasan Ghannam" wrote:
> > 
> > > Dears,
> > > 
> > > I was looking for a document that give me an idea or talking about how to 
> > > estimate Microsoft Dynamics GP database Growth and size. Any one could help 
> > > me in this?
> > > 
> > > I found an article on MSDN but it is about SQL server and it needs to go 
> > > throw all GP tables and finde the size of each field and calulate that number.
> > > 
> > > I have the following GP system:
> > > POP module
> > > FA module
> > > And Financial Module
> > > 
> > > Any help?
> > > 
> > > Best regards,
0
mlopat (88)
3/19/2007 4:28:21 PM
Reply:

Similar Artilces:

SQL in Excel data
Hi all, Is there a possibility/way to run an SQL query in an excel data sheet? I have quite some data like the sample below, now i would like to have the sum of spending for each person. Like it is possible in Access. A1 B1 Field1 Field2 Chuck 12,89 Mike 23,09 Jean 9,34 Chuck 30,00 Mike 3,80 Chuck 22,00 Mike 7,23 Jean 10,55 Jean 10,75 Jean 31,45 Chuck 19,99 Result Field1 SumOfField2 Chuck 84,88 Jean 62,09 Mike 34,12 Advice would be appriciated. Cheers, Ludovic Hi You could use a formula like this ...

How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from the following XML file: <?xml version="1.0" encoding="utf-8" ?> <Robot xmlns="http://tempuri.org/RobotDefaults.xsd"> <Parameters> <Name>Decker</Name> </Parameters> <Parameters> <Name>A</Name> </Parameters> <Parameters> <Name>B</Name> </Parameters> </Robot> There will be more data than just a name for each Parameters node. Here is my code: Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...

error sending from 5.5 to 2000
When a user sends from an exchange 5.5 mailbox to a user in exchange 2000, they receive the following error: The message was undeliverable because the recipient specified in the recipient postal address was not known at this address The MTS-ID of the original message is: c=US;a= ;p=Express-Scripts;l=TEMMS014-041001192533Z-210060 <mail5.express-scripts.com #5.1.1> The same user on the 5.5 server can send to other users on the 2000 server. I looked the error up in technet and got 3 kb articles with only 1, kb295377 being anything close to my problem. I checked the entr...

Microsoft Outlook 2002 #3
How can I allow Level 1 files into Outlook 2002, I keep getting the following message "Outlook blocked access to the following potentially unsafe attachments" Thanks, Stephen Some options here http://www.slipstick.com/outlook/esecup/getexe.htm "spike" <stephen@just4u.ie> wrote in message news:090201c35c10$19100be0$a601280a@phx.gbl... > How can I allow Level 1 files into Outlook 2002, I keep > getting the following message "Outlook blocked access to > the following potentially unsafe attachments" > > Thanks, > > Stephen ...

How to get paper size from dmPaperSize returned from GetDevMode?
For example, dmPaperSize returns 1 which is DMPAPER_LETTER, how do I calculate the paper size like in this case 8.5"x11"? There are so many paper sizes, is there any function call to calculate based on the return value of dmPaperSize or mapping between the value of dmPapersize and actual size? Thank you. The reason I asked the question was because dmPaperLength and dmPaperWidth are 0 for some printers. Also, my HP laserjet returns as a color printer (dmColor = 2) from GetDevMode call. Anyone knows why? ...

Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my classes.(Alphabetized names down left vertical column. Dates across top of horizontal row.) I added a different color to all cells in every other row to make for easier reading of each student's name and absences. Every other row stays with a white background. My question: I wondered if it was possible to lock row colors while allowing data to change on top of them. If a new student is added to my class in alphabetical order, the alternating color pattern is often lost. It is a pain to rechange row and cell colors. Any shortcut ...

How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data.. Refresh Data to requery the source, but I want to be able to do it in a more automated way. Is there some sort of macro I can write when opened or something? Thanks, Ron Ron, Select the cell the data starts in, select Data/Import External Data/Data Range Properties Check the box "Refresh on file open" and anything else that needs checking off... Other than that, you could record a new Macro that selects your cell, refreshes data, and assign the macro to a keystroke, or even an icon. Beege ...

Cannot reinstall Exchange 5.5 on Small Business Server 4.5
Our Small Business Server 4.5 crashed yesterday and could only be started by doing a repair of Windows NT. Unfortunately, this left the Small Business Server programs partially installed. Now, Exchange will not start. It has the message "A connection could not be made to the Microsoft Exchange Server". I tried to reinstall Exchange, but get the message "This component is already installed and cannot be modified". Microsoft Exchange does not appear under Add/Remove Programs, so I cannot uninstall it either. Any suggestions would be greatly appreciated. Deborah obxgi...

Ex5.5 to Ex2003 intra org migration
Hi I have migrated from E5.5 to E2003 intra-Org migration and chose the option SID migration via ADMT during migration . I 've notice that both source domain and target domain accounts have been added to mailbox and public folder resources which doesn't appear to be a problem at the moment. However in the near future when I do decide to remove the source domain would I be left with "zombie" source domain accounts??? In addition, granted that I chose to migrate SID history what will be the result when the source Doman is remove. Will there be any performance impact ??...

Replication partner exch 5.5 crashed
Hello Everyone. We recently installed exchange server 2003, had it coexisting with exchange 5.5 . We used the pfmigrate tool to create replication of public folders,I had also moved around 75% of the users mail boxes to the 2003 server.Unfortunately Ifound out that the exchange 5.5 server has crashed and now we cannot send or receive emails because earlier the mail flow was from 2003 to 5.5 and internet and vice versa. How can I remove the 5.5 server and set the 2003 server to receive emails completely. Also I do have a backup of the 5.5 server , can I restore the 5.5 mail box to t...

Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be missing something here. Some data on vendor numbers changed. Let’s say IBM used to have a vendor number 12345 and now it’s vendor number is 56789. I can identify IBM as IBM, but I really want to use the number, not the name. Should I set up a table that ties the numbers together, so that Access knows 12345 = 56789? Or, should I do some kind of Update Query and change all incidences of 12345 to be 56789? Or, is there some other, method, like a ‘best practices for missing data’? Thanks! Ryan--- ...

Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders File (.pst). I understand the basic "Office Outlook Personal Folders File (.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002 Personal Folders File (.pst) to create a new Outlook .pst file that is compatible with earlier versions of Outlook." When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003, when adding PST's you can chosse either of the two file type options and browse to chos...

New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet via a macro, a new named range (for the same range) is created. This does not pose a problem, but after a while, I'll have a huge number of named ranges that will never be used. Why does Excel name the range and how can I stop this? I noticed in the recorded macro, there was a line .Name = "drd_5". I commented this out to see what would happen, but it just renamed the range "ExternalData_5". The next one was "ExternalData_6", etc. Thanks, Carroll Rinehart You could refresh with differen...

how do i rotate a 3 shift 200man schedule
like 80 people on two shifts and 40 on the third. i want to move small shift to day and slide half of day into swing and half of swing into graveyard. any suggestions? thanks in advance. First rotation: pick the first 40 people (by alphabetic order) from the larger groups to rotate to the next shift. Each subsequent rotation: move the group of 40 that did not move the last time. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <6F26D7D8-3A2F-4663-BE17-F0EF1AD26A3D@microsoft...

Help please user not showing in 5.5 GAL but is in exchange 2003 GA
Up until today I have been bable to add users fine and their address would appear in both the 5.5 GAL and the exchange 2003 GAL. Is a single site with 2 5.5 servers and 1 exchange 2003 server. When I add a new user now through users and computers and put the mailbox on the new exchange 2003 server the user gets his email addresses and appears in the GAL on the 2003 server but people connected the the old 5.5 servers cannot see it. When I open the 5.5 exchange admin tool again if connected to one of the old 5.5 server I cannot see the person I just created but when connected the the 20...

Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a popup asking for the value of those 2 columns. The problem is, I don't use those columns so I need to find what on the form is refferencing the deleted columns. I have looked at the control drop down on the properties window and the tab order window and can't find a control with either one of the missing column names. How do I determine what is trying to refference the deleted columns? I found the problem, the column was still referenced in the underlying query that fed the form. "MeSteve"...

Migrating E5.5/NT4 to E2003/W2K
I am going to be migrating E5.5 to E2003 very soon Can anyone please give me tips as I would like to avoid as many probs a possible. I can use the same IP, Domain name etc Thanks in Advance Hi, Done a few of those You could do an in-place upgrade but you must be absolutely sure about your backups. For me, the easiest (and probably safest) way is to do a new installation of 2003 and run the two systems in parralel until all users have been migrated to the new system before shutting down the old system. I short: Suppose you have alias@demo.com as your current e-mail domain: 1. Create a...

Become MCSE Certified and get $43,000+ Salary per year
QmVjb21lIE1DU0UgQ2VydGlmaWVkIGFuZCBnZXQgJDQzLDAwMCsgU2FsYXJ5IHBlciB5ZWFyCkhp LApTdGFydCB5b3VyIGJyaWdodCBjYXJlZXIgd2l0aCBNQ1NFIENlcnRpZmljYXRpb24gYW5kIGdl dCAkNDMsMTIyLjUwCihhY2NvcmRpbmcgdG8gYWJvdXQuY29tIHNhbGFyeSBzdXJ2ZXkpLiBWaXNp dCBodHRwOi8vd3d3LkZyZWVFeGFtS2luZy5jb20KZm9yIE1DU0UgQ2VydGlmaWNhdGlvbiwgRnJl ZSBQcmFjdGljZSBFeGFtcywgRnJlZSBTdHVkeSBNYXRlcmlhbCAvCkJvb2tzIGFuZCBGcmVlIER1 bXBzIIWFCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09Cg== ...

Chart Wizard #5
Does excel 2007 have a chart wizard? If so, how do I access it? The chart wizard no longer exists in Excel 2007, RIP. You create a chart using the various chart buttons on the Insert tab, then struggle through the three Chart Tools contextual tabs looking for the controls to set up the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Liberty" <Liberty @discussions.microsoft.com> wrote in message news:7C1186EF-4C15-4E3D-A642-D0EA334C1192@microsoft.com... > Does excel...

merging data
Hi all:) I'm new to this forum and to to Excel (2000) and not sure that I'm asking this question correctly but here is what I'm trying to do. The data on my work sheet is pasted from another sorce and includes information: name, ref #, time, date. I use this information looking up the status of an order and enter a "status note" in 5th (last) column. As the day progresses, the source that the data comes from is copied and pasted under the current list I already have going and much of the data on the lower list is a duplicate. How can I merge the to list so that I hav...

Frequency #3
I'm using excel with phstat add-in. How do I graph so that the units of the variable are along the x-axis and just the count or frequency is along the y-axis? Secondly, how would I get excel to plot or i.d. the mean and the standard deviation units along the x-axis? Thanks for your help. wrace. Wrace - You might need to devote an additional section of your worksheet to condition the data for plotting. I don't know about phstat, so I don't know how extensively you will need to adjust your data. To put a vertical line where the mean and SD are located, check out this web pa...

CRM 3.0 Locks up Outlook
I have tried to re-install, tried repair nothing works. What is the deal with this software??????? Hi Mark, Do you own alot of contacts in the CRM system? If so, you first time starting the application after the installation will probably take a long time because it synchronize all your contacts to your Outlook. If you don't want the initial sync, you need to disabled the sync by going to your personal settings in CRM or the registry on your laptop. Darren Liu Crowe Chizek http://www.crowecrm.com On Jul 27, 2:36 pm, Mark <M...@discussions.microsoft.com> wrote: > I have tried ...

auto fill in data when changing fields
i new to crm 4 and i would like to; once i selected the account i need it to grab the main phone and put it in the phone field, and could you tell me where i need to do this, thanks -- j.hardy you can modify the mappings of the corresponding relationship "moon" wrote: > i new to crm 4 and i would like to; once i selected the account i need it to > grab the main phone and put it in the phone field, and could you tell me > where i need to do this, thanks > -- > j.hardy ...

screen size
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there anyway to make a word document take up more screen area? I have a 20&quot; screen and when word opens it only takes up about a third of the screen area? never mind I just figured it out! Word opens each document at the window size and zoom ratio it was last saved at. To set this for blank documents, you need to re-save your Normal template. Unless you have moved it, it should be in /Users/~/Library/Application Support/Microsoft/Office/User Templates/ CLOSE all other documents, then u...

Pivot Table data values
I need make a pivot table using the values as the data. I used to be able to do this, but now it only sums, counts or calculates. Is there a way to return the data values? ...