Solved

Quick Question - Transaction Processing/Database Design

Posted on 1998-12-14
3
175 Views
Last Modified: 2010-03-19
Since transaction performance is critical (for large companies), in terms of the average number of transactions per minute and the average & maximum transaction response time, how does MS SQL allow the DBA to address this and related issues when configuring the system.

Also, does MS SQL provide any assistance to ensure that a database is in any Normal form.  I'm aware that the system will not allow conflicting itegrity constraints but that in its self doesn't address Normal forms.
0
Comment
Question by:John500
  • 2
3 Comments
 

Author Comment

by:John500
ID: 1092274
Edited text of question
0
 
LVL 3

Accepted Solution

by:
cognition earned 50 total points
ID: 1092275
SQL allows you to monitor a great deal of differnet statistics, using performance monitor. These include transaction levels, log space, maximum transactions and a host of other information. There are also DBCC commands that prodcue the same information, which could be used to create a customised monitoring tool.

Use of the monitoring tools ,and good use of indexes, and design will help to reduce the transaction levels. It also depends on what ype of system SQL Server is being used for.

There is nothing in SQL that helps enforce normal forms. Only a good database design can do that. I find that ERWin helps a great deal when designing databases. If SQL Server enforced normal forms, then you would not be able to de-normalize if required.


0
 

Author Comment

by:John500
ID: 1092276
Thanks, regarding normal forms, I should have known that!

John
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now