Database architecture – MS SQL 2000 and SAP R/3 4.6C




 I am upgrading the disk arrays on my production server over the Christmas holiday, and would love to hear some opinions on how you would recommend partitioning the new array.

Currently, I have four disk arrays on the production server, divided into four drive letters (and hence four database files) for a total database size of approximately 305 GB.

Tentatively, I am thinking of making the new array one single drive letter (this would be approximately 870 GB) and locating the four database files on that volume, allowing only the fourth file to grow as required.

Your thoughts and opinions on this configuration would be appreciated. Thank you!

Sylv
Are these disks part of some sort of RAID setup? It doesn’t sound like it is, in which case striping the drives would, if one of the drives failed, result in the loss of all files on the drives…that’s a pretty risky strategy in any environment, whether development or production. You might want to read up on RAID configurations before deciding how you want to reconfigure your drives.
it might be that the drives were formatted as 1tb, if you do a factory restore it might format the drives to the 2tb. you will lose your data though. as i had the time, thought i would tidy things up, just one custom query needed, no view required. just change the office names and copy/paste into a custom query 
have a great christmas party! 
select sum(office1) as office1,sum(office2) as office2,sum(office3) as office3,hours from 
((select 
cou… you might be able to use synchronize. if you have more than 2 tables, you will need to use it multiple times. If you're unsure of writing joins in SQL use an SQL builder.


Top of my list is still SQLeo which is java based. If you make a small donation you get the full thing, you only need to donate a dollar.


Others are navicat but they have a trial not sure if it is only available to windows either. i found the solution, if i select another option in the backup configuration settings, it is possible to enable the "split file" option.

thanks again for your help!

zeno this is a terrific question and i am glad you asked it.  as i am only in the beginning stages of planning to implement this here (it has not been a requirement yet, but will be soon), i can only add some preliminary thoughts to yours:

microsoft should bold, underline, highlight, and add 50 exclamation points to that statement about keeping queues to a minimum.  the performance hit is staggering, if your system has a high number of concurrent users.  you probably won't notice it in your dev or test environments if there aren't many simultaneous testers, however.

so in the spirit of getting the most protection from the fewest number of queues, i am asking some of the following questions:
* is it sufficient to classify ticket data along the lines of "sensitive, private, privileged" or some other such division, so that i could only create queues based on the sensitivity level of information, and not have to split it further by department/team/function/etc.?  this is a business question that will vary for everyone, of course.
* if the above is possible, i can add a classification enum to the tickets and develop a procedure for which should be selected, and base the queue on its value.  if it is not, or if my ticket category or support team already tells me what i need to know, then this is not even necessary.
* if data sensitivity is not a viable way to divide queues, then do i have certain support groups that need a queue, and all others would not belong to a queue?

in any scenario i have described or implied, this means that (most) teams can see each others' tickets.  this is not a problem for me in this environment, but might be for others.  as long as i wrap a queue around the most sensitive tickets, i do not mind if the rest are out in the open.

again, i have not proven these thoughts in production yet, but hopefully it helps to some degree. hi paul,

i believe the financial reporting covers in quite a lot of detail exactly what you are looking for.

from what i can tell you aren’t using templates in your tables…

[[image]](https://forum.enterprisedna.co/uploads/db7134/original/2x/5/559a333f85c159c8d9bec9235ca5c45997d08858.png "image")

if you want to get a certain order and custom table then you really need to use the template approach covered in t… For anyone having similar problems, I have solved my issue. It was several-fold.


* As Darren suggested and Paul backed up, the Max..Size properties in the configuration needed to be enlarged. The SvcTraceViewer utility helped in determining this, but it still does not always give the most helpful error messages.
* It also appears that when the Service Reference is updated on the client side, the configuration will sometimes not update properly (e.g. Changing config values on the server will not always properly update on the client. I had to go in and change the Max..Size properties multiple times on both the client and server sides in the course of my debugging)
* For a DataTable to be serializable, it needs to be given a name. The default constructor does not give the table a name, so:



```
return new DataTable();

```

will not be serializable, while:



```
return new DataTable("someName");

```

will name the table whatever is passed as the parameter. 


Note that a table can be given a name at any time by assigning a string to the `TableName` property of the DataTable.



```
var table = new DataTable();
table.TableName = "someName";

```


Hopefully that will help someone. Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. You can provide an optional parameter to the scaffolding command to update only the table you target.



```
Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir DirectoryNameOfYourModels -Tables employee -f

```

If you are using .net core cli then use.



```
dotnet ef dbcontext scaffold "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -o DirectoryNameOfYourModels -t employee -f

```